Comments by Siffin (Top 3 by date)

[WebMethod]
//public string Gettest(string Token, string RETAILER_CODE, string RETAILER_ADDRESS, string RETAILER_LATITUDE, string RETAILER_LONGITUDE, string USER_CODE, string[] imeiList)
public string Gettest(string Token, string RETAILER_CODE, string RETAILER_ADDRESS, string RETAILER_LATITUDE, string RETAILER_LONGITUDE, string USER_CODE, string imeiList)

{

cmd = new OracleCommand();
try
{
dboConn = new OracleConnection(cString);
cmd.Connection = dboConn;
dboConn.Open();
cmd.Transaction = cmd.Connection.BeginTransaction();

if (TokenMatching == Token)
{
RetailerChk = Retailer(RETAILER_CODE, cmd);
if (RetailerChk == "1")
{

if (imeiList.Length > 0)
{
//gds = new DataSet();
//gds = InsertToMaster(RETAILER_CODE, RETAILER_ADDRESS, RETAILER_LATITUDE, RETAILER_LONGITUDE, USER_CODE, cmd);
//InvoiceMaster = gds.Tables[0].Rows[0][0].ToString();
//if (InvoiceMaster.Length > 0)
//{
//InsertToMaster(RETAILER_CODE, RETAILER_ADDRESS, RETAILER_LATITUDE, RETAILER_LONGITUDE, USER_CODE, cmd);
for (int i = 0; i < imeiList.Length; i++)
{
//ImeiChk = Imei(imeiList[i], cmd);
ImeiChk = Imei(imeiList, cmd);
if (ImeiChk == "1")
{
//InsertToDetails(InvoiceMaster, imeiList, USER_CODE, cmd);
//InsertToDetails(InvoiceMaster, imeiList[i], USER_CODE, cmd);
}
}
////}
Message = "Saved Successfully";
}

else
{
InsertToVisit(RETAILER_CODE, RETAILER_ADDRESS, RETAILER_LATITUDE, RETAILER_LONGITUDE, USER_CODE, cmd);
Message = "Retailer visit listed successfully";
}

}
else
{
Message = "Unauthorized Retailer Code";
}

}
cmd.Transaction.Commit();
return Message;
}
catch (Exception Ex)
{
cmd.Transaction.Rollback();

return Ex.Message;
}
finally
{
cmd.Connection.Close();
}
}
then when I call Imei(imeiList[i], cmd) this like this way and my code is as below

public string Imei(string Imei,OracleCommand cmd)
{
try
{
cmd.CommandText = "TRADING.p_user.select_user";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("cur_c1", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Parameters.Add("call_name", OracleDbType.Varchar2).Value = "Imei";
cmd.Parameters.Add("sel1", OracleDbType.Varchar2).Value = Imei;
cmd.Parameters.Add("sel2", OracleDbType.Varchar2).Value = "";
cmd.Parameters.Add("sel3", OracleDbType.Varchar2).Value = "";
cmd.Parameters.Add("sel4", OracleDbType.Varchar2).Value = "";

ds = new DataSet();
oda = new OracleDataAdapter(cmd);
ds = new DataSet();
oda.Fill(ds);
return ds.Tables[0].Rows.Count > 0 ? "1" : "0";

Yes I have tried with table.