protected override void Page_Load(object sender, EventArgs e)
{
OrganizationFormUI organizationFormUI = new OrganizationFormUI();
if (!Page.IsPostBack)
{
if (Request.QueryString["OrganizationId"] != null)
{
organizationFormUI.Tbl_OrganizationId = Request.QueryString["OrganizationId"];
BindOrganizationTypeDropDown();
FillForm(organizationFormUI);
btnSave.Visible = false;
btnClear.Visible = false;
btnUpdate.Visible = true;
btnDelete.Visible = true;
lblHeading.Text = "Update Organisation";
}
else
{
BindOrganizationTypeDropDown();
btnSave.Visible = true;
btnClear.Visible = true;
btnUpdate.Visible = false;
btnDelete.Visible = false;
lblHeading.Text = "Add New Organisation";
}
//BindCountryList();
}
}
public int DeleteOrganization(OrganizationFormUI organizationFormUI)
{
int resutl = 0;
resutl = organizationFormDAL.DeleteOrganization(organizationFormUI);
return(resutl);
}
protected void btnDelete_Click(object sender, EventArgs e)
{
OrganizationFormUI organizationFormUI = new OrganizationFormUI();
try
{
organizationFormUI.Tbl_OrganizationId = Request.QueryString["OrganizationId"];
if (organizationFormBAL.DeleteOrganization(organizationFormUI) == 1)
{
divSuccess.Visible = true;
lblSuccess.Text = Resources.GlobalResource.msgRecordDeleteSuccessfully;
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "clearform", "ClearForm();", true);
}
else
{
divError.Visible = true;
lblError.Text = Resources.GlobalResource.msgCouldNotDeleteRecord;
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "clearform", "ClearForm();", true);
}
}
catch (Exception exp)
{
logExcpUIobj.MethodName = "btnDelete_Click()";
logExcpUIobj.ResourceName = "System_Settings_OrganizationList.CS";
logExcpUIobj.RecordId = organizationFormUI.Tbl_OrganizationId;
logExcpUIobj.ExceptionDetails = "Error Occured. System Generated Error is: " + exp.ToString();
logExcpDALobj.SaveExceptionToDB(logExcpUIobj);
log.Error("[System_Settings_OrganizationList : btnDelete_Click] An error occured in the processing of Record Id : " + organizationFormUI.Tbl_OrganizationId + ". Details : [" + exp.ToString() + "]");
}
}
public int AddOrganization(OrganizationFormUI organizationFormUI)
{
int resutl = 0;
resutl = organizationFormDAL.AddOrganization(organizationFormUI);
return(resutl);
}
public DataTable GetOrganizationListById(OrganizationFormUI organizationFormUI)
{
DataTable dtb = new DataTable();
dtb = organizationFormDAL.GetOrganizationListById(organizationFormUI);
return(dtb);
}
private void FillForm(OrganizationFormUI organizationFormUI)
{
try
{
DataTable dtb = organizationFormBAL.GetOrganizationListById(organizationFormUI);
if (dtb.Rows.Count > 0)
{
txtCode.Text = dtb.Rows[0]["organizationcode"].ToString();
txtName.Text = dtb.Rows[0]["name"].ToString();
txtWebsite.Text = dtb.Rows[0]["website"].ToString();
txtPhone.Text = dtb.Rows[0]["phoneno"].ToString();
txtMobile.Text = dtb.Rows[0]["mobile"].ToString();
txtFax.Text = dtb.Rows[0]["faxno"].ToString();
txtCity.Text = dtb.Rows[0]["city"].ToString();
txtState.Text = dtb.Rows[0]["state"].ToString();
txtPostalCode.Text = dtb.Rows[0]["postalcode"].ToString();
txtAddress.Text = dtb.Rows[0]["address"].ToString();
txtOwner.Text = dtb.Rows[0]["Owner"].ToString();
txtEmail.Text = dtb.Rows[0]["email"].ToString();
ddlOrganizationType.SelectedValue = dtb.Rows[0]["tbl_OrganizationTypeId"].ToString();
txtCountry.Text = dtb.Rows[0]["CountryName"].ToString();
lblCountryGuid.Text = dtb.Rows[0]["tbl_CountryId"].ToString();
byte[] imageByte = (byte[])dtb.Rows[0]["Logo"];
if (imageByte != null)
{
string logo = Convert.ToBase64String(imageByte);
imgLogo.ImageUrl = "data:Image/jpg;base64," + logo;
}
}
else
{
lblError.Text = Resources.GlobalResource.msgCouldNotLoadData;
divError.Visible = true;
}
}
catch (Exception exp)
{
logExcpUIobj.MethodName = "FillForm()";
logExcpUIobj.ResourceName = "System_Settings_OrganizationForm.CS";
logExcpUIobj.RecordId = organizationFormUI.Tbl_OrganizationId;
logExcpUIobj.ExceptionDetails = "Error Occured. System Generated Error is: " + exp.ToString();
logExcpDALobj.SaveExceptionToDB(logExcpUIobj);
log.Error("[System_Settings_OrganizationForm : FillForm] An error occured in the processing of Record Id : " + organizationFormUI.Tbl_OrganizationId + ". Details : [" + exp.ToString() + "]");
}
}
public DataTable GetOrganizationListById(OrganizationFormUI organizationFormUI)
{
DataSet ds = new DataSet();
DataTable dtbl = new DataTable();
try
{
using (SqlConnection SupportCon = new SqlConnection(connectionString))
{
SqlCommand sqlCmd = new SqlCommand("SP_Organization_SelectById", SupportCon);
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.CommandTimeout = commandTimeout;
sqlCmd.Parameters.Add("@tbl_OrganizationId", SqlDbType.NVarChar);
sqlCmd.Parameters["@tbl_OrganizationId"].Value = organizationFormUI.Tbl_OrganizationId;
using (SqlDataAdapter adapter = new SqlDataAdapter(sqlCmd))
{
adapter.Fill(ds);
}
}
if (ds.Tables.Count > 0)
{
dtbl = ds.Tables[0];
}
}
catch (Exception exp)
{
logExcpUIobj.MethodName = "GetOrganizationListById()";
logExcpUIobj.ResourceName = "OrganizationFormDAL.CS";
logExcpUIobj.RecordId = organizationFormUI.Tbl_OrganizationId;
logExcpUIobj.ExceptionDetails = "Error Occured. System Generated Error is: " + exp.ToString();
logExcpDALobj.SaveExceptionToDB(logExcpUIobj);
log.Error("[OrganizationFormDAL : GetOrganizationListById] An error occured in the processing of Record Id : " + organizationFormUI.Tbl_OrganizationId + ". Details : [" + exp.ToString() + "]");
}
finally
{
ds.Dispose();
}
return(dtbl);
}
public int DeleteOrganization(OrganizationFormUI organizationFormUI)
{
int result = 0;
try
{
using (SqlConnection SupportCon = new SqlConnection(connectionString))
{
SupportCon.Open();
SqlCommand sqlCmd = new SqlCommand("SP_Organization_Delete", SupportCon);
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.CommandTimeout = commandTimeout;
sqlCmd.Parameters.Add("@tbl_OrganizationId", SqlDbType.NVarChar);
sqlCmd.Parameters["@tbl_OrganizationId"].Value = organizationFormUI.Tbl_OrganizationId;
result = sqlCmd.ExecuteNonQuery();
sqlCmd.Dispose();
SupportCon.Close();
}
}
catch (Exception exp)
{
logExcpUIobj.MethodName = "DeleteOrganization()";
logExcpUIobj.ResourceName = "OrganizationFormDAL.CS";
logExcpUIobj.RecordId = organizationFormUI.Tbl_OrganizationId;
logExcpUIobj.ExceptionDetails = "Error Occured. System Generated Error is: " + exp.ToString();
logExcpDALobj.SaveExceptionToDB(logExcpUIobj);
log.Error("[OrganizationFormDAL : DeleteOrganization] An error occured in the processing of Record Id : " + organizationFormUI.Tbl_OrganizationId + ". Details : [" + exp.ToString() + "]");
}
return(result);
}
protected void btnSave_Click(object sender, EventArgs e)
{
OrganizationFormUI organizationFormUI = new OrganizationFormUI();
try
{
//=====>>>IMAGE UPLOAD<<<<=============
Byte[] imgByte = null;
if (fuLogo.PostedFile != null)
{
//To create a PostedFile
HttpPostedFile File = fuLogo.PostedFile;
//Create byte Array with file len
imgByte = new Byte[File.ContentLength];
//force the control to load data in array
File.InputStream.Read(imgByte, 0, File.ContentLength);
}
organizationFormUI.CreatedBy = SessionContext.UserGuid;
organizationFormUI.Tbl_OrganizationTypeId = ddlOrganizationType.SelectedValue.ToString();
organizationFormUI.OrganizationCode = txtCode.Text.Trim();
organizationFormUI.Name = txtName.Text.Trim();
organizationFormUI.Address = txtAddress.Text.Trim();
organizationFormUI.City = txtCity.Text.Trim();
organizationFormUI.State = txtState.Text.Trim();
organizationFormUI.PostalCode = txtPostalCode.Text.Trim();
organizationFormUI.Tbl_CountryId = lblCountryGuid.Text;
organizationFormUI.PhoneNo = txtPhone.Text.Trim();
organizationFormUI.FaxNo = txtFax.Text.Trim();
organizationFormUI.Mobile = txtMobile.Text.Trim();
organizationFormUI.WebSite = txtWebsite.Text.Trim();
organizationFormUI.Email = txtEmail.Text.Trim();
organizationFormUI.Owner = txtOwner.Text.Trim();
organizationFormUI.Logo = imgByte;
if (organizationFormBAL.AddOrganization(organizationFormUI) == 1)
{
divSuccess.Visible = true;
lblSuccess.Text = Resources.GlobalResource.msgRecordInsertedSuccessfully;
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "clearform", "ClearForm();", true);
}
else
{
lblError.Text = Resources.GlobalResource.msgCouldNotInsertRecord;
divError.Visible = true;
}
}
catch (Exception exp)
{
logExcpUIobj.MethodName = "btnSave_Click()";
logExcpUIobj.ResourceName = "System_Settings_OrganizationForm.CS";
logExcpUIobj.RecordId = "";
logExcpUIobj.ExceptionDetails = "Error Occured. System Generated Error is: " + exp.ToString();
logExcpDALobj.SaveExceptionToDB(logExcpUIobj);
log.Error("[System_Settings_OrganizationForm : btnSave_Click] An error occured in the processing of Record Details : [" + exp.ToString() + "]");
}
}
public int AddOrganization(OrganizationFormUI organizationFormUI)
{
int result = 0;
try
{
using (SqlConnection SupportCon = new SqlConnection(connectionString))
{
SupportCon.Open();
SqlCommand sqlCmd = new SqlCommand("SP_Organization_Insert", SupportCon);
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.CommandTimeout = commandTimeout;
sqlCmd.Parameters.Add("@CreatedBy", SqlDbType.NVarChar);
sqlCmd.Parameters["@CreatedBy"].Value = organizationFormUI.CreatedBy;
sqlCmd.Parameters.Add("@tbl_OrganizationTypeId", SqlDbType.NVarChar);
sqlCmd.Parameters["@tbl_OrganizationTypeId"].Value = organizationFormUI.Tbl_OrganizationTypeId;
sqlCmd.Parameters.Add("@OrganizationCode", SqlDbType.NVarChar);
sqlCmd.Parameters["@OrganizationCode"].Value = organizationFormUI.OrganizationCode;
sqlCmd.Parameters.Add("@Name", SqlDbType.NVarChar);
sqlCmd.Parameters["@Name"].Value = organizationFormUI.Name;
sqlCmd.Parameters.Add("@Address", SqlDbType.NVarChar);
sqlCmd.Parameters["@Address"].Value = organizationFormUI.Address;
sqlCmd.Parameters.Add("@City", SqlDbType.NVarChar);
sqlCmd.Parameters["@City"].Value = organizationFormUI.City;
sqlCmd.Parameters.Add("@State", SqlDbType.NVarChar);
sqlCmd.Parameters["@State"].Value = organizationFormUI.State;
sqlCmd.Parameters.Add("@PostalCode", SqlDbType.NVarChar);
sqlCmd.Parameters["@PostalCode"].Value = organizationFormUI.PostalCode;
sqlCmd.Parameters.Add("@tbl_CountryId", SqlDbType.NVarChar);
sqlCmd.Parameters["@tbl_CountryId"].Value = organizationFormUI.Tbl_CountryId;
sqlCmd.Parameters.Add("@PhoneNo", SqlDbType.NVarChar);
sqlCmd.Parameters["@PhoneNo"].Value = organizationFormUI.PhoneNo;
sqlCmd.Parameters.Add("@FaxNo", SqlDbType.NVarChar);
sqlCmd.Parameters["@FaxNo"].Value = organizationFormUI.FaxNo;
sqlCmd.Parameters.Add("@Mobile", SqlDbType.NVarChar);
sqlCmd.Parameters["@Mobile"].Value = organizationFormUI.Mobile;
sqlCmd.Parameters.Add("@WebSite", SqlDbType.NVarChar);
sqlCmd.Parameters["@WebSite"].Value = organizationFormUI.WebSite;
sqlCmd.Parameters.Add("@Email", SqlDbType.NVarChar);
sqlCmd.Parameters["@Email"].Value = organizationFormUI.Email;
sqlCmd.Parameters.Add("@Owner", SqlDbType.NVarChar);
sqlCmd.Parameters["@Owner"].Value = organizationFormUI.Owner;
sqlCmd.Parameters.Add("@Logo", SqlDbType.Image);
sqlCmd.Parameters["@Logo"].Value = organizationFormUI.Logo;
result = sqlCmd.ExecuteNonQuery();
sqlCmd.Dispose();
SupportCon.Close();
}
}
catch (Exception exp)
{
logExcpUIobj.MethodName = "AddOrganization()";
logExcpUIobj.ResourceName = "OrganizationFormDAL.CS";
logExcpUIobj.RecordId = "";
logExcpUIobj.ExceptionDetails = "Error Occured. System Generated Error is: " + exp.ToString();
logExcpDALobj.SaveExceptionToDB(logExcpUIobj);
log.Error("[OrganizationFormDAL : AddOrganization] An error occured in the processing of Record. Details : [" + exp.ToString() + "]");
}
return(result);
}
