protected void dgRegion_SelectedIndexChanged(object sender, EventArgs e)
{
int iRegionID = 0;
int.TryParse(Convert.ToString(dgRegion.DataKeys[dgRegion.SelectedIndex]), out iRegionID);
hfId.Value = iRegionID.ToString();
RegionMaster oRegionMaster = new RegionMaster();
RegionDTO[] oRegionData = oRegionMaster.GetData(iRegionID);
if (oRegionData.Length > 0)
{
txtRegionName.Text = oRegionData[0].RegionName;
}
oRegionMaster = null;
oRegionData = null;
//btnAddNew.Enabled = false;
//btnCancel.Enabled = true;
btnCancel.Visible = true;
btnDelete.Enabled = true;
btnEdit.Text = "Update";
//btnEdit.Enabled = true;
//btnSave.Enabled = false;
lblStatus.Text = "";
}
public ActionResult UpdateRegion(RegionMaster model)
{
db.RegionMasters.Add(model);
db.SaveChanges();
TempData[Constants.SuccessAlert] = "Region Updated Successfully";
return(RedirectToAction(nameof(UpdateRegion)));
}
public bool SaveRegion(RegionModel model)
{
try
{
RegionMaster master = new RegionMaster
{
address = model.address,
IsActive = true,
bankBalanceLimit = model.bankBalanceLimit,
cashBalanceLimit = model.cashBalanceLimit,
cityId = model.cityId,
defaultBankLegder = model.defaultBankLegder,
defaultCashLedger = model.defaultCashLedger,
emailId = model.emailId,
mobileNo = model.mobileNo,
phoneNo = model.phoneNo,
pincode = model.pincode,
regionCode = model.regionCode,
regionName = model.regionName,
stateId = model.stateId,
};
_tRSEntities.RegionMasters.Add(master);
_tRSEntities.SaveChanges();
return(true);
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
/// Get Region List
/// </summary>
/// <returns></returns>
public List <RegionMaster> GetRegionList()
{
DataSet ds = new DataSet();
MySqlCommand cmd = new MySqlCommand();
List <RegionMaster> regionMaster = new List <RegionMaster>();
try
{
conn = Db.Connection;
cmd.Connection = conn;
MySqlCommand cmd1 = new MySqlCommand("SP_GetRegionList", conn);
cmd1.CommandType = CommandType.StoredProcedure;
MySqlDataAdapter da = new MySqlDataAdapter();
da.SelectCommand = cmd1;
da.Fill(ds);
if (ds != null && ds.Tables[0] != null)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
RegionMaster region = new RegionMaster();
region.RegionID = Convert.ToInt32(ds.Tables[0].Rows[i]["RegionID"]);
region.PinCodeID = Convert.ToInt32(ds.Tables[0].Rows[i]["PinCodeID"]);
region.RegionName = Convert.ToString(ds.Tables[0].Rows[i]["RegionName"]);
regionMaster.Add(region);
}
}
}
catch (Exception ex)
{
throw ex;
}
return(regionMaster);
}
private void Save()
{
if (!base.ValidateIfCommandAllowed(Request.Url.AbsoluteUri, ENums.PageCommand.Add))
{
return;
}
bool bActionCompleted = false;
RegionDTO oRegionData = new RegionDTO();
oRegionData.RegionName = txtRegionName.Text.ToString();
RegionMaster oRegionMaster = new RegionMaster();
bActionCompleted = oRegionMaster.Insert(oRegionData);
if (bActionCompleted == true)
{
base.DisplayAlert("The record has been inserted successfully");
txtRegionName.Text = "";
lblStatus.Text = "Saved";
}
else
{
lblStatus.Text = "Error Occured while insertion: Please refer to the error log.";
}
oRegionData = null;
oRegionMaster = null;
}
public RegionDTO[] GetRegionDetails()
{
RegionMaster oRegionMaster;
oRegionMaster = new RegionMaster();
return(oRegionMaster.GetData());
}
private void Delete()
{
if (!base.ValidateIfCommandAllowed(Request.Url.AbsoluteUri, ENums.PageCommand.Delete))
{
return;
}
if (ValidateValues() == false)
{
return;
}
bool bActionCompleted = false;
int Id = 0;
int.TryParse(hfId.Value, out Id);
if (Id == 0)
{
lblStatus.Text = "Please click on edit button again.";
return;
}
RegionDTO oRegionData = new RegionDTO();
oRegionData.RegionId = Id;
RegionMaster oRegionMaster = new RegionMaster();
/*
* ADDED BY VIJAY
* CHECK IF THE REGION WHICH IS TO BE DELETED HAS ANY ASSOCIATED RECORDS...IF YES, MOVE OUT OF THE FUNCTION ELSE PROCEED
* IF THE OUTPUT OF sMessage IS "", THEN RECORD CAN BE DELETED, ELSE NOT
*
*/
string sMessage = "";
GF.HasRecords(Convert.ToString(Id), "region", out sMessage);
if (sMessage != "")
{
base.DisplayAlert(sMessage);
btnDelete.Enabled = true;
}
else
{
bActionCompleted = oRegionMaster.Delete(oRegionData);
if (bActionCompleted == true)
{
base.DisplayAlert("The record has been deleted successfully");
txtRegionName.Text = "";
//lblStatus.Text = "Deleted";
RefreshGrid();
}
else
{
base.DisplayAlert("Error Occured while deletion: Please refer to the error log.");
}
}
oRegionData = null;
oRegionMaster = null;
}
public static List <RegionMaster> FetchRegionMaster(RegionMaster objModel)
{
OracleParameterCollection param = new OracleParameterCollection();
param.Add(new OracleParameter(Common.CMS_SP_REGZONCOLLECTION_LIST.E_KEY, objModel.KEY));
param.Add(new OracleParameter(Common.CMS_SP_REGZONCOLLECTION_LIST.P_OUTTBL, OracleType.Cursor));
param[Common.CMS_SP_REGZONCOLLECTION_LIST.P_OUTTBL].Direction = ParameterDirection.Output;
OracleParameter[] Oraparam = new OracleParameter[param.Count];
param.CopyTo(Oraparam, 0);
param.Clear();
var liRegionMaster = (List <RegionMaster>)OracleHelper.FetchData <RegionMaster>(Oraparam, Common.Queries.CMS_SP_REGZONCOLLECTION_LIST, EnumCommand.DataSource.list).DataSource.Data;
return(liRegionMaster);
}
private void FillRegions()
{
RegionMaster oRegionMaster = new RegionMaster();
RegionDTO[] oRegionData = oRegionMaster.GetData();
ddlRegion.Items.Clear();
SortedList slRegionMaster = new SortedList();
slRegionMaster.Add("0", "Choose Region");
for (int i = 0; i < oRegionData.Length; i++)
{
slRegionMaster.Add(Convert.ToString(oRegionData[i].RegionId), Convert.ToString(oRegionData[i].RegionName));
}
ddlRegion.DataSource = slRegionMaster;
ddlRegion.DataTextField = "value";
ddlRegion.DataValueField = "key";
ddlRegion.DataBind();
}
public static List <RegionMaster> SaveRegionMaster(RegionMaster regionmaster)
{
OracleParameterCollection param1 = new OracleParameterCollection();
param1.Add(new OracleParameter(Common.CMS_SP_REGZONCOLLECTION_MST.E_KEY, regionmaster.KEY));
param1.Add(new OracleParameter(Common.CMS_SP_REGZONCOLLECTION_MST.E_CODE, regionmaster.REGION_CODE));
param1.Add(new OracleParameter(Common.CMS_SP_REGZONCOLLECTION_MST.E_CODE_DESC, regionmaster.REGION_DESC));
param1.Add(new OracleParameter(Common.CMS_SP_REGZONCOLLECTION_MST.E_ACTIVE, regionmaster.ACTIVE));
param1.Add(new OracleParameter(Common.CMS_SP_REGZONCOLLECTION_MST.E_ZONE_CODE, regionmaster.ZONE_CODE));
param1.Add(new OracleParameter(Common.CMS_SP_REGZONCOLLECTION_MST.E_CREATED_BY, regionmaster.CREATED_BY));
param1.Add(new OracleParameter(Common.CMS_SP_REGZONCOLLECTION_MST.P_OUTTBL, OracleType.Cursor));
param1[Common.CMS_SP_REGZONCOLLECTION_MST.P_OUTTBL].Direction = ParameterDirection.Output;
OracleParameter[] Oraparam1 = new OracleParameter[param1.Count];
param1.CopyTo(Oraparam1, 0);
param1.Clear();
var liRegionMaster1 = (List <RegionMaster>)OracleHelper.FetchData <RegionMaster>(Oraparam1, Common.Queries.CMS_SP_REGZONCOLLECTION_MST, EnumCommand.DataSource.list).DataSource.Data;
return(liRegionMaster1);
}
private void Update()
{
if (!base.ValidateIfCommandAllowed(Request.Url.AbsoluteUri, ENums.PageCommand.Update))
{
return;
}
if (ValidateValues() == false)
{
return;
}
bool bActionCompleted = false;
int Id = 0;
int.TryParse(hfId.Value, out Id);
if (Id == 0)
{
lblStatus.Text = "Please click on edit button again.";
return;
}
RegionDTO oRegionData = new RegionDTO();
oRegionData.RegionId = Id;
oRegionData.RegionName = txtRegionName.Text.ToString();
RegionMaster oRegionMaster = new RegionMaster();
bActionCompleted = oRegionMaster.Update(oRegionData);
if (bActionCompleted == true)
{
base.DisplayAlert("The record has been updated successfully");
txtRegionName.Text = "";
lblStatus.Text = "Updated";
}
else
{
lblStatus.Text = "Error Occured while updation: Please refer to the error log.";
}
oRegionData = null;
oRegionMaster = null;
}
private void RefreshGrid()
{
RegionMaster oRegionMaster;
RegionDTO[] oRegionData;
oRegionMaster = new RegionMaster();
oRegionData = oRegionMaster.GetData();
if (oRegionData != null)
{
if (oRegionData.Length > 0)
{
dgRegion.DataSource = oRegionData;
dgRegion.DataBind();
}
}
else
{
dgRegion.DataSource = null;
dgRegion.DataBind();
}
txtRegionName.Text = "";
oRegionMaster = null;
oRegionData = null;
}
protected void Page_UnLoad(object sender, EventArgs e)
{
objCommonClass = null;
objRegionMaster = null;
}