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)); }