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