protected void btnSave_Click(object sender, EventArgs e) { try { labelMessagePostOffice.Text = string.Empty; int PoliceStationID = int.Parse(txtPoliceStationID.Text); using (PostOfficeRT receiverTransfer = new PostOfficeRT()) { if (receiverTransfer.IsPostOfficeCodeExists(txtPostOfficeCode.Text, PoliceStationID) && receiverTransfer.IsPostOfficeNameExists(txtPostOfficeName.Text, PoliceStationID)) { labelMessagePostOffice.Text = "Post Office Code " + txtPostOfficeCode.Text + "& Name " + txtPostOfficeName.Text + " Already Exists!"; labelMessagePostOffice.ForeColor = System.Drawing.Color.Red; return; } else if (receiverTransfer.IsPostOfficeCodeExists(txtPostOfficeCode.Text)) { labelMessagePostOffice.Text = "Post Office Code " + txtPostOfficeCode.Text + " Already Exists!"; labelMessagePostOffice.ForeColor = System.Drawing.Color.Red; return; } else if (receiverTransfer.IsPostOfficeCodeExists(txtPostOfficeCode.Text, PoliceStationID)) { labelMessagePostOffice.Text = "Post Office Code " + txtPostOfficeCode.Text + " Already Exists!"; labelMessagePostOffice.ForeColor = System.Drawing.Color.Red; return; } else if (receiverTransfer.IsPostOfficeNameExists(txtPostOfficeName.Text, PoliceStationID)) { labelMessagePostOffice.Text = "Post Office Name " + txtPostOfficeName.Text + " Already Exists!"; labelMessagePostOffice.ForeColor = System.Drawing.Color.Red; return; } hdSave.Value = "true"; PostOffice postOffice = CreatePostOffice(); receiverTransfer.AddPostOffice(postOffice); if (postOffice.IID > 0) { labelMessagePostOffice.Text = "Data successfully saved..."; labelMessagePostOffice.ForeColor = System.Drawing.Color.Green; } else { labelMessagePostOffice.Text = "Data not saved..."; labelMessagePostOffice.ForeColor = System.Drawing.Color.Red; } } ClearField(); LoadPostOfficeListView(); SetButton(); // hdSave.Value = string.Empty; } catch (Exception ex) { labelMessagePostOffice.Text = "Error : " + ex.Message; labelMessagePostOffice.ForeColor = System.Drawing.Color.Red; } }
protected void lvPostOffice_ItemCommand(object sender, ListViewCommandEventArgs e) { if (e.CommandName == "EditPostOffice") { try { labelMessagePostOffice.Text = string.Empty; btnSave.Visible = false; btnUpdate.Visible = true; btnDelete.Visible = false; btnCancel.Visible = true; chkPoliceStationActv.Visible = true; int PostoffcID = Convert.ToInt32(e.CommandArgument); hdPostOfficeID.Value = PostoffcID.ToString(); using (PostOfficeRT receiverTransfer = new PostOfficeRT()) { PostOffice postOffice = receiverTransfer.GetPostOfficeByID(PostoffcID); FillPostOfficeForEdit(postOffice); } } catch (Exception ex) { labelMessagePostOffice.Text = "Error : " + ex.Message; labelMessagePostOffice.ForeColor = System.Drawing.Color.Red; } } }
private void LoadPostOfficeListView() { try { using (PostOfficeRT receiverTransfer = new PostOfficeRT()) { lvPostOffice.DataSource = receiverTransfer.GetPostOfficeAllForListView();; lvPostOffice.DataBind(); } } catch (Exception ex) { labelMessagePostOffice.Text = "Error : " + ex.Message; labelMessagePostOffice.ForeColor = System.Drawing.Color.Red; } }
protected void btnDelete_Click(object sender, EventArgs e) { try { labelMessage.Text = string.Empty; using (PoliceStationRT receiverTransfer = new PoliceStationRT()) { hdIsDelete.Value = "true"; hdIsEdit.Value = "true"; PoliceStation policeStaion = CreatePoliceStaion(); if (policeStaion != null) { PostOfficeRT postOfficeRT = new PostOfficeRT(); if (postOfficeRT.IsPostOfficeExistsInPoliceStation(Convert.ToInt32(policeStaion.IID))) { labelMessage.Text = "Post Office Already Exist for this Police Station"; labelMessage.ForeColor = System.Drawing.Color.Red; } else { receiverTransfer.UpdatePoliceStaion(policeStaion); labelMessage.Text = "Data successfully deleted..."; labelMessage.ForeColor = System.Drawing.Color.Green; } } else { labelMessage.Text = "Data not deleted..."; labelMessage.ForeColor = System.Drawing.Color.Red; } } LoadPoliceStationListView(); DohideButton(); btnSave.Visible = true; ClearField(); } 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 (PoliceStationRT receiverTransfer = new PoliceStationRT()) { hdIsEdit.Value = "true"; //hdIsDelete.Value = "false"; PoliceStation policeStaion = CreatePoliceStaion(); if (policeStaion != null) { //Exit If Both Police Staion Code & Name exist in Other rows if ((receiverTransfer.IsPoliceStaionCodeExistInOtherRows(policeStaion.IID, policeStaion.Code, policeStaion.DistrictID)) && (receiverTransfer.IsPoliceStaionNameExistInOtherRows(policeStaion.IID, policeStaion.Code, policeStaion.DistrictID))) { labelMessage.Text = "Police Staion Code " + txtCode.Text + "& Name " + txtName.Text + " Already Exists!"; labelMessage.ForeColor = System.Drawing.Color.Red; return; } //Exit if Duplicate Police Station Code else if (receiverTransfer.IsPoliceStationCodeExistsInOtherRows(policeStaion.IID, policeStaion.Code)) { labelMessage.Text = "Police Staion Code " + txtCode.Text + " Already Exists!"; labelMessage.ForeColor = System.Drawing.Color.Red; return; } //Exit If Both Police Staion Code exist in Other rows else if (receiverTransfer.IsPoliceStaionCodeExistInOtherRows(policeStaion.IID, policeStaion.Code, policeStaion.DistrictID)) { labelMessage.Text = "Police Staion Code " + txtCode.Text + " Already Exists!"; labelMessage.ForeColor = System.Drawing.Color.Red; return; } //Exit If Both Police Staion Name exist in Other rows else if (receiverTransfer.IsPoliceStaionNameExistInOtherRows(policeStaion.IID, policeStaion.Name, policeStaion.DistrictID)) { labelMessage.Text = "Police Staion Name " + txtName.Text + " Already Exists!"; labelMessage.ForeColor = System.Drawing.Color.Red; return; } if (chkIsRemovedPoliceStation.Checked == true) { PostOfficeRT postOfficeRT = new PostOfficeRT(); if (postOfficeRT.IsPostOfficeExistsInPoliceStation(Convert.ToInt32(policeStaion.IID))) { labelMessage.Text = "Post Office Already Exist for this Police Station"; labelMessage.ForeColor = System.Drawing.Color.Red; } else { receiverTransfer.UpdatePoliceStaion(policeStaion); labelMessage.Text = "Data successfully updated..."; labelMessage.ForeColor = System.Drawing.Color.Green; } } else { receiverTransfer.UpdatePoliceStaion(policeStaion); 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(); chkIsRemovedPoliceStation.Visible = false; LoadPoliceStationListView(); } catch (Exception ex) { labelMessage.Text = "Error : " + ex.Message; labelMessage.ForeColor = System.Drawing.Color.Red; } }
protected void btnUpdate_Click(object sender, EventArgs e) { try { labelMessagePostOffice.Text = string.Empty; using (PostOfficeRT receiverTransfer = new PostOfficeRT()) { hdIsEdit.Value = "true"; hdIsDelete.Value = "false"; PostOffice postOffice = CreatePostOffice(); if (postOffice != null) { //Exit If Both Post Office Code & Name exist in Other rows if ((receiverTransfer.IsPostOfficeCodeExistInOtherRows(postOffice.IID, postOffice.Code, postOffice.DistrictID)) && (receiverTransfer.IsPostOfficeNameExistInOtherRows(postOffice.IID, postOffice.Code, postOffice.DistrictID))) { labelMessagePostOffice.Text = "Post Office Code " + txtPostOfficeCode.Text + "& Name " + txtPostOfficeName.Text + " Already Exists!"; labelMessagePostOffice.ForeColor = System.Drawing.Color.Red; return; } //Exit if Duplicate Police Station Code else if (receiverTransfer.IsPostOfficeCodeExistsInOtherRows(postOffice.IID, postOffice.Code)) { labelMessagePostOffice.Text = "Post Office Code " + txtPostOfficeCode.Text + " Already Exists!"; labelMessagePostOffice.ForeColor = System.Drawing.Color.Red; return; } //Exit If Both Police Staion Code exist in Other rows else if (receiverTransfer.IsPostOfficeCodeExistInOtherRows(postOffice.IID, postOffice.Code, postOffice.DistrictID)) { labelMessagePostOffice.Text = "Post Office Code " + txtPostOfficeCode.Text + " Already Exists!"; labelMessagePostOffice.ForeColor = System.Drawing.Color.Red; return; } //Exit If Both Police Staion Name exist in Other rows else if (receiverTransfer.IsPostOfficeNameExistInOtherRows(postOffice.IID, postOffice.Name, postOffice.DistrictID)) { labelMessagePostOffice.Text = "Post Office Name " + txtPostOfficeName.Text + " Already Exists!"; labelMessagePostOffice.ForeColor = System.Drawing.Color.Red; return; } receiverTransfer.UpdatePostOffice(postOffice); labelMessagePostOffice.Text = "Data successfully updated..."; labelMessagePostOffice.ForeColor = System.Drawing.Color.Green; //hdIsEdit.Value = ""; } else { labelMessagePostOffice.Text = "Data not updated..."; labelMessagePostOffice.ForeColor = System.Drawing.Color.Red; } } ClearField(); // hdIsEdit.Value = string.Empty; SetButton(); LoadPostOfficeListView(); } catch (Exception ex) { labelMessagePostOffice.Text = "Error : " + ex.Message; labelMessagePostOffice.ForeColor = System.Drawing.Color.Red; } }