private void BuildEntity(ICustomerAssign cust)
{
cust.Id = _custAssignId;
cust.ExistingUserId = Convert.ToInt32(ddlExisting.SelectedValue);
cust.NewUserId = Convert.ToInt32(ddlNew.SelectedValue);
cust.AssignType = Convert.ToChar(ddlType.SelectedValue);
cust.StartDate = Convert.ToDateTime(txtStartDt.Text, _culture);
if (cust.AssignType == 'T')
{
cust.EndDate = Convert.ToDateTime(txtEndDt.Text, _culture);
}
}
public static ICustomerAssign GetAssignedCustomer(int custAssignID)
{
string strExecution = "[common].[uspGetAssignedCustomerList]";
ICustomerAssign cust = null;
using (DbQuery oDq = new DbQuery(strExecution))
{
oDq.AddIntegerParam("@CustAssignID", custAssignID);
DataTableReader reader = oDq.GetTableReader();
while (reader.Read())
{
cust = new CustomerAssignEntity(reader);
}
reader.Close();
}
return(cust);
}
public static int SaveAssignedCustomer(ICustomerAssign customer, int modifiedBy)
{
string strExecution = "[common].[uspSaveAssignCustomer]";
int result = 0;
using (DbQuery oDq = new DbQuery(strExecution))
{
oDq.AddIntegerParam("@Id", customer.Id);
oDq.AddIntegerParam("@NewUserID", customer.NewUserId);
oDq.AddIntegerParam("@ExistingUserID", customer.ExistingUserId);
oDq.AddCharParam("@AssignType", 1, customer.AssignType);
oDq.AddDateTimeParam("@StartDate", customer.StartDate);
oDq.AddDateTimeParam("@EndDate", customer.EndDate);
oDq.AddIntegerParam("@ModifiedBy", modifiedBy);
oDq.AddIntegerParam("@Result", result, QueryParameterDirection.Output);
oDq.RunActionQuery();
result = Convert.ToInt32(oDq.GetParaValue("@Result"));
}
return(result);
}
public int SaveAssignedCustomer(ICustomerAssign customer, int modifiedBy)
{
return(CommonDAL.SaveAssignedCustomer(customer, modifiedBy));
}
