internal HRM_Regions gerRegionCodeByRegionId(int regionId)
{
int RegionId = Convert.ToInt32(regionId);
HRM_Regions Region = _context.HRM_Regions.First(x => x.RegionID == RegionId);
return(Region);
}
private void SetRegionCode(int regionId)
{
HRM_Regions objRegion = new HRM_Regions();
objRegion = objRegion_BLl.gerRegionCodeByRegionId(regionId);
if (objRegion != null)
{
txtRegionCode.Text = objRegion.RegionCode.ToString();
}
}
internal int InsertRegion(HRM_Regions objRegion)
{
try
{
_context.HRM_Regions.AddObject(objRegion);
_context.SaveChanges();
return(1);
}
catch (Exception ex)
{
throw ex;
}
}
protected void drpRegion_SelecttedIndexChanged(object sender, EventArgs e)
{
try
{
int regionId = Convert.ToInt32(drpRegion.SelectedValue);
HRM_Regions objRegion = new HRM_Regions();
objRegion = objRegion_BLl.gerRegionCodeByRegionId(regionId);
if (objRegion != null)
{
lblRegionCode.Text = objRegion.RegionCode + "-";
}
}
catch
{
}
}
internal int UpdateUpdateRegion(HRM_Regions objRegion, int RegionId)
{
try
{
HRM_Regions obj = _context.HRM_Regions.First(x => x.RegionID == RegionId);
obj.RegionName = objRegion.RegionName;
obj.RegionCode = objRegion.RegionCode;
obj.EDIT_USER = objRegion.EDIT_USER;
obj.EDIT_DATE = objRegion.EDIT_DATE;
_context.SaveChanges();
return(1);
}
catch (Exception ex)
{
throw ex;
}
}
private bool IsExist(string Rname)
{
try
{
ERPSSLHBEntities _context = new ERPSSLHBEntities();
HRM_Regions objRegion = new HRM_Regions();
bool status = false;
int count = (from rgn in _context.HRM_Regions
where rgn.RegionName == Rname
select rgn.RegionID).Count();
if (count == 0)
{
status = true;
}
return(status);
}
catch (Exception)
{
throw;
}
}
protected void btnRegionSubmit_Click(object sender, EventArgs e)
{
try
{
if (txtbxRegionName.Text == "")
{
//lblMessage.Text = "Please Input Region Name!";
//lblMessage.ForeColor = System.Drawing.Color.Red;
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Please Input Region Name!')", true);
}
else if (txtbxResgionCode.Text == "")
{
//lblMessage.Text = "Please Input Region Code!";
//lblMessage.ForeColor = System.Drawing.Color.Red;
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Please Input Region Code!')", true);
}
else if (txtbxResgionCode.Text.Length > 3 || txtbxResgionCode.Text.Length < 3)
{
//lblMessage.Text = "Region Code Minimum Length 3!";
//lblMessage.ForeColor = System.Drawing.Color.Red;
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Region Code Minimum Length 3!')", true);
}
else
{
HRM_Regions objRegion = new HRM_Regions();
objRegion.EDIT_USER = ((SessionUser)Session["SessionUser"]).UserId;
objRegion.EDIT_DATE = DateTime.Now;
objRegion.OCODE = ((SessionUser)Session["SessionUser"]).OCode;
objRegion.RegionName = txtbxRegionName.Text;
objRegion.RegionCode = txtbxResgionCode.Text;
if (btnRegionSubmit.Text == "Submit")
{
if (IsExist(objRegion.RegionName))
{
int result = objRegion_BLl.InsertRegion(objRegion);
if (result == 1)
{
//lblMessage.Text = "Data Save successfully!";
//lblMessage.ForeColor = System.Drawing.Color.Green;
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Save successfully!')", true);
}
}
else
{
//lblMessage.Text = "Data Already Exists!";
//lblMessage.ForeColor = System.Drawing.Color.Red;
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Already Exists!')", true);
}
}
else
{
if (hidRegionName.Value != txtbxRegionName.Text)
{
if (IsExist(objRegion.RegionName))
{
int RegionId = Convert.ToInt32(hidRegionId.Value);
int result = objRegion_BLl.UpdateUpdateRegion(objRegion, RegionId);
if (result == 1)
{
//lblMessage.Text = "Data Update successfully!";
//lblMessage.ForeColor = System.Drawing.Color.Green;
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Update successfully!')", true);
}
}
else
{
//lblMessage.Text = "Data Already Exists!";
//lblMessage.ForeColor = System.Drawing.Color.Red;
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Already Exists!')", true);
}
}
else
{
int RegionId = Convert.ToInt32(hidRegionId.Value);
int result = objRegion_BLl.UpdateUpdateRegion(objRegion, RegionId);
if (result == 1)
{
//lblMessage.Text = "Data Update successfully!";
//lblMessage.ForeColor = System.Drawing.Color.Green;
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Update successfully!')", true);
}
}
}
getRegions();
ClearRegionsUi();
//}
//else
//{
// lblMessage.Text = "Data Already Exist!";
// lblMessage.ForeColor = System.Drawing.Color.Red;
//}
}
}
catch (Exception)
{
throw;
}
}
public int UpdateUpdateRegion(HRM_Regions objRegion, int RegionId)
{
return(objRegonDal.UpdateUpdateRegion(objRegion, RegionId));
}
public int InsertRegion(HRM_Regions objRegion)
{
return(objRegonDal.InsertRegion(objRegion));
}
