public static void WMRemoveFieldFromUserListAtEditTime(string ID)
{
iProductCategoryMasterClient Message = new iProductCategoryMasterClient();
CustomProfile profile = CustomProfile.GetProfile();
try
{
Message.DeleteFieldFromListWhenEdit(Convert.ToInt64(ID), profile.DBConnection._constr);
}
catch { }
finally { }
}
public void BindObject()
{
iProductCategoryMasterClient ObjectClient = new iProductCategoryMasterClient();
CustomProfile profile = CustomProfile.GetProfile();
ddlObject.DataSource = ObjectClient.GetObject(profile.DBConnection._constr);
ddlObject.DataBind();
ListItem lst = new ListItem();
lst.Text = "--Select--";
lst.Value = "0";
ddlObject.Items.Insert(0, lst);
}
protected void AddBtn_Click(object sender, System.EventArgs e)
{
string Title, Destination, Type, Purpose, Object1;
long Sequence, Field1;
Title = txtTitle.Text;
Destination = ddlDestination.SelectedItem.Text;
Type = ddlType.SelectedItem.Text;
Purpose = txtPurpose.Text;
Object1 = ddlObject.SelectedItem.Text;
Field1 = Convert.ToInt64(hdnSelectedField.Value);
Sequence = Convert.ToInt64(txtSequence.Text);
iProductCategoryMasterClient Message = new iProductCategoryMasterClient();
CustomProfile profile = CustomProfile.GetProfile();
if (hdnState.Value == "Add")
{
try
{
//Message.DeleteMessageTemptable(profile.DBConnection._constr);
Message.InsertMessageIntoTemptable(Title, Destination, Type, Purpose, Object1, Field1, Sequence, profile.DBConnection._constr);
GetFieldList();
txtSequence.Text = "";
ddlObject.SelectedIndex = -1;
ddlField.SelectedIndex = -1;
}
catch
{ }
finally
{ }
}
if (hdnState.Value == "Edit")
{
long MsgHeadID = Convert.ToInt64(hdnMessageID.Value);
long Sequence1 = Convert.ToInt64(txtSequence.Text);
long Field = Convert.ToInt64(hdnSelectedField.Value);
long CreateBy = profile.Personal.UserID;
try
{
Message.InsertMessageDetails(MsgHeadID, Field, Sequence1, CreateBy, profile.DBConnection._constr);
GetFieldList();
}
catch
{ }
finally
{ }
}
}
public static List <mInterfaceMap> PMGetFieldList(string Selectedbject)
{
iProductCategoryMasterClient ObjectClient = new iProductCategoryMasterClient();
List <mInterfaceMap> FieldList = new List <mInterfaceMap>();
try
{
CustomProfile profile = CustomProfile.GetProfile();
FieldList = ObjectClient.FieldList(Selectedbject, profile.DBConnection._constr).ToList();
}
catch (System.Exception ex)
{
Login.Profile.ErrorHandling(ex, "User Creation", "PMfillDesignation");
}
finally
{
}
return(FieldList);
}
protected void GetFieldList()
{
iProductCategoryMasterClient objService = new iProductCategoryMasterClient();
CustomProfile profile = CustomProfile.GetProfile();
GVFields.DataSource = null;
GVFields.DataBind();
DataSet dsFieldList = new DataSet();
if (hdnState.Value == "Add")
{
dsFieldList = objService.GetFieldDetails(profile.DBConnection._constr);
}
if (hdnState.Value == "Edit")
{
dsFieldList = objService.GetFieldDetailsFromMessageTable(Convert.ToInt64(hdnMessageID.Value), profile.DBConnection._constr);
}
GVFields.DataSource = dsFieldList;
GVFields.DataBind();
}
protected void pageAddNew(Object sender, BrilliantWMS.ToolbarService.iUCToolbarClient e)
{
iProductCategoryMasterClient Message = new iProductCategoryMasterClient();
CustomProfile profile = CustomProfile.GetProfile();
tblInterfaceDefLst.Visible = false;
tbTemplateDetail.Visible = true;
tabContainerReqTemplate.ActiveTabIndex = 1;
hdnState.Value = "Add";
if (hdnState.Value == "Add")
{
Message.DeleteMessageTemptable(profile.DBConnection._constr);
}
clear();
//GetProductSpecificationDetailByProductID();
//GetProductTaxDetailByProductID();
//GetProductImagesByProductID();
//GVRateHistory();
//FillInventoryGrid();
//setActiveTab(1);
//changePrice1.Attributes.Add("style", "visibility:hidden");
}
protected void pageSave(Object sender, BrilliantWMS.ToolbarService.iUCToolbarClient e)
{
iProductCategoryMasterClient Message = new iProductCategoryMasterClient();
CustomProfile profile = CustomProfile.GetProfile();
if (hdnState.Value == "Add")
{
DataSet ds = new DataSet();
long HeaderId = 0;
try
{
ds = Message.GetMessageTempData(profile.DBConnection._constr);
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
if (i < 1)
{
string Destination = ds.Tables[i].Rows[i]["Destination"].ToString();
string ActionType = ds.Tables[i].Rows[i]["ActionType"].ToString();
string TableName = ds.Tables[i].Rows[i]["TableName"].ToString();
string description = ds.Tables[i].Rows[i]["description"].ToString();
string Remark = ds.Tables[i].Rows[i]["Remark"].ToString();
string sequence = ds.Tables[i].Rows[i]["sequence"].ToString();
string FieldID = ds.Tables[i].Rows[i]["FieldID"].ToString();
long CreatedBy = profile.Personal.UserID;
Message.InsertMessageHeader(Destination, ActionType, TableName, description, CreatedBy, Remark, profile.DBConnection._constr);
DataSet ds1 = new DataSet();
ds1 = Message.GetMessHeaderID(profile.DBConnection._constr);
HeaderId = Convert.ToInt64(ds1.Tables[0].Rows[0][0].ToString());
Message.InsrtIntoMessageHeader(HeaderId, Convert.ToInt64(sequence), Convert.ToInt64(FieldID), CreatedBy, profile.DBConnection._constr);
}
else
{
long Sequence = Convert.ToInt64(ds.Tables[0].Rows[i]["sequence"].ToString());
long FieldID = Convert.ToInt64(ds.Tables[0].Rows[i]["FieldID"].ToString());
long CreatedBy = profile.Personal.UserID;
Message.InsrtIntoMessageHeader(HeaderId, Sequence, FieldID, CreatedBy, profile.DBConnection._constr);
}
}
Message.DeleteMessageTemptable(profile.DBConnection._constr);
WebMsgBox.MsgBox.Show("Record saved successfully");
}
catch
{ }
finally
{ }
}
else if (hdnState.Value == "Edit")
{
long MessageID = Convert.ToInt64(hdnMessageID.Value);
long ModifyBy = profile.Personal.UserID;
string Destination = ddlDestination.SelectedItem.Text;
string ActionType = ddlType.SelectedItem.Text;
string TableName = ddlObject.SelectedItem.Text;
string description = txtTitle.Text;
string Remark = txtPurpose.Text;
try
{
Message.UpdateMessageHeader(MessageID, Destination, ActionType, TableName, description, ModifyBy, Remark, profile.DBConnection._constr);
WebMsgBox.MsgBox.Show("Record Update successfully");
clear();
}
catch { }
finally { }
}
}