private void FillServicelevel()
{
//objSQLdb = new SQLDB();
objServicedb = new ServiceDB();
DataTable dt = new DataTable();
cbLevels.DataSource = null;
try
{
dt = objServicedb.GetServiceLevels(CommonData.CompanyCode, CommonData.BranchType).Tables[0];
//string strCmd = "SELECT desig_code,desig_name,ndesig_name FROM DESIG_MAS "+
// " WHERE dept_code IN(800000) ORDER BY ndesig_name ";
//dt = objSQLdb.ExecuteDataSet(strCmd).Tables[0];
if (dt.Rows.Count > 1)
{
DataRow dr = dt.NewRow();
dr[0] = "0";
dr[1] = "--Select--";
dt.Rows.InsertAt(dr, 0);
cbLevels.DataSource = dt;
cbLevels.DisplayMember = "desig_name";
cbLevels.ValueMember = "desig_code";
}
dt = null;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
objServicedb = null;
}
}
private void FillGroupMappedSourceData(string strBCode, string strSCode)
{
objServicedb = new ServiceDB();
DataTable dt = new DataTable();
string strLogBcode = string.Empty;
string strLoadedEcode = string.Empty;
string[] strDestCode = ((NewCheckboxListItem)(clbDestination.SelectedItem)).Tag.Split('~');
clbSource.Items.Clear();
try
{
dt = objServicedb.LevelGroupServiceEcodeMapped_Get(CommonData.CompanyCode, strBCode, strSCode, Convert.ToInt32(strDestCode[0]), Convert.ToInt32(cbLevels.SelectedValue.ToString()), strLogBcode).Tables[0];
if (dt.Rows.Count > 0)
{
foreach (DataRow dataRow in dt.Rows)
{
if (dataRow["mapped"].ToString() == "999999")
{
cbGroupCamp.Text = dataRow["GroupName"].ToString();
cbLogcalBranch.Text = dataRow["logBranchName"].ToString();
NewCheckboxListItem oclBox = new NewCheckboxListItem();
oclBox.Tag = dataRow["ECODE"].ToString();
oclBox.Text = dataRow["ENAME"].ToString();
clbSource.Items.Add(oclBox);
oclBox = null;
}
else
{
if (strDestCode[0].IndexOf(dataRow["ECODE"].ToString().Substring(0, dataRow["ECODE"].ToString().IndexOf("~"))) < 0)
{
cbGroupCamp.Text = dataRow["GroupName"].ToString();
cbLogcalBranch.Text = dataRow["logBranchName"].ToString();
NewCheckboxListItem oclBox = new NewCheckboxListItem();
oclBox.Tag = dataRow["ECODE"].ToString();
oclBox.Text = dataRow["ENAME"].ToString();
if (!strLoadedEcode.Contains(dataRow["ECODE"].ToString()))
{
clbSource.Items.Add(oclBox, CheckState.Checked);
}
strLoadedEcode += dataRow["ECODE"].ToString() + ",";
//clbSource.Items.Add(oclBox, CheckState.Checked);
oclBox = null;
}
}
}
}
dt = null;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
objServicedb = null;
}
}
private void FillEmployeeData()
{
objServiceDB = new ServiceDB();
ds = objServiceDB.GetECodesforService(BranchCode, DeptCode);
UtilityLibrary.PopulateControl(cmbEmployee, ds.Tables[0].DefaultView, 1, 0, "-- Please Select --", 0);
objServiceDB = null;
}
public List <Service> ListBasicService()
{
ServiceDB serDB = new ServiceDB();
DataTable data = serDB.GetFullServiceInfo();
return(GetBasicServices(data));
}
public List <Service> ListServices()
{
ServiceDB serDB = new ServiceDB();
DataTable data = serDB.GetFullServiceInfo();
DataTable data2 = serDB.GetFullPetReservationServiceInfo();
return(GetServices(data, data2));
}
public void GetFreeOfferProducts(int iOfficeNo)
{
if (cbBranch.SelectedValue != null)
{
oServiceDB = new ServiceDB();
DataSet ds = oServiceDB.GetFreeOfferProducts(cbCompany.SelectedValue.ToString(), cbBranch.SelectedValue.ToString(), CommonData.FinancialYear, iOfficeNo);
if (ds.Tables[0].Rows.Count > 0)
{
lblOfferID.Text = "1";
btnDelete.Enabled = true;
txtOfferNo.Text = ds.Tables[0].Rows[0]["FPM_OFFER_NUMBER"].ToString();
txtDescription.Text = ds.Tables[0].Rows[0]["FPM_OFFER_DESCRIPTION"].ToString();
string status = ds.Tables[0].Rows[0]["FPM_OFFER_STATUS"].ToString();
if (status.ToUpper() == "RUNNING")
{
chkActive.Checked = true;
}
else
{
chkActive.Checked = false;
}
dtFromdate.Value = ds.Tables[0].Rows[0]["FPM_OFFER_VALID_FROM"].ToString() == "" ? Convert.ToDateTime(CommonData.CurrentDate) : Convert.ToDateTime(ds.Tables[0].Rows[0]["FPM_OFFER_VALID_FROM"]);
txtToDate.Text = ds.Tables[0].Rows[0]["FPM_OFFER_VALID_TO"].ToString() == "" ? Convert.ToDateTime(CommonData.CurrentDate).ToString("dd/MM/yyyy") : Convert.ToDateTime(ds.Tables[0].Rows[0]["FPM_OFFER_VALID_TO"]).ToString();
if (ds.Tables[0].Rows[0]["FPM_OFFER_STATUS"].ToString() == "RUNNING")
{
chkActive.Checked = true;
}
else
{
chkActive.Checked = false;
}
}
else
{
btnDelete.Enabled = false;
chkActive.Checked = true;
lblOfferID.Text = "0";
}
if (ds.Tables[1].Rows.Count > 0)
{
cmbProducts.SelectedValue = ds.Tables[1].Rows[0]["ProductID"].ToString();
txtQty.Text = ds.Tables[1].Rows[0]["FPMS_SOLD_UNITS"].ToString();
txtMinQty.Text = ds.Tables[1].Rows[0]["MinUnits"].ToString();
txtMaxQty.Text = ds.Tables[1].Rows[0]["MaxUnits"].ToString();
}
else
{
cmbProducts.SelectedIndex = 0;
txtQty.Text = "";
txtMinQty.Text = "";
txtMaxQty.Text = "";
}
if (ds.Tables[2].Rows.Count > 0)
{
dtFreeProducts(ds.Tables[2]);
}
}
}
public BllStatus UpdateStatus(BllStatus entity)
{
using (ServiceDB serviceDB = new ServiceDB())
{
IUnitOfWork uow = new UnitOfWork(serviceDB);
IStatusService service = new StatusService(uow);
return(service.Update(entity));
}
}
public List <BllEventType> GetAllEventTypes()
{
using (ServiceDB serviceDB = new ServiceDB())
{
IUnitOfWork uow = new UnitOfWork(serviceDB);
IEventTypeService EventTypeService = new EventTypeService(uow);
return(EventTypeService.GetAll().ToList());
}
}
public List <BllAttribute> GetAllAttributes()
{
using (ServiceDB serviceDB = new ServiceDB())
{
IUnitOfWork uow = new UnitOfWork(serviceDB);
IAttributeService AttributeService = new AttributeService(uow);
return(AttributeService.GetAll().ToList());
}
}
public List <BllStatus> GetAllStatusesExceptDeletedAndClosed()
{
using (ServiceDB serviceDB = new ServiceDB())
{
IUnitOfWork uow = new UnitOfWork(serviceDB);
IStatusService service = new StatusService(uow);
return(service.GetAllStatusesExceptDeletedAndClosed());
}
}
public void DeleteUser(int id)
{
using (ServiceDB serviceDB = new ServiceDB())
{
IUnitOfWork uow = new UnitOfWork(serviceDB);
IUserService service = new UserService(uow);
service.Delete(id);
}
}
public BllUser UpdateUser(BllUser entity)
{
using (ServiceDB serviceDB = new ServiceDB())
{
IUnitOfWork uow = new UnitOfWork(serviceDB);
IUserService service = new UserService(uow);
return(service.Update(entity));
}
}
public BllGroup UpdateGroup(BllGroup entity)
{
using (ServiceDB serviceDB = new ServiceDB())
{
IUnitOfWork uow = new UnitOfWork(serviceDB);
IGroupService service = new GroupService(uow);
return(service.Update(entity));
}
}
public List <BllUser> GetAllUsers()
{
using (ServiceDB serviceDB = new ServiceDB())
{
IUnitOfWork uow = new UnitOfWork(serviceDB);
IUserService UserService = new UserService(uow);
return(UserService.GetAll().ToList());
}
}
public BllAttribute UpdateAttribute(BllAttribute entity)
{
using (ServiceDB serviceDB = new ServiceDB())
{
IUnitOfWork uow = new UnitOfWork(serviceDB);
IAttributeService service = new AttributeService(uow);
return(service.Update(entity));
}
}
public List <BllGroup> GetAllGroups()
{
using (ServiceDB serviceDB = new ServiceDB())
{
IUnitOfWork uow = new UnitOfWork(serviceDB);
IGroupService GroupService = new GroupService(uow);
return(GroupService.GetAll().ToList());
}
}
public bool IsContainsWithName(string name)
{
using (ServiceDB serviceDB = new ServiceDB())
{
IUnitOfWork uow = new UnitOfWork(serviceDB);
IStatusService service = new StatusService(uow);
return(service.IsContainsWithName(name));
}
}
public void DeleteAttribute(int id)
{
using (ServiceDB serviceDB = new ServiceDB())
{
IUnitOfWork uow = new UnitOfWork(serviceDB);
IAttributeService service = new AttributeService(uow);
service.Delete(id);
}
}
public BllStatus GetStatusClosed()
{
using (ServiceDB serviceDB = new ServiceDB())
{
IUnitOfWork uow = new UnitOfWork(serviceDB);
IStatusService service = new StatusService(uow);
return(service.GetStatusClosed());
}
}
public void DeleteEventType(int id)
{
using (ServiceDB serviceDB = new ServiceDB())
{
IUnitOfWork uow = new UnitOfWork(serviceDB);
IEventTypeService service = new EventTypeService(uow);
service.Delete(id);
}
}
public List <BllStatus> GetAllStatuses()
{
using (ServiceDB serviceDB = new ServiceDB())
{
IUnitOfWork uow = new UnitOfWork(serviceDB);
IStatusService statusService = new StatusService(uow);
return(statusService.GetAll().ToList());
}
}
public BllEventType UpdateEventType(BllEventType entity)
{
using (ServiceDB serviceDB = new ServiceDB())
{
IUnitOfWork uow = new UnitOfWork(serviceDB);
IEventTypeService service = new EventTypeService(uow);
return(service.Update(entity));
}
}
private void AddReplacementDetails_Load(object sender, EventArgs e)
{
objServiceDB = new ServiceDB();
string strCmd = "";
DataTable dt = new DataTable();
ds = objServiceDB.GetECodesforService(BranchCode, DeptCode);
FillCompanyData();
cbCompany.Enabled = false;
cmbBranch.Enabled = false;
txtProdName.ReadOnly = true;
cmbFinYear.Enabled = false;
txtActivityName.ReadOnly = true;
txtActualQty.ReadOnly = true;
txtInvNo.ReadOnly = true;
dtpActivityDate.Value = DateTime.Today;
objServiceDB = null;
UtilityLibrary.PopulateControl(cmbBranch, ds.Tables[1].DefaultView, 1, 0, "-- Please Select --", 0);
objSQLdb = new SQLDB();
if (dtActDetl.Rows.Count > 0)
{
objSQLdb = new SQLDB();
strCmd = "SELECT TNA_COMPANY_CODE " +
",TNA_BRANCH_CODE, TNA_QTY " +
",TNA_ORDER_NUMBER,TNA_INVOICE_NUMBER " +
",(TNA_QTY-sum(TNA_ACTIVITY_QTY)) as Qty " +
" FROM SERVICES_TNA " +
" WHERE TNA_COMPANY_CODE='" + CommonData.CompanyCode +
"' AND TNA_BRANCH_CODE='" + dtActDetl.Rows[0]["BranCode"].ToString() +
"' AND TNA_INVOICE_NUMBER=" + dtActDetl.Rows[0]["InvNo"].ToString() +
" AND TNA_ATTEND_BY_ECODE IS not null " +
" and TNA_PRODUCT_ID='TKPRYL0000' and TNA_ACTIVITY_ID IN ('13','18','19') " +
" GROUP BY TNA_COMPANY_CODE,TNA_BRANCH_CODE,TNA_QTY,TNA_ORDER_NUMBER,TNA_INVOICE_NUMBER";
dt = objSQLdb.ExecuteDataSet(strCmd).Tables[0];
if (dt.Rows.Count > 0)
{
txtActualQty.Text = dt.Rows[0]["Qty"].ToString();
}
else
{
txtActualQty.Text = dtActDetl.Rows[0]["Qty"].ToString();
}
cmbBranch.SelectedValue = dtActDetl.Rows[0]["BranCode"].ToString();
cmbBranch_SelectedIndexChanged(null, null);
txtInvNo.Text = dtActDetl.Rows[0]["InvNo"].ToString();
txtProdName.Text = dtActDetl.Rows[0]["ProdName"].ToString();
txtActivityName.Text = ActivityName;
cmbFinYear.Text = dtActDetl.Rows[0]["FinYear"].ToString();
}
}
public e Update(int petResNum, int serviceNumber)
{
e errCode = e.success;
ServiceDB serDB = new ServiceDB();
if (serDB.Add(petResNum, serviceNumber) < 0)
{
errCode = e.insertFail;
}
return(errCode);
}
public e DeleteServ(int petResNum, int servNum)
{
e errCode = e.success;
ServiceDB serDB = new ServiceDB();
if (!serDB.DeleteServiceForPet(petResNum, servNum))
{
errCode = e.insertFail;
}
return(errCode);
}
public e Delete(int petResNum)
{
e errCode = e.success;
ServiceDB serDB = new ServiceDB();
if (!serDB.DeletePetReservation(petResNum))
{
errCode = e.insertFail;
}
return(errCode);
}
private void FillMappedGroupDataToGrid()
{
objServicedb = new ServiceDB();
DataTable dt = new DataTable();
string strLogBcode = string.Empty;
gvMappedGroups.Rows.Clear();
try
{
dt = objServicedb.LevelServiceMappedGroupList_Get(CommonData.CompanyCode, CommonData.BranchCode, CommonData.StateCode).Tables[0];
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
DataGridViewRow tempRow = new DataGridViewRow();
DataGridViewCell cellECODE = new DataGridViewTextBoxCell();
cellECODE.Value = dt.Rows[i]["ECODE"];
tempRow.Cells.Add(cellECODE);
DataGridViewCell cellGROUPName = new DataGridViewTextBoxCell();
cellGROUPName.Value = dt.Rows[i]["GroupName"];
tempRow.Cells.Add(cellGROUPName);
DataGridViewCell cellGroupEname = new DataGridViewTextBoxCell();
cellGroupEname.Value = dt.Rows[i]["ENAME"];
tempRow.Cells.Add(cellGroupEname);
DataGridViewCell celllogBranchCode = new DataGridViewTextBoxCell();
celllogBranchCode.Value = dt.Rows[i]["logBranchCode"];
tempRow.Cells.Add(celllogBranchCode);
DataGridViewCell cellLogicalBranch = new DataGridViewTextBoxCell();
cellLogicalBranch.Value = dt.Rows[i]["logBranchName"];
tempRow.Cells.Add(cellLogicalBranch);
gvMappedGroups.Rows.Add(tempRow);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
objServicedb = null;
dt = null;
}
}
public void GetECodeData(string BranchCode)
{
objServiceDB = new ServiceDB();
DataSet dsData = objServiceDB.GetECodesforService(BranchCode, DeptCode);
objServiceDB = null;
UtilityLibrary.PopulateControl(cmbEmployee, dsData.Tables[0].DefaultView, 1, 0, "-- Please select --", 0);
//if (sCheckVal == "1")
//{
// if (sEcode != "")
// cmbEmployee.SelectedValue = sEcode.Split('-')[0].ToString();
//}
}
public List <BllUser> GetUsersByGroup(BllGroup group)
{
try
{
using (ServiceDB serviceDB = new ServiceDB())
{
IUnitOfWork uow = new UnitOfWork(serviceDB);
IUserService userService = new UserService(uow);
return(userService.GetUsersByGroup(group.Id));
}
}
catch (Exception ex)
{
LogWriter.WriteMessage("GetUsersByGroup", ex.Message + ex.InnerException, group.Name);
return(null);
}
}
public List <BllUser> GetUsersByGroupAndSignInDateRange(BllGroup group, int permissibleRangeInDays)
{
try
{
using (ServiceDB serviceDB = new ServiceDB())
{
IUnitOfWork uow = new UnitOfWork(serviceDB);
IUserService userService = new UserService(uow);
return(userService.GetUsersByGroupAndSignInDateRange(group.Id, permissibleRangeInDays));
}
}
catch (Exception ex)
{
LogWriter.WriteMessage("GetUsersByGroupAndSignInDateRange", ex.Message + ex.InnerException, group.Name);
return(null);
}
}
