protected void pageSave(Object sender, BrilliantWMS.ToolbarService.iUCToolbarClient e)
{
try
{
string result = "";
CustomProfile profile = CustomProfile.GetProfile();
iSiteMasterClient InterfaceClient = new iSiteMasterClient();
if (checkDuplicate() == "")
{
string Tablename = ddlTable.SelectedItem.Text;
string DataType = ddlDataype.SelectedItem.Text;
string FieldName = txtFieldName.Text;
string IsNull = ddlIsNull.SelectedItem.Text;
if (hdnInterfaceID.Value != "0" && hdnInterfaceID.Value != "")
{
DataSet ds = new DataSet();
long ModifyBy = Convert.ToInt64(profile.Personal.UserID.ToString());
hdnSate.Value = "Edit";
InterfaceClient.UpdateInterface(Convert.ToInt64(hdnInterfaceID.Value), Tablename, DataType, FieldName, IsNull, ModifyBy, profile.DBConnection._constr);
}
else
{
hdnSate.Value = "AddNew";
long CreatedBy = Convert.ToInt64(profile.Personal.UserID.ToString());
InterfaceClient.InsertInterface(Tablename, DataType, FieldName, IsNull, CreatedBy, profile.DBConnection._constr);
}
if (hdnSate.Value == "Edit")
{
WebMsgBox.MsgBox.Show("Record Update sussessfully");
ClearAll();
}
if (hdnSate.Value == "AddNew")
{
WebMsgBox.MsgBox.Show("Record saved sussessfully");
ClearAll();
}
}
}
catch (System.Exception ex)
{
Login.Profile.ErrorHandling(ex, this, "Product master", "pageSave");
}
finally
{
}
}
protected void BindDatatype()
{
iSiteMasterClient objService = new iSiteMasterClient();
CustomProfile profile = CustomProfile.GetProfile();
DataSet DatatType = new DataSet();
DatatType = objService.GetDataTypeList(profile.DBConnection._constr);
ddlDataype.DataSource = DatatType;
ddlDataype.DataBind();
ListItem lst = new ListItem();
lst.Text = "--Select--";
lst.Value = "0";
ddlDataype.Items.Insert(0, lst);
}
protected void BindGrid()
{
try
{
iSiteMasterClient SiteMasterClient = new iSiteMasterClient();
CustomProfile profile = CustomProfile.GetProfile();
GvSite.DataSource = SiteMasterClient.GetmTerritoryList(profile.DBConnection._constr);
GvSite.DataBind();
SiteMasterClient.GetmTerritoryList(profile.DBConnection._constr);
}
catch (System.Exception ex)
{
Login.Profile.ErrorHandling(ex, this, "Site Master", "pageSave");
}
finally
{
}
}
public void BindDropDown()
{
try
{
iSiteMasterClient SiteMasterClient = new iSiteMasterClient();
CustomProfile profile = CustomProfile.GetProfile();
ddlSite.DataSource = SiteMasterClient.GetSiteDtls(profile.DBConnection._constr);
ddlSite.DataBind();
ListItem lst1 = new ListItem();
lst1.Text = "-Select-";
lst1.Value = "0";
ddlSite.Items.Insert(0, lst1);
}
catch (System.Exception ex)
{
Login.Profile.ErrorHandling(ex, this, "Site Master", "pageSave");
}
finally
{
}
}
protected void pageSave(Object sender, BrilliantWMS.ToolbarService.iUCToolbarClient e)
{
try
{
CustomProfile profile = CustomProfile.GetProfile();
mTerritory objmTerritory = new mTerritory();
tAddress objtAddress = new tAddress();
iSiteMasterClient SiteMasterClient = new iSiteMasterClient();
if (HdnSiteId.Value != "")
{
v_GetSiteDetails SiteDtls = new v_GetSiteDetails();
SiteDtls = SiteMasterClient.GetTerritoryListByID(Convert.ToInt64(HdnSiteId.Value), profile.DBConnection._constr);
objtAddress.CreatedBy = SiteDtls.Address_CreatedBy;
objtAddress.CreationDate = SiteDtls.Address_CreationDate;
objtAddress.ReferenceID = SiteDtls.ReferenceID;
objtAddress.ID = SiteDtls.AddressID;
objmTerritory.CreatedBy = SiteDtls.CreatedBy;
objmTerritory.CreationDate = SiteDtls.CreationDate;
}
else
{
objtAddress.LastModifiedBy = profile.Personal.UserID.ToString();
objtAddress.LastModifiedDate = DateTime.Now;
objmTerritory.LastModifiedBy = profile.Personal.UserID.ToString();
objmTerritory.LastModifiedDate = DateTime.Now;
}
objtAddress.AddressLine1 = null;
if (txtCAddress1.Text.ToString().Trim() != "")
{
objtAddress.AddressLine1 = txtCAddress1.Text;
}
objtAddress.County = hdnCountry.Value;
objtAddress.State = hdnState.Value;
objtAddress.City = null;
if (txtCity.Text.ToString().Trim() != "")
{
objtAddress.City = txtCity.Text;
}
objtAddress.Zipcode = null;
if (txtZipCode.Text.ToString().Trim() != "")
{
objtAddress.Zipcode = txtZipCode.Text;
}
objtAddress.Landmark = null;
if (txtLandMark.Text.ToString().Trim() != "")
{
objtAddress.Landmark = txtLandMark.Text;
}
objtAddress.EmailID = null;
if (txtemailid.Text.ToString().Trim() != "")
{
objtAddress.EmailID = txtemailid.Text;
}
objtAddress.PhoneNo = null;
if (txtphoneno.Text.ToString().Trim() != "")
{
objtAddress.PhoneNo = txtphoneno.Text;
}
objtAddress.FaxNo = null;
if (txtFax.Text.ToString().Trim() != "")
{
objtAddress.FaxNo = txtFax.Text;
}
objtAddress.Active = "Y";
objtAddress.AddressType = "none";
objtAddress.ObjectName = "Site";
objtAddress.CompanyID = profile.Personal.CompanyID;
objmTerritory.Territory = null;
if (txtSiteName.Text.ToString().Trim() != "")
{
objmTerritory.Territory = txtSiteName.Text;
}
objmTerritory.ParentID = null;
objmTerritory.ParentID = 1; //For HQ
objmTerritory.Level = null;
objmTerritory.Level = 2;
objmTerritory.GroupTitle = null;
objmTerritory.GroupTitle = "Site";
if (HdnSiteId.Value == string.Empty)
{
objmTerritory.CreatedBy = profile.Personal.UserID.ToString();
objmTerritory.CreationDate = DateTime.Now;
objtAddress.CreatedBy = profile.Personal.UserID.ToString();
objtAddress.CreationDate = DateTime.Now;
long result = SiteMasterClient.InsertSiteMaster(objmTerritory, profile.DBConnection._constr);
objtAddress.ReferenceID = result;
long result1 = SiteMasterClient.InsertSiteAddress(objtAddress, profile.DBConnection._constr);
if (result != 0 && result1 != 0)
{
WebMsgBox.MsgBox.Show("Record saved successfully");
}
}
else
{
objmTerritory.ID = Convert.ToInt64(HdnSiteId.Value);
objmTerritory.LastModifiedBy = profile.Personal.UserID.ToString();
objmTerritory.LastModifiedDate = DateTime.Now;
objtAddress.LastModifiedBy = profile.Personal.UserID.ToString();
objtAddress.LastModifiedDate = DateTime.Now;
long result = SiteMasterClient.updatemTerritory(objmTerritory, profile.DBConnection._constr);
long result1 = SiteMasterClient.updateSiteAddress(objtAddress, profile.DBConnection._constr);
if (result != 0 && result1 != 0)
{
WebMsgBox.MsgBox.Show("Record Update successfully");
}
}
BindGrid();
clear();
}
catch (System.Exception ex)
{
Login.Profile.ErrorHandling(ex, this, "Site Master", "pageSave");
}
finally
{
}
}
protected void GvSite_Select(object sender, Obout.Grid.GridRecordEventArgs e)
{
try
{
CustomProfile profile = CustomProfile.GetProfile();
Hashtable selectedrec = (Hashtable)GvSite.SelectedRecords[0];
HdnSiteId.Value = selectedrec["ID"].ToString();
iSiteMasterClient SiteMasterClient = new iSiteMasterClient();
v_GetSiteDetails objv_GetSiteDetails = new v_GetSiteDetails();
objv_GetSiteDetails = SiteMasterClient.GetTerritoryListByID(Convert.ToInt32(HdnSiteId.Value), profile.DBConnection._constr);
if (objv_GetSiteDetails.AddressLine1 != null)
{
txtCAddress1.Text = objv_GetSiteDetails.AddressLine1;
}
if (objv_GetSiteDetails.County != null)
{
hdnCountry.Value = objv_GetSiteDetails.County;
}
if (objv_GetSiteDetails.State != null)
{
hdnState.Value = objv_GetSiteDetails.State;
}
Page.ClientScript.RegisterStartupScript(GetType(), "fillCountry" + sessionID, "setCountry('" + objv_GetSiteDetails.County + "','" + objv_GetSiteDetails.State + "');", true);
if (objv_GetSiteDetails.City != null)
{
txtCity.Text = objv_GetSiteDetails.City;
}
if (objv_GetSiteDetails.Zipcode != null)
{
txtZipCode.Text = objv_GetSiteDetails.Zipcode;
}
if (objv_GetSiteDetails.Landmark != null)
{
txtLandMark.Text = objv_GetSiteDetails.Landmark;
}
if (objv_GetSiteDetails.EmailID != null)
{
txtemailid.Text = objv_GetSiteDetails.EmailID;
}
if (objv_GetSiteDetails.PhoneNo != null)
{
txtphoneno.Text = objv_GetSiteDetails.PhoneNo;
}
if (objv_GetSiteDetails.FaxNo != null)
{
txtFax.Text = objv_GetSiteDetails.FaxNo;
}
if (objv_GetSiteDetails.Territory != null)
{
txtSiteName.Text = objv_GetSiteDetails.Territory;
}
}
catch (System.Exception ex)
{
Login.Profile.ErrorHandling(ex, this, "Site Master", "pageSave");
}
finally
{
}
}
