protected void BtnSave_Click(object sender, EventArgs e)
{
int lintcnt = 0;
EntityRoomCategory entRoomCate = new EntityRoomCategory();
if (string.IsNullOrEmpty(txtCateCode.Text.Trim()))
{
lblMsg.Text = "Please Enter Category Code";
}
else
{
if (string.IsNullOrEmpty(txtCateDesc.Text.Trim()))
{
lblMsg.Text = "Please Enter Category Description";
}
else
{
entRoomCate.CategoryCode = txtCateCode.Text.Trim();
entRoomCate.CategoryDesc = txtCateDesc.Text.Trim();
if (rdoICU.Checked)
{
entRoomCate.IsICU = true;
}
if (rdoOT.Checked)
{
entRoomCate.IsOT = true;
entRoomCate.Rate = 0;
}
else
{
entRoomCate.Rate = Convert.ToDecimal(txtRate.Text);
}
entRoomCate.EntryBy = SessionWrapper.UserName;
if (!Commons.IsRecordExists("tblCategoryMaster", "CategoryCode", entRoomCate.CategoryCode))
{
lintcnt = mobjCateBLL.InsertCategory(entRoomCate);
if (lintcnt > 0)
{
GetCategories();
lblMessage.Text = "Record Inserted Successfully....";
//this.programmaticModalPopup.Hide();
}
else
{
lblMessage.Text = "Record Not Inserted...";
}
}
else
{
lblMessage.Text = "Record Already Exist....";
}
}
}
MultiView1.SetActiveView(View1);
}
public int DeleteCategory(EntityRoomCategory entRoomCat)
{
int cnt = 0;
try
{
List <SqlParameter> lstParam = new List <SqlParameter>();
Commons.ADDParameter(ref lstParam, "@CategoryCode", DbType.String, entRoomCat.CategoryCode);
cnt = mobjDataAcces.ExecuteQuery("sp_DeleteCategory", lstParam);
}
catch (Exception ex)
{
Commons.FileLog("DepartmentBLL - DeleteDepartment(EntityDepartment entDept)", ex);
}
return(cnt);
}
protected void BtnDeleteOk_Click(object sender, EventArgs e)
{
EntityRoomCategory entCate = new EntityRoomCategory();
int cnt = 0;
try
{
foreach (GridViewRow drv in dgvRoomCategory.Rows)
{
CheckBox chkDelete = (CheckBox)drv.FindControl("chkDelete");
if (chkDelete.Checked)
{
LinkButton lnkCateCode = (LinkButton)drv.FindControl("lnkCatCode");
string lstrCateCode = lnkCateCode.Text;
entCate.CategoryCode = lstrCateCode;
cnt = mobjCateBLL.DeleteCategory(entCate);
if (cnt > 0)
{
//this.modalpopupDelete.Hide();
lblMessage.Text = "Record Deleted Successfully....";
if (dgvRoomCategory.Rows.Count <= 0)
{
pnlShow.Style.Add(HtmlTextWriterStyle.Display, "none");
hdnPanel.Value = "none";
}
}
else
{
lblMessage.Text = "Record Not Deleted....";
}
}
}
GetCategories();
}
catch (System.Threading.ThreadAbortException)
{
}
catch (Exception ex)
{
Commons.FileLog("frmCategoryMaster - BtnDeleteOk_Click(object sender, EventArgs e)", ex);
}
}
public int UpdateCategory(EntityRoomCategory entRoomCat)
{
int cnt = 0;
try
{
List <SqlParameter> lstParam = new List <SqlParameter>();
Commons.ADDParameter(ref lstParam, "@CategoryCode", DbType.String, entRoomCat.CategoryCode);
Commons.ADDParameter(ref lstParam, "@CategoryDesc", DbType.String, entRoomCat.CategoryDesc);
Commons.ADDParameter(ref lstParam, "@Rate", DbType.Decimal, entRoomCat.Rate);
Commons.ADDParameter(ref lstParam, "@ChangeBy", DbType.String, entRoomCat.ChangeBy);
Commons.ADDParameter(ref lstParam, "@IsICU", DbType.Boolean, entRoomCat.IsICU);
Commons.ADDParameter(ref lstParam, "@IsOT", DbType.Boolean, entRoomCat.IsOT);
cnt = mobjDataAcces.ExecuteQuery("sp_UpdateCategory", lstParam);
}
catch (Exception ex)
{
Commons.FileLog("RoomCategoryBLL - UpdateCategory(EntityRoomCategory entRoomCat)", ex);
}
return(cnt);
}
protected void BtnEdit_Click(object sender, EventArgs e)
{
int lintCnt = 0;
try
{
EntityRoomCategory entCate = new EntityRoomCategory();
entCate.CategoryCode = txtCateCode.Text;
entCate.CategoryDesc = txtCateDesc.Text;
entCate.Rate = Convert.ToDecimal(txtRate.Text.Trim());
entCate.ChangeBy = SessionWrapper.UserName;
if (rdoICU.Checked)
{
entCate.IsICU = true;
}
if (rdoOT.Checked)
{
entCate.IsOT = true;
}
lintCnt = mobjCateBLL.UpdateCategory(entCate);
if (lintCnt > 0)
{
GetCategories();
lblMessage.Text = "Record Updated Successfully";
//this.programmaticModalPopup.Hide();
}
else
{
lblMessage.Text = "Record Not Updated";
}
MultiView1.SetActiveView(View1);
}
catch (Exception ex)
{
Commons.FileLog("frmCategoryMaster - BtnEdit_Click(object sender, EventArgs e)", ex);
}
}
public EntityRoomCategory GetRoomCategoryByBedID(int BedId)
{
EntityRoomCategory objCat = null;
try
{
objCat = (from tbl in objData.tblBedMasters
join tblRoomCat in objData.tblRoomCategories
on tbl.CategoryId equals tblRoomCat.PKId
where tbl.BedId == BedId &&
tbl.IsDelete == false
select new EntityRoomCategory
{
PKId = tblRoomCat.PKId,
IsICU = Convert.ToBoolean(tblRoomCat.IsICU),
}).FirstOrDefault();
}
catch (Exception ex)
{
throw ex;
}
return(objCat);
}
