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; } }