private void BuildGroupCompanyEntity(IGroupCompany groupCompany) { groupCompany.Id = _groupId; groupCompany.Name = txtName.Text.Trim().ToUpper(); groupCompany.Address.Address = txtAddress.Text.Trim().ToUpper(); groupCompany.Address.City = txtCity.Text.Trim().ToUpper(); groupCompany.Address.Pin = txtPin.Text.Trim().ToUpper(); groupCompany.Phone = txtPhone.Text.Trim().ToUpper(); if (chkActive.Checked) { groupCompany.IsActive = 'Y'; } else { groupCompany.IsActive = 'N'; } }
public string SaveGroupCompany(IGroupCompany groupCompany, int modifiedBy) { int result = 0; string errMessage = string.Empty; result = CommonDAL.SaveGroupCompany(groupCompany, modifiedBy); switch (result) { case 1: errMessage = ResourceManager.GetStringWithoutName("ERR00014"); break; default: break; } return(errMessage); }
public static int SaveGroupCompany(IGroupCompany groupCompany, int modifiedBy) { string strExecution = "[common].[uspSaveGroupCompany]"; int result = 0; using (DbQuery oDq = new DbQuery(strExecution)) { oDq.AddIntegerParam("@GroupId", groupCompany.Id); oDq.AddVarcharParam("@GroupName", 50, groupCompany.Name); oDq.AddVarcharParam("@Address", 200, groupCompany.Address.Address); oDq.AddVarcharParam("@City", 20, groupCompany.Address.City); oDq.AddVarcharParam("@Pin", 10, groupCompany.Address.Pin); oDq.AddVarcharParam("@Phone", 40, groupCompany.Phone); oDq.AddCharParam("@IsActive", 1, groupCompany.IsActive); oDq.AddIntegerParam("@ModifiedBy", modifiedBy); oDq.AddIntegerParam("@Result", result, QueryParameterDirection.Output); oDq.RunActionQuery(); result = Convert.ToInt32(oDq.GetParaValue("@Result")); } return(result); }
public static IGroupCompany GetGroupCompany(int groupCompanyId, char isActiveOnly, SearchCriteria searchCriteria) { string strExecution = "[common].[uspGetGroupCompany]"; IGroupCompany groupCompany = null; using (DbQuery oDq = new DbQuery(strExecution)) { oDq.AddIntegerParam("@GroupId", groupCompanyId); oDq.AddCharParam("@IsActiveOnly", 1, isActiveOnly); oDq.AddVarcharParam("@SortExpression", 50, searchCriteria.SortExpression); oDq.AddVarcharParam("@SortDirection", 4, searchCriteria.SortDirection); DataTableReader reader = oDq.GetTableReader(); while (reader.Read()) { groupCompany = new GroupCompanyEntity(reader); } reader.Close(); } return(groupCompany); }