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