public DataTable getPaymentInfoall(BALAgentPayment obj)
{
try
{
SqlConnection cn = new SqlConnection(strCon);
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = new SqlCommand("[dbo].[sp_agentPayement]", cn);
da.SelectCommand.Parameters.Clear();
da.SelectCommand.Parameters.AddWithValue("@Action", "getPaymentInfoall");
da.SelectCommand.CommandType = CommandType.StoredProcedure;
cn.Open();
da.SelectCommand.ExecuteReader();
DataTable dtReturnData = new DataTable();
cn.Close();
da.Fill(dtReturnData);
if (dtReturnData != null)
{
return(dtReturnData);
}
else
{
return(null);
}
}
catch (Exception ex)
{
return(null);
}
}
public DataTable AgentInfo(BALAgentPayment obj)
{
try
{
SqlConnection cn = new SqlConnection(strCon);
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = new SqlCommand("[dbo].[sp_agentPayement]", cn);
da.SelectCommand.Parameters.Clear();
da.SelectCommand.Parameters.AddWithValue("@Action", obj._Action);
da.SelectCommand.Parameters.AddWithValue("@marketid", obj.MarketId);
da.SelectCommand.CommandType = CommandType.StoredProcedure;
cn.Open();
da.SelectCommand.ExecuteReader();
DataTable dtReturnData = new DataTable();
cn.Close();
da.Fill(dtReturnData);
if (dtReturnData != null && dtReturnData.Rows.Count > 0)
{
foreach (DataRow row in dtReturnData.Rows)
{
row["AgentName"] = DataSecurityManager.Decrypt(row["AgentName"].ToString());
row["AgentEmailId"] = DataSecurityManager.Decrypt(row["AgentEmailId"].ToString());
}
}
if (dtReturnData != null)
{
return(dtReturnData);
}
else
{
return(null);
}
}
catch (Exception exp)
{
return(null);
}
}
public int AddpaymentDetails(BALAgentPayment obj)
{
try
{
SqlConnection cn = new SqlConnection(strCon);
SqlDataAdapter da = new SqlDataAdapter();
da.InsertCommand = new SqlCommand("[dbo].[sp_agentPayement]", cn);
da.InsertCommand.Parameters.AddWithValue("@Action", obj._Action);
da.InsertCommand.Parameters.AddWithValue("@firstName", obj._FirstName);
da.InsertCommand.Parameters.AddWithValue("@lastName", obj._LastName);
da.InsertCommand.Parameters.AddWithValue("@EmailId", obj._EmailId);
da.InsertCommand.Parameters.AddWithValue("@Password", obj._Password);
da.InsertCommand.Parameters.AddWithValue("@AgentCode", obj._AgentCode);
da.InsertCommand.Parameters.AddWithValue("@billingAddress", obj._BillingAddress);
da.InsertCommand.Parameters.AddWithValue("@PaymentMethod", obj._PaymentMethod);
da.InsertCommand.Parameters.AddWithValue("@OnCredit", obj.OnCredit == true ? 1 : 0);
da.InsertCommand.Parameters.AddWithValue("@CreditLimit", obj.CreditLimit);
da.InsertCommand.Parameters.AddWithValue("@phoneNumber", obj.Phone);
da.InsertCommand.Parameters.AddWithValue("@Category", obj._category);
da.InsertCommand.Parameters.AddWithValue("@country", obj._country);
da.InsertCommand.Parameters.AddWithValue("@Commision", obj.comission);
da.InsertCommand.CommandType = CommandType.StoredProcedure;
cn.Open();
int Status = da.InsertCommand.ExecuteNonQuery();
cn.Close();
if (Status > 0)
{
return(Status);
}
else
{
return(0);
}
}
catch (Exception exp)
{
throw exp;
//return 0;
}
}
