protected void lvDivisionOrState_ItemCommand(object sender, ListViewCommandEventArgs e)
{
if (e.CommandName == "EditDivission")
{
try
{
labelMessage.Text = string.Empty;
chkIsRemovedDivOrState.Visible = true;
btnSave.Visible = false;
btnUpdate.Visible = true;
//btnDelete.Visible = true;
btnCancel.Visible = true;
int divisionOrStateID = Convert.ToInt32(e.CommandArgument);
hdDivisionOrStateID.Value = divisionOrStateID.ToString();
using (DivisionOrStateRT receiverTransfer = new DivisionOrStateRT())
{
DivisionOrState divisionOrState = receiverTransfer.GetDivisionOrStateByID(divisionOrStateID);
FillDesignationForEdit(divisionOrState);
}
}
catch (Exception ex)
{
labelMessage.Text = "Error : " + ex.Message;
labelMessage.ForeColor = System.Drawing.Color.Red;
}
}
}
public void AddDivisionOrState(DivisionOrState divisionOrState)
{
try
{
DatabaseHelper.Insert <DivisionOrState>(divisionOrState);
}
catch (Exception ex) { throw new Exception(ex.Message, ex); }
}
public object GetAllPoliceStationForListView()
{
try
{
OiiOHaatDCDataContext dbContext = DatabaseHelper.GetDataModelDataContext();
DivisionOrState divisionOrState = new DivisionOrState();
var policeStationList = dbContext.SpGetAllPoliceStation();
return(policeStationList);
}
catch (Exception ex) { throw new Exception(ex.Message, ex); }
}
public void UpdateDivisionOrState(DivisionOrState divisionOrState)
{
try
{
OiiOHaatDCDataContext msDC = DatabaseHelper.GetDataModelDataContext();
DivisionOrState divisionOrStateNew = msDC.DivisionOrStates.Single(d => d.IID == divisionOrState.IID);
DatabaseHelper.Update <DivisionOrState>(msDC, divisionOrState, divisionOrStateNew);
msDC.Dispose();
}
catch (Exception ex) { throw new Exception(ex.Message, ex); }
}
public DivisionOrState GetDivisionOrStateByID(long stateID)
{
try
{
OiiOHaatDCDataContext dbContext = DatabaseHelper.GetDataModelDataContext();
DivisionOrState divisionOrState = new DivisionOrState();
//divisionOrState = dbContext.DivisionOrStates.Single(d => d.IID == p && d.IsRemoved == false);
divisionOrState = dbContext.DivisionOrStates.Single(d => d.IID == stateID);
dbContext.Dispose();
return(divisionOrState);
}
catch (Exception ex) { throw new Exception(ex.Message, ex); }
}
//private void LoadDropDownCountry(int? countryID)
//{
// try
// {
// using (CountryRT receverTransfer = new CountryRT())
// {
// List<Country> countryList = new List<Country>();
// if (countryID != null)
// {
// countryList.Add(receverTransfer.GetCountryByIID((int)countryID));
// }
// else
// {
// countryList = receverTransfer.GetCountryAll();
// }
// DropDownListHelper.Bind<Country>(ddlApplicableCountry, countryList, "Name", "IID", EnumCollection.ListItemType.Country);
// }
// }
// catch (Exception ex)
// {
// throw new Exception(ex.Message, ex);
// }
//}
private DivisionOrState CreateDivsionOrState()
{
Session["UserID"] = "1";
DivisionOrState divisionOrState = new DivisionOrState();
try
{
if (hdIsEdit.Value == "true")
{
divisionOrState.IID = Convert.ToInt32(hdDivisionOrStateID.Value.ToString());
}
divisionOrState.Name = txtName.Text.Trim();
divisionOrState.Code = txtCode.Text.Trim();
divisionOrState.CountryID = Convert.ToInt32(txtCountryID.Text);
divisionOrState.IsRemoved = chkIsRemovedDivOrState.Checked;
if (divisionOrState.IID <= 0)
{
divisionOrState.CreatedBy = Convert.ToInt64(Session["UserID"]);
divisionOrState.CreatedDate = GlobalRT.GetServerDateTime();
}
else
{
DivisionOrState div = (DivisionOrState)Session[sessDivisionOrState];
divisionOrState.CreatedBy = div.CreatedBy;;
divisionOrState.CreatedDate = div.CreatedDate;
divisionOrState.ModifiedBy = Convert.ToInt64(Session["UserID"]);
divisionOrState.ModifiedDate = GlobalRT.GetServerDateTime();
}
//if (hdIsDelete.Value != "true")
//{
// divisionOrState.IsRemoved = false;
//}
//else
//{
// divisionOrState.IsRemoved = true;
//}
}
catch (Exception ex)
{
labelMessage.Text = "Error : " + ex.Message;
labelMessage.ForeColor = System.Drawing.Color.Red;
}
return(divisionOrState);
}
protected void btnDelete_Click(object sender, EventArgs e)
{
try
{
labelMessage.Text = string.Empty;
using (DivisionOrStateRT receiverTransfer = new DivisionOrStateRT())
{
//hdIsDelete.Value = "true";
hdIsEdit.Value = "true";
DivisionOrState divisionOrState = CreateDivsionOrState();
if (divisionOrState != null)
{
DistrictRT districtRT = new DistrictRT();
if (districtRT.IsDistrictExistsInDivision(Convert.ToInt32(divisionOrState.IID)))
{
labelMessage.Text = "District Already Exist For This Division Or State";
labelMessage.ForeColor = System.Drawing.Color.Red;
}
else
{
receiverTransfer.UpdateDivisionOrState(divisionOrState);
labelMessage.Text = "Data successfully deleted...";
labelMessage.ForeColor = System.Drawing.Color.Green;
}
}
else
{
labelMessage.Text = "Data not deleted...";
labelMessage.ForeColor = System.Drawing.Color.Red;
}
}
LoadDivisionOrState();
ClearField();
}
catch (Exception ex)
{
labelMessage.Text = "Error : " + ex.Message;
labelMessage.ForeColor = System.Drawing.Color.Red;
}
}
/// <summary>
/// Fill Designation For Edit
/// </summary>
/// <param name="divisionOrState"></param>
private void FillDesignationForEdit(DivisionOrState divisionOrState)
{
try
{
if (divisionOrState != null)
{
CountryRT recTransfer = new CountryRT();
txtCountryID.Text = divisionOrState.CountryID.ToString();
txtName.Text = divisionOrState.Name;
txtCode.Text = divisionOrState.Code.ToString();
txtCountryName.Text = Convert.ToString(recTransfer.GetCountryByIID(divisionOrState.CountryID).Name);
chkIsRemovedDivOrState.Checked = divisionOrState.IsRemoved;
Session[sessDivisionOrState] = divisionOrState;
}
}
catch (Exception ex)
{
labelMessage.Text = "Error : " + ex.Message;
labelMessage.ForeColor = System.Drawing.Color.Red;
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
try
{
labelMessage.Text = string.Empty;
using (DivisionOrStateRT receiverTransfer = new DivisionOrStateRT())
{
hdIsEdit.Value = "true";
DistrictRT districtRT = new DistrictRT();
//hdIsDelete.Value = "false";
DivisionOrState divisionOrState = CreateDivsionOrState();
if (divisionOrState != null)
{
if ((receiverTransfer.IsDivOrStateCodeExistInOterRows(divisionOrState.IID, divisionOrState.Code, divisionOrState.CountryID)) && (receiverTransfer.IsDivOrStateNameExistInOterRows(divisionOrState.IID, divisionOrState.Name, divisionOrState.CountryID)))
{
labelMessage.Text = "Division Or State Code " + txtCode.Text + " & Name " + txtName.Text + " Already Exists!";
labelMessage.ForeColor = System.Drawing.Color.Red;
return;
}
else if (receiverTransfer.IsDivOrStateCodeExisInOterRow(divisionOrState.IID, divisionOrState.Code))
{
labelMessage.Text = "Division Or State Code " + txtCode.Text + " Already Exists!";
labelMessage.ForeColor = System.Drawing.Color.Red;
return;
}
else if (receiverTransfer.IsDivOrStateCodeExistInOterRows(divisionOrState.IID, divisionOrState.Code, divisionOrState.CountryID))
{
labelMessage.Text = "Division Or State Code " + txtCode.Text + " Already Exists!";
labelMessage.ForeColor = System.Drawing.Color.Red;
return;
}
else if (receiverTransfer.IsDivOrStateNameExistInOterRows(divisionOrState.IID, divisionOrState.Name, divisionOrState.CountryID))
{
labelMessage.Text = "Division Or State Name " + txtName.Text + " Already Exists!";
labelMessage.ForeColor = System.Drawing.Color.Red;
return;
}
if (chkIsRemovedDivOrState.Checked == true)
{
if (districtRT.IsDistrictExistsInDivision(Convert.ToInt32(divisionOrState.IID)))
{
labelMessage.Text = "District already exist for this Division Or State";
labelMessage.ForeColor = System.Drawing.Color.Red;
}
else
{
receiverTransfer.UpdateDivisionOrState(divisionOrState);
labelMessage.Text = "Data successfully updated...";
labelMessage.ForeColor = System.Drawing.Color.Green;
}
}
else
{
receiverTransfer.UpdateDivisionOrState(divisionOrState);
labelMessage.Text = "Data successfully updated...";
labelMessage.ForeColor = System.Drawing.Color.Green;
}
}
else
{
labelMessage.Text = "Data not updated...";
labelMessage.ForeColor = System.Drawing.Color.Red;
}
}
ClearField();
btnSave.Visible = true;
DohideButton();
chkIsRemovedDivOrState.Visible = false;
LoadDivisionOrState();
}
catch (Exception ex)
{
labelMessage.Text = "Error : " + ex.Message;
labelMessage.ForeColor = System.Drawing.Color.Red;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
labelMessage.Text = string.Empty;
using (DivisionOrStateRT receiverTransfer = new DivisionOrStateRT())
{
//List<DivisionOrState> divisionList = new List<DivisionOrState>(); // Comment By Hasan 2015.02.16
//divisionList = receiverTransfer.GetDivisionByCode(txtCode.Text);
//if (divisionList != null && divisionList.Count > 0)
//int countryID = Convert.ToInt32(hdCountryID.ToString());
int countryID = Convert.ToInt32(txtCountryID.Text);
if (receiverTransfer.IsDivisionOrStateCodeExists(txtCode.Text, countryID) && receiverTransfer.IsDivisionOrStateNameExists(txtName.Text, countryID))
{
labelMessage.Text = "Division Or State Code " + txtCode.Text + " & Name " + txtName.Text + " Already Exists!";
labelMessage.ForeColor = System.Drawing.Color.Red;
return;
}
if (receiverTransfer.IsDivisionOrStateCodeExist(txtCode.Text))
{
labelMessage.Text = "Division Or State Code " + txtCode.Text + " Already Exists!";
labelMessage.ForeColor = System.Drawing.Color.Red;
return;
}
else if (receiverTransfer.IsDivisionOrStateCodeExists(txtCode.Text, countryID))
{
labelMessage.Text = "Division Or State Code " + txtCode.Text + " Already Exists!";
labelMessage.ForeColor = System.Drawing.Color.Red;
return;
}
else if (receiverTransfer.IsDivisionOrStateNameExists(txtName.Text, countryID))
{
labelMessage.Text = "Division Or State Name " + txtName.Text + " Already Exists!";
labelMessage.ForeColor = System.Drawing.Color.Red;
return;
}
DivisionOrState divisionOrState = CreateDivsionOrState();
receiverTransfer.AddDivisionOrState(divisionOrState);
if (divisionOrState.IID > 0)
{
labelMessage.Text = "Data successfully saved...";
labelMessage.ForeColor = System.Drawing.Color.Green;
}
else
{
labelMessage.Text = "Data not saved...";
labelMessage.ForeColor = System.Drawing.Color.Red;
}
}
ClearField();
LoadDivisionOrState();
}
catch (Exception ex)
{
labelMessage.Text = "Error : " + ex.Message;
labelMessage.ForeColor = System.Drawing.Color.Red;
}
}
