protected void Button_SO_Update_Click(object sender, EventArgs e)
{
String sectionTnC = Label_TNC_flag_SO.Text;
Boolean insertFlag = sectionTnC.Equals("Y");
Boolean updateStat = true;
ArrayList docFormatList = new ArrayList();
DocFormat sectionTnCObj = new DocFormat();
String docFormatId = "";
if (sectionTnC.Equals("Y"))
{
if (!TextBox_SO_format_name.Text.Equals("") && !TextBox_SO_TnC.Text.Equals(""))
{
docFormatId = new BackEndObjects.Id().getNewId(BackEndObjects.Id.ID_TYPE_DOCFORMAT_ID_STRING);
sectionTnCObj.setCmp_id(Session[SessionFactory.MAIN_BUSINESS_ENTITY_ID_STRING].ToString());
sectionTnCObj.setDoc_type(BackEndObjects.DocFormat.DOCFORMAT_DOC_TYPE_SALES_ORDER);
sectionTnCObj.setDocformat_id(docFormatId);
sectionTnCObj.setDocformat_name(TextBox_SO_format_name.Text);
sectionTnCObj.setSection_type(BackEndObjects.DocFormat.DOCFORMAT_DOC_TYPE_SALES_ORDER_SECTION_TYPE_TNC);
sectionTnCObj.setText(TextBox_SO_TnC.Text);
docFormatList.Add(sectionTnCObj);
}
}
else
{
Dictionary <String, String> whereCls = new Dictionary <string, string>();
whereCls.Add(BackEndObjects.DocFormat.DOCFORMAT_COL_CMP_ID, Session[SessionFactory.MAIN_BUSINESS_ENTITY_ID_STRING].ToString());
whereCls.Add(BackEndObjects.DocFormat.DOCFORMAT_COL_DOC_TYPE, BackEndObjects.DocFormat.DOCFORMAT_DOC_TYPE_SALES_ORDER);
whereCls.Add(BackEndObjects.DocFormat.DOCFORMAT_COL_SECTION_TYPE, BackEndObjects.DocFormat.DOCFORMAT_DOC_TYPE_SALES_ORDER_SECTION_TYPE_TNC);
Dictionary <String, String> targetVals = new Dictionary <string, string>();
targetVals.Add(BackEndObjects.DocFormat.DOCFORMAT_COL_TEXT, TextBox_SO_TnC.Text);
targetVals.Add(BackEndObjects.DocFormat.DOCFORMAT_COL_DOCFORMAT_NAME, TextBox_SO_format_name.Text);
BackEndObjects.DocFormat.updateDocFormatObjsDB(whereCls, targetVals, DBConn.Connections.OPERATION_UPDATE);
updateStat = true;
}
try
{
if (insertFlag)
{
BackEndObjects.DocFormat.insertDocFormatDB(docFormatList);
}
Label_SO_update_stat.Visible = true;
Label_SO_update_stat.ForeColor = System.Drawing.Color.Green;
Label_SO_update_stat.Text = "Updated Successfully";
}
catch (Exception ex)
{
Label_SO_update_stat.Visible = true;
Label_SO_update_stat.ForeColor = System.Drawing.Color.Red;
Label_SO_update_stat.Text = "Update Failed";
}
}
protected void Button_Inv_Update_Click(object sender, EventArgs e)
{
String sectionTnC = Label_TNC_flag_Inv.Text;
//The sectionTnC label helps to determinte whethere the sections need an insert or update
Boolean insertFlag = sectionTnC.Equals("Y");
Boolean updateStat = true;
ArrayList docFormatList = new ArrayList();
DocFormat sectionTnCObj = new DocFormat();
DocFormat sectionTaxCompObj = new DocFormat();
String docFormatId = "";
if (sectionTnC.Equals("Y"))
{
if (!TextBox_INV_format_name.Text.Equals("") && !TextBox_INV_TnC.Text.Equals(""))
{
docFormatId = new BackEndObjects.Id().getNewId(BackEndObjects.Id.ID_TYPE_DOCFORMAT_ID_STRING);
sectionTnCObj.setCmp_id(Session[SessionFactory.MAIN_BUSINESS_ENTITY_ID_STRING].ToString());
sectionTnCObj.setDoc_type(BackEndObjects.DocFormat.DOCFORMAT_DOC_TYPE_INVOICE);
sectionTnCObj.setDocformat_id(docFormatId);
sectionTnCObj.setDocformat_name(TextBox_INV_format_name.Text);
sectionTnCObj.setSection_type(BackEndObjects.DocFormat.DOCFORMAT_DOC_TYPE_INVOICE_SECTION_TYPE_TNC);
sectionTnCObj.setText(TextBox_INV_TnC.Text);
docFormatList.Add(sectionTnCObj);
}
}
else
{
Dictionary <String, String> whereCls = new Dictionary <string, string>();
whereCls.Add(BackEndObjects.DocFormat.DOCFORMAT_COL_CMP_ID, Session[SessionFactory.MAIN_BUSINESS_ENTITY_ID_STRING].ToString());
whereCls.Add(BackEndObjects.DocFormat.DOCFORMAT_COL_DOC_TYPE, BackEndObjects.DocFormat.DOCFORMAT_DOC_TYPE_INVOICE);
whereCls.Add(BackEndObjects.DocFormat.DOCFORMAT_COL_SECTION_TYPE, BackEndObjects.DocFormat.DOCFORMAT_DOC_TYPE_INVOICE_SECTION_TYPE_TNC);
Dictionary <String, String> targetVals = new Dictionary <string, string>();
targetVals.Add(BackEndObjects.DocFormat.DOCFORMAT_COL_TEXT, TextBox_INV_TnC.Text);
targetVals.Add(BackEndObjects.DocFormat.DOCFORMAT_COL_DOCFORMAT_NAME, TextBox_INV_format_name.Text);
BackEndObjects.DocFormat.updateDocFormatObjsDB(whereCls, targetVals, DBConn.Connections.OPERATION_UPDATE);
updateStat = true;
}
try
{
Boolean refreshTaxCompGrid = false;
if (!TextBox_Inv_Tax_Comp_Name.Text.Equals("") && !TextBox_Inv_Tax_Comp_Value.Text.Equals(""))
{
sectionTaxCompObj.setCmp_id(Session[SessionFactory.MAIN_BUSINESS_ENTITY_ID_STRING].ToString());
sectionTaxCompObj.setDoc_type(BackEndObjects.DocFormat.DOCFORMAT_DOC_TYPE_INVOICE);
docFormatId = docFormatId.Equals("") ? new BackEndObjects.Id().getNewId(BackEndObjects.Id.ID_TYPE_DOCFORMAT_ID_STRING) : docFormatId;
sectionTaxCompObj.setDocformat_id(docFormatId);
sectionTaxCompObj.setDocformat_name(TextBox_INV_format_name.Text);
sectionTaxCompObj.setSection_type(BackEndObjects.DocFormat.DOCFORMAT_DOC_TYPE_INVOICE_SECTION_TYPE_TAX);
sectionTaxCompObj.setSectionTypeName(TextBox_Inv_Tax_Comp_Name.Text);
sectionTaxCompObj.setText(TextBox_Inv_Tax_Comp_Value.Text);
docFormatList.Add(sectionTaxCompObj);
refreshTaxCompGrid = true;
}
if (docFormatList.Count > 0)
{
BackEndObjects.DocFormat.insertDocFormatDB(docFormatList);
}
if (refreshTaxCompGrid)
{
loadInvTaxCompGrid();
}
Label_Inv_Update_stat.Visible = true;
Label_Inv_Update_stat.ForeColor = System.Drawing.Color.Green;
Label_Inv_Update_stat.Text = "Updated Successfully";
}
catch (Exception ex)
{
Label_Inv_Update_stat.Visible = true;
Label_Inv_Update_stat.ForeColor = System.Drawing.Color.Red;
Label_Inv_Update_stat.Text = "Update Failed";
}
}