public Invoice GetInvoiceByName(Guid gCURRENCY_ID, string sNAME)
{
var item = new Invoice();
{
if (Security.USER_ID == Guid.Empty)
throw (new Exception("Authentication required"));
var oQuery = new InlineQueryDBManager();
string innerSql = ApplicationSQL.SQL["Invoices_AutoComplete_50"].ToString();
oQuery.CommandText = innerSql;
CRMSecurity.Filter(oQuery, "Invoices", "list");
TypeConvert.AppendParameter(oQuery, sNAME, CommonTypeConvert.SqlFilterMode.StartsWith, "NAME");
using (SqlDataReader rdr = oQuery.ExecuteReader(CommandBehavior.SingleRow))
{
if (rdr.Read())
{
item.ID = CommonTypeConvert.ToGuid(rdr["ID"]);
item.NAME = CommonTypeConvert.ToString(rdr["NAME"]);
item.AMOUNT_DUE = CommonTypeConvert.ToDecimal(rdr["AMOUNT_DUE"]);
item.AMOUNT_DUE_USDOLLAR = CommonTypeConvert.ToDecimal(rdr["AMOUNT_DUE_USDOLLAR"]);
if (gCURRENCY_ID != CommonTypeConvert.ToGuid(rdr["CURRENCY_ID"]))
{
Currency C10n = Currency.CreateCurrency(gCURRENCY_ID);
item.AMOUNT_DUE = Currency.GetCurrency.ToCurrency(item.AMOUNT_DUE_USDOLLAR);
}
}
}
if (CommonTypeConvert.IsEmptyGuid(item.ID))
throw (new Exception("Item not found"));
}
return item;
}
private void UpdateContact(Guid gCONTACT_ID, bool bUpdateBilling, bool bUpdateShipping)
{
string innerSql = ApplicationSQL.SQL["Invoices_EditView_267"].ToString();
var oQuery = new InlineQueryDBManager();
oQuery.CommandText = innerSql;
oQuery.Add("@ID", SqlDbType.UniqueIdentifier, gCONTACT_ID);
using (SqlDataReader rdr = oQuery.ExecuteReader(CommandBehavior.SingleRow))
{
if (rdr.Read())
{
if (bUpdateBilling)
{
new DynamicControl(this, "BILLING_CONTACT_ID").ID = CommonTypeConvert.ToGuid(rdr["ID"]);
new DynamicControl(this, "BILLING_CONTACT_NAME").Text = CommonTypeConvert.ToString(rdr["NAME"]);
}
if (bUpdateShipping)
{
new DynamicControl(this, "SHIPPING_CONTACT_ID").ID = CommonTypeConvert.ToGuid(rdr["ID"]);
new DynamicControl(this, "SHIPPING_CONTACT_NAME").Text = CommonTypeConvert.ToString(rdr["NAME"]);
}
Guid gACCOUNT_ID = CommonTypeConvert.ToGuid(rdr["ACCOUNT_ID"]);
if (!CommonTypeConvert.IsEmptyGuid(gACCOUNT_ID))
{
UpdateAccount(gACCOUNT_ID, bUpdateBilling, bUpdateShipping);
}
}
}
}
protected void Page_Command(object sender, CommandEventArgs e)
{
if (e.CommandName == "Refund")
{
Guid gPAYMENTS_TRANSACTION_ID = CommonTypeConvert.ToGuid(e.CommandArgument);
var oQuery = new InlineQueryDBManager();
string innerSql = ApplicationSQL.SQL["PaymentTransactions"].ToString();
oQuery.CommandText = innerSql;
TypeConvert.AppendParameter(oQuery, gPAYMENTS_TRANSACTION_ID, "ID", false);
using (SqlDataReader rdr = oQuery.ExecuteReader(CommandBehavior.SingleRow))
{
if (rdr.Read())
{
Guid gCURRENCY_ID = CommonTypeConvert.ToGuid(rdr["CURRENCY_ID"]);
Guid gACCOUNT_ID = CommonTypeConvert.ToGuid(rdr["ACCOUNT_ID"]);
Guid gCREDIT_CARD_ID = CommonTypeConvert.ToGuid(rdr["CREDIT_CARD_ID"]);
string sINVOICE_NUMBER = CommonTypeConvert.ToString(rdr["INVOICE_NUMBER"]);
Decimal dAMOUNT = CommonTypeConvert.ToDecimal(rdr["AMOUNT"]);
string sDESCRIPTION = CommonTypeConvert.ToString(rdr["DESCRIPTION"]);
string sTRANSACTION_NUMBER = CommonTypeConvert.ToString(rdr["TRANSACTION_NUMBER"]);
//CRM.Common.Charge.CC.Refund(Application, gID, gCURRENCY_ID, gACCOUNT_ID, gCREDIT_CARD_ID, Request.UserHostAddress, sINVOICE_NUMBER, sDESCRIPTION, dAMOUNT, sTRANSACTION_NUMBER);
BindGrid();
}
}
}
}
protected void btnProductChanged_Clicked(object sender, EventArgs e)
{
var oQuery = new InlineQueryDBManager();
string innerSql = ApplicationSQL.SQL["Products_EditView_161"].ToString();
oQuery.CommandText = innerSql;
Guid gPRODUCT_TEMPLATE_ID = new DynamicControl(this, "PRODUCT_TEMPLATE_ID").ID;
TypeConvert.AppendParameter(oQuery, gPRODUCT_TEMPLATE_ID, "ID", false);
using (SqlDataReader rdr = oQuery.ExecuteReader(CommandBehavior.SingleRow))
{
if (rdr.Read())
{
ctlModuleHeader.Title = CommonTypeConvert.ToString(rdr["NAME"]);
SetPageTitle(Translation.GetTranslation.Term(".moduleList." + m_sMODULE) + " - " +
ctlModuleHeader.Title);
Utils.UpdateTracker(Page, m_sMODULE, gID, ctlModuleHeader.Title);
ViewState["ctlModuleHeader.Title"] = ctlModuleHeader.Title;
CRMDynamic.SetEditViewFields(this, m_sMODULE + ".EditView", rdr);
CRMDynamic.SetEditViewFields(this, m_sMODULE + ".CostView", rdr);
CRMDynamic.SetEditViewFields(this, m_sMODULE + ".MftView", rdr);
var txtNAME = FindControl("NAME") as TextBox;
if (txtNAME != null)
{
txtNAME.ReadOnly = false;
}
}
}
}
protected void Page_Command(object sender, CommandEventArgs e)
{
if (e.CommandName == "Refund")
{
Guid gPAYMENTS_TRANSACTION_ID = CommonTypeConvert.ToGuid(e.CommandArgument);
var oQuery = new InlineQueryDBManager();
string innerSql = ApplicationSQL.SQL["PaymentTransactions"].ToString();
oQuery.CommandText = innerSql;
TypeConvert.AppendParameter(oQuery, gPAYMENTS_TRANSACTION_ID, "ID", false);
using (SqlDataReader rdr = oQuery.ExecuteReader(CommandBehavior.SingleRow))
{
if (rdr.Read())
{
Guid gCURRENCY_ID = CommonTypeConvert.ToGuid(rdr["CURRENCY_ID"]);
Guid gACCOUNT_ID = CommonTypeConvert.ToGuid(rdr["ACCOUNT_ID"]);
Guid gCREDIT_CARD_ID = CommonTypeConvert.ToGuid(rdr["CREDIT_CARD_ID"]);
string sINVOICE_NUMBER = CommonTypeConvert.ToString(rdr["INVOICE_NUMBER"]);
Decimal dAMOUNT = CommonTypeConvert.ToDecimal(rdr["AMOUNT"]);
string sDESCRIPTION = CommonTypeConvert.ToString(rdr["DESCRIPTION"]);
string sTRANSACTION_NUMBER = CommonTypeConvert.ToString(rdr["TRANSACTION_NUMBER"]);
//CRM.Common.Charge.CC.Refund(Application, gID, gCURRENCY_ID, gACCOUNT_ID, gCREDIT_CARD_ID, Request.UserHostAddress, sINVOICE_NUMBER, sDESCRIPTION, dAMOUNT, sTRANSACTION_NUMBER);
BindGrid();
}
}
}
}
protected void PAYMENT_TYPE_Changed(object sender, EventArgs e)
{
var PAYMENT_TYPE = tblMain.FindControl("PAYMENT_TYPE") as DropDownList;
if (PAYMENT_TYPE != null)
{
bool bCreditCard = PAYMENT_TYPE.SelectedValue == "Credit Card";
ctlDynamicButtons.ShowButton("Charge", bCreditCard);
new DynamicControl(this, "CREDIT_CARD_ID_LABEL").Visible = bCreditCard;
new DynamicControl(this, "CREDIT_CARD_NAME").Visible = bCreditCard;
new DynamicControl(this, "CREDIT_CARD_ID_btnChange").Visible = bCreditCard;
new DynamicControl(this, "CREDIT_CARD_ID_btnClear").Visible = bCreditCard;
if (bCreditCard && CommonTypeConvert.IsEmptyGuid(new DynamicControl(this, "CREDIT_CARD_ID").ID))
{
var oQuery = new InlineQueryDBManager();
string innerSql = ApplicationSQL.SQL["Payments_EditView_214"].ToString();
oQuery.CommandText = innerSql;
Guid gACCOUNT_ID = new DynamicControl(this, "ACCOUNT_ID").ID;
TypeConvert.AppendParameter(oQuery, gACCOUNT_ID, "ACCOUNT_ID", false);
using (SqlDataReader rdr = oQuery.ExecuteReader(CommandBehavior.SingleRow))
{
if (rdr.Read())
{
new DynamicControl(this, "CREDIT_CARD_ID").ID = CommonTypeConvert.ToGuid(rdr["ID"]);
new DynamicControl(this, "CREDIT_CARD_NAME").Text = CommonTypeConvert.ToString(rdr["NAME"]);
}
}
}
}
}
protected void btnProductChanged_Clicked(object sender, EventArgs e)
{
var oQuery = new InlineQueryDBManager();
string innerSql = ApplicationSQL.SQL["Products_EditView_161"].ToString();
oQuery.CommandText = innerSql;
Guid gPRODUCT_TEMPLATE_ID = new DynamicControl(this, "PRODUCT_TEMPLATE_ID").ID;
TypeConvert.AppendParameter(oQuery, gPRODUCT_TEMPLATE_ID, "ID", false);
using (SqlDataReader rdr = oQuery.ExecuteReader(CommandBehavior.SingleRow))
{
if (rdr.Read())
{
ctlModuleHeader.Title = CommonTypeConvert.ToString(rdr["NAME"]);
SetPageTitle(Translation.GetTranslation.Term(".moduleList." + m_sMODULE) + " - " +
ctlModuleHeader.Title);
Utils.UpdateTracker(Page, m_sMODULE, gID, ctlModuleHeader.Title);
ViewState["ctlModuleHeader.Title"] = ctlModuleHeader.Title;
CRMDynamic.SetEditViewFields(this, m_sMODULE + ".EditView", rdr);
CRMDynamic.SetEditViewFields(this, m_sMODULE + ".CostView", rdr);
CRMDynamic.SetEditViewFields(this, m_sMODULE + ".MftView", rdr);
var txtNAME = FindControl("NAME") as TextBox;
if (txtNAME != null)
txtNAME.ReadOnly = false;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
SetPageTitle(Translation.GetTranslation.Term(".moduleList." + m_sMODULE));
Visible = (Security.GetUserAccess(m_sMODULE, "edit") >= 0);
if (!Visible)
{
return;
}
gID = CommonTypeConvert.ToGuid(Request["ID"]);
if (!IsPostBack)
{
ctlDynamicButtons.AppendButtons(m_sMODULE + ".EditView", Guid.Empty, null);
Guid gDuplicateID = CommonTypeConvert.ToGuid(Request["DuplicateID"]);
if (!CommonTypeConvert.IsEmptyGuid(gID) || !CommonTypeConvert.IsEmptyGuid(gDuplicateID))
{
var oQuery = new InlineQueryDBManager();
string innerSql = ApplicationSQL.SQL["Administration_ProductTemplates_EditView"].ToString();
oQuery.CommandText = innerSql;
if (!CommonTypeConvert.IsEmptyGuid(gDuplicateID))
{
oQuery.Add("@ID", SqlDbType.UniqueIdentifier, gDuplicateID);
gID = Guid.Empty;
}
else
{
oQuery.Add("@ID", SqlDbType.UniqueIdentifier, gID);
}
using (SqlDataReader rdr = oQuery.ExecuteReader(CommandBehavior.SingleRow))
{
if (rdr.Read())
{
ctlModuleHeader.Title = CommonTypeConvert.ToString(rdr["NAME"]);
SetPageTitle(Translation.GetTranslation.Term(".moduleList." + m_sMODULE) + " - " +
ctlModuleHeader.Title);
Utils.UpdateTracker(Page, m_sMODULE, gID, ctlModuleHeader.Title);
ViewState["ctlModuleHeader.Title"] = ctlModuleHeader.Title;
AppendEditViewFields(m_sMODULE + ".EditView", tblMain, rdr);
}
}
}
else
{
AppendEditViewFields(m_sMODULE + ".EditView", tblMain, null);
}
}
else
{
ctlModuleHeader.Title = CommonTypeConvert.ToString(ViewState["ctlModuleHeader.Title"]);
SetPageTitle(Translation.GetTranslation.Term(".moduleList." + m_sMODULE) + " - " + ctlModuleHeader.Title);
}
}
protected void Page_Load(object sender, EventArgs e)
{
SetPageTitle(Translation.GetTranslation.Term(".moduleList." + m_sMODULE));
Visible = (Security.GetUserAccess(m_sMODULE, "view") >= 0);
if (!Visible)
{
return;
}
gID = CommonTypeConvert.ToGuid(Request["ID"]);
if (!IsPostBack)
{
if (!CommonTypeConvert.IsEmptyGuid(gID))
{
string innerSql = ApplicationSQL.SQL["Invoices_EditView_323"].ToString();
var oQuery = new InlineQueryDBManager();
oQuery.CommandText = innerSql;
CRMSecurity.Filter(oQuery, m_sMODULE, "view");
TypeConvert.AppendParameter(oQuery, gID, "ID", false);
using (SqlDataReader rdr = oQuery.ExecuteReader(CommandBehavior.SingleRow))
{
if (rdr.Read())
{
ctlModuleHeader.Title = CommonTypeConvert.ToString(rdr["NAME"]);
SetPageTitle(Translation.GetTranslation.Term(".moduleList." + m_sMODULE) + " - " +
ctlModuleHeader.Title);
Utils.UpdateTracker(Page, m_sMODULE, gID, ctlModuleHeader.Title);
AppendDetailViewFields(m_sMODULE + ".DetailView", tblMain, rdr, Page_Command);
AppendDetailViewFields(m_sMODULE + ".SummaryView", tblSummary, rdr, Page_Command);
Page.Items["ASSIGNED_USER_ID"] = CommonTypeConvert.ToGuid(rdr["ASSIGNED_USER_ID"]);
ctlDynamicButtons.AppendButtons(m_sMODULE + ".DetailView",
CommonTypeConvert.ToGuid(rdr["ASSIGNED_USER_ID"]), rdr);
}
else
{
plcSubPanel.Visible = false;
ctlDynamicButtons.AppendButtons(m_sMODULE + ".DetailView", Guid.Empty, null);
ctlDynamicButtons.DisableAll();
ctlDynamicButtons.ErrorText = Translation.GetTranslation.Term("ACL.LBL_NO_ACCESS");
}
}
}
else
{
ctlDynamicButtons.AppendButtons(m_sMODULE + ".DetailView", Guid.Empty, null);
ctlDynamicButtons.DisableAll();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
SetPageTitle(Translation.GetTranslation.Term(".moduleList." + m_sMODULE));
Visible = (Security.GetUserAccess(m_sMODULE, "view") >= 0);
if (!Visible)
return;
gID = CommonTypeConvert.ToGuid(Request["ID"]);
if (!IsPostBack)
{
if (!CommonTypeConvert.IsEmptyGuid(gID))
{
string innerSql = ApplicationSQL.SQL["Invoices_EditView_323"].ToString();
var oQuery = new InlineQueryDBManager();
oQuery.CommandText = innerSql;
CRMSecurity.Filter(oQuery, m_sMODULE, "view");
TypeConvert.AppendParameter(oQuery, gID, "ID", false);
using (SqlDataReader rdr = oQuery.ExecuteReader(CommandBehavior.SingleRow))
{
if (rdr.Read())
{
ctlModuleHeader.Title = CommonTypeConvert.ToString(rdr["NAME"]);
SetPageTitle(Translation.GetTranslation.Term(".moduleList." + m_sMODULE) + " - " +
ctlModuleHeader.Title);
Utils.UpdateTracker(Page, m_sMODULE, gID, ctlModuleHeader.Title);
AppendDetailViewFields(m_sMODULE + ".DetailView", tblMain, rdr, Page_Command);
AppendDetailViewFields(m_sMODULE + ".SummaryView", tblSummary, rdr, Page_Command);
Page.Items["ASSIGNED_USER_ID"] = CommonTypeConvert.ToGuid(rdr["ASSIGNED_USER_ID"]);
ctlDynamicButtons.AppendButtons(m_sMODULE + ".DetailView",
CommonTypeConvert.ToGuid(rdr["ASSIGNED_USER_ID"]), rdr);
}
else
{
plcSubPanel.Visible = false;
ctlDynamicButtons.AppendButtons(m_sMODULE + ".DetailView", Guid.Empty, null);
ctlDynamicButtons.DisableAll();
ctlDynamicButtons.ErrorText = Translation.GetTranslation.Term("ACL.LBL_NO_ACCESS");
}
}
}
else
{
ctlDynamicButtons.AppendButtons(m_sMODULE + ".DetailView", Guid.Empty, null);
ctlDynamicButtons.DisableAll();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
SetPageTitle(Translation.GetTranslation.Term("Manufacturers.LBL_NAME"));
Visible = Security.IS_ADMIN;
Visible = Security.ADMIN_TYPE == 0 ? true : false;
if (!Visible)
{
return;
}
reqNAME.DataBind();
reqLIST_ORDER.DataBind();
gID = CommonTypeConvert.ToGuid(Request["ID"]);
if (!IsPostBack)
{
ctlDynamicButtons.AppendButtons(m_sMODULE + ".EditView", Guid.Empty, null);
lstSTATUS.DataSource = CRMCache.List("manufacturer_status_dom");
lstSTATUS.DataBind();
if (!CommonTypeConvert.IsEmptyGuid(gID))
{
var oQuery = new InlineQueryDBManager();
string innerSql = ApplicationSQL.SQL["Administration_Manufacturers_EditView"].ToString();
oQuery.CommandText = innerSql;
oQuery.Add("@ID", SqlDbType.UniqueIdentifier, gID);
using (SqlDataReader rdr = oQuery.ExecuteReader(CommandBehavior.SingleRow))
{
if (rdr.Read())
{
txtNAME.Text = CommonTypeConvert.ToString(rdr["NAME"]);
ctlListHeader.Title = Translation.GetTranslation.Term("Manufacturers.LBL_NAME") + " " +
txtNAME.Text;
txtLIST_ORDER.Text = CommonTypeConvert.ToString(rdr["LIST_ORDER"]);
lstSTATUS.SelectedValue = CommonTypeConvert.ToString(rdr["STATUS"]);
}
}
}
else
{
var oQuery = new InlineQueryDBManager();
string innerSql = ApplicationSQL.SQL["Manufacturers_EditView_113"].ToString();
oQuery.CommandText = innerSql;
txtLIST_ORDER.Text = (CommonTypeConvert.ToInteger(oQuery.ExecuteScalar()) + 1).ToString();
}
}
}
public LineItem GetItemDetailsByNumber(Guid gCURRENCY_ID, string sMFT_PART_NUM)
{
var item = new LineItem();
{
if (Security.USER_ID == Guid.Empty)
{
throw (new Exception("Authentication required"));
}
var oQuery = new InlineQueryDBManager();
oQuery.CommandText = ApplicationSQL.SQL["ProductCatalog_AutoComplete_63"].ToString();
CRMSecurity.Filter(oQuery, "ProductTemplates", "list");
TypeConvert.AppendParameter(oQuery, sMFT_PART_NUM, CommonTypeConvert.SqlFilterMode.StartsWith,
"MFT_PART_NUM");
oQuery.CommandText += " order by MFT_PART_NUM" + ControlChars.CrLf;
using (SqlDataReader rdr = oQuery.ExecuteReader(CommandBehavior.SingleRow))
{
if (rdr.Read())
{
item.ID = CommonTypeConvert.ToGuid(rdr["ID"]);
item.NAME = CommonTypeConvert.ToString(rdr["NAME"]);
item.MFT_PART_NUM = CommonTypeConvert.ToString(rdr["MFT_PART_NUM"]);
item.VENDOR_PART_NUM = CommonTypeConvert.ToString(rdr["VENDOR_PART_NUM"]);
item.TAX_CLASS = CommonTypeConvert.ToString(rdr["TAX_CLASS"]);
item.COST_PRICE = CommonTypeConvert.ToDecimal(rdr["COST_PRICE"]);
item.COST_USDOLLAR = CommonTypeConvert.ToDecimal(rdr["COST_USDOLLAR"]);
item.LIST_PRICE = CommonTypeConvert.ToDecimal(rdr["LIST_PRICE"]);
item.LIST_USDOLLAR = CommonTypeConvert.ToDecimal(rdr["LIST_USDOLLAR"]);
item.UNIT_PRICE = CommonTypeConvert.ToDecimal(rdr["UNIT_PRICE"]);
item.UNIT_USDOLLAR = CommonTypeConvert.ToDecimal(rdr["UNIT_USDOLLAR"]);
if (gCURRENCY_ID != CommonTypeConvert.ToGuid(rdr["CURRENCY_ID"]))
{
Currency C10n = Currency.CreateCurrency(gCURRENCY_ID);
item.COST_PRICE = Currency.GetCurrency.ToCurrency(item.COST_USDOLLAR);
item.LIST_PRICE = Currency.GetCurrency.ToCurrency(item.LIST_USDOLLAR);
item.UNIT_PRICE = Currency.GetCurrency.ToCurrency(item.UNIT_USDOLLAR);
}
}
}
if (CommonTypeConvert.IsEmptyGuid(item.ID))
{
throw (new Exception("Item not found"));
}
}
return(item);
}
protected void Page_Load(object sender, EventArgs e)
{
SetPageTitle(Translation.GetTranslation.Term("Manufacturers.LBL_NAME"));
Visible = Security.IS_ADMIN;
Visible = Security.ADMIN_TYPE == 0 ? true : false;
if (!Visible)
return;
reqNAME.DataBind();
reqLIST_ORDER.DataBind();
gID = CommonTypeConvert.ToGuid(Request["ID"]);
if (!IsPostBack)
{
ctlDynamicButtons.AppendButtons(m_sMODULE + ".EditView", Guid.Empty, null);
lstSTATUS.DataSource = CRMCache.List("manufacturer_status_dom");
lstSTATUS.DataBind();
if (!CommonTypeConvert.IsEmptyGuid(gID))
{
var oQuery = new InlineQueryDBManager();
string innerSql = ApplicationSQL.SQL["Administration_Manufacturers_EditView"].ToString();
oQuery.CommandText = innerSql;
oQuery.Add("@ID", SqlDbType.UniqueIdentifier, gID);
using (SqlDataReader rdr = oQuery.ExecuteReader(CommandBehavior.SingleRow))
{
if (rdr.Read())
{
txtNAME.Text = CommonTypeConvert.ToString(rdr["NAME"]);
ctlListHeader.Title = Translation.GetTranslation.Term("Manufacturers.LBL_NAME") + " " +
txtNAME.Text;
txtLIST_ORDER.Text = CommonTypeConvert.ToString(rdr["LIST_ORDER"]);
lstSTATUS.SelectedValue = CommonTypeConvert.ToString(rdr["STATUS"]);
}
}
}
else
{
var oQuery = new InlineQueryDBManager();
string innerSql = ApplicationSQL.SQL["Manufacturers_EditView_113"].ToString();
oQuery.CommandText = innerSql;
txtLIST_ORDER.Text = (CommonTypeConvert.ToInteger(oQuery.ExecuteScalar()) + 1).ToString();
}
}
}
private void UpdateAccount(Guid gACCOUNT_ID, bool bUpdateBilling, bool bUpdateShipping)
{
string innerSql = ApplicationSQL.SQL["Invoices_EditView_223"].ToString();
var oQuery = new InlineQueryDBManager();
oQuery.CommandText = innerSql;
oQuery.Add("@ID", SqlDbType.UniqueIdentifier, gACCOUNT_ID);
using (SqlDataReader rdr = oQuery.ExecuteReader(CommandBehavior.SingleRow))
{
if (rdr.Read())
{
if (bUpdateBilling)
{
new DynamicControl(this, "BILLING_ACCOUNT_ID").ID = CommonTypeConvert.ToGuid(rdr["ID"]);
new DynamicControl(this, "BILLING_ACCOUNT_NAME").Text = CommonTypeConvert.ToString(rdr["NAME"]);
new DynamicControl(this, "BILLING_ADDRESS_STREET").Text =
CommonTypeConvert.ToString(rdr["BILLING_ADDRESS_STREET"]);
new DynamicControl(this, "BILLING_ADDRESS_CITY").Text =
CommonTypeConvert.ToString(rdr["BILLING_ADDRESS_CITY"]);
new DynamicControl(this, "BILLING_ADDRESS_STATE").Text =
CommonTypeConvert.ToString(rdr["BILLING_ADDRESS_STATE"]);
new DynamicControl(this, "BILLING_ADDRESS_POSTALCODE").Text =
CommonTypeConvert.ToString(rdr["BILLING_ADDRESS_POSTALCODE"]);
new DynamicControl(this, "BILLING_ADDRESS_COUNTRY").Text =
CommonTypeConvert.ToString(rdr["BILLING_ADDRESS_COUNTRY"]);
}
if (bUpdateShipping)
{
new DynamicControl(this, "SHIPPING_ACCOUNT_ID").ID = CommonTypeConvert.ToGuid(rdr["ID"]);
new DynamicControl(this, "SHIPPING_ACCOUNT_NAME").Text = CommonTypeConvert.ToString(rdr["NAME"]);
new DynamicControl(this, "SHIPPING_ADDRESS_STREET").Text =
CommonTypeConvert.ToString(rdr["SHIPPING_ADDRESS_STREET"]);
new DynamicControl(this, "SHIPPING_ADDRESS_CITY").Text =
CommonTypeConvert.ToString(rdr["SHIPPING_ADDRESS_CITY"]);
new DynamicControl(this, "SHIPPING_ADDRESS_STATE").Text =
CommonTypeConvert.ToString(rdr["SHIPPING_ADDRESS_STATE"]);
new DynamicControl(this, "SHIPPING_ADDRESS_POSTALCODE").Text =
CommonTypeConvert.ToString(rdr["SHIPPING_ADDRESS_POSTALCODE"]);
new DynamicControl(this, "SHIPPING_ADDRESS_COUNTRY").Text =
CommonTypeConvert.ToString(rdr["SHIPPING_ADDRESS_COUNTRY"]);
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
SetPageTitle(Translation.GetTranslation.Term("ProductTypes.LBL_NAME"));
if (!Visible)
{
return;
}
reqNAME.DataBind();
reqLIST_ORDER.DataBind();
gID = CommonTypeConvert.ToGuid(Request["ID"]);
if (!IsPostBack)
{
ctlDynamicButtons.AppendButtons(m_sMODULE + ".EditView", Guid.Empty, null);
if (!CommonTypeConvert.IsEmptyGuid(gID))
{
var oQuery = new InlineQueryDBManager();
string innerSql = ApplicationSQL.SQL["Administration_ProductTypes_EditView"].ToString();
oQuery.CommandText = innerSql;
oQuery.Add("@ID", SqlDbType.UniqueIdentifier, gID);
using (SqlDataReader rdr = oQuery.ExecuteReader(CommandBehavior.SingleRow))
{
if (rdr.Read())
{
txtNAME.Text = CommonTypeConvert.ToString(rdr["NAME"]);
ctlListHeader.Title = Translation.GetTranslation.Term("ProductTypes.LBL_NAME") + " " +
txtNAME.Text;
txtDESCRIPTION.Text = CommonTypeConvert.ToString(rdr["DESCRIPTION"]);
txtLIST_ORDER.Text = CommonTypeConvert.ToString(rdr["LIST_ORDER"]);
}
}
}
else
{
var oQuery = new InlineQueryDBManager();
string innerSql = ApplicationSQL.SQL["ProductTypes_EditView_104"].ToString();
oQuery.CommandText = innerSql;
txtLIST_ORDER.Text = (CommonTypeConvert.ToInteger(oQuery.ExecuteScalar()) + 1).ToString();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
SetPageTitle(Translation.GetTranslation.Term("ProductTypes.LBL_NAME"));
if (!Visible)
return;
reqNAME.DataBind();
reqLIST_ORDER.DataBind();
gID = CommonTypeConvert.ToGuid(Request["ID"]);
if (!IsPostBack)
{
ctlDynamicButtons.AppendButtons(m_sMODULE + ".EditView", Guid.Empty, null);
if (!CommonTypeConvert.IsEmptyGuid(gID))
{
var oQuery = new InlineQueryDBManager();
string innerSql = ApplicationSQL.SQL["Administration_ProductTypes_EditView"].ToString();
oQuery.CommandText = innerSql;
oQuery.Add("@ID", SqlDbType.UniqueIdentifier, gID);
using (SqlDataReader rdr = oQuery.ExecuteReader(CommandBehavior.SingleRow))
{
if (rdr.Read())
{
txtNAME.Text = CommonTypeConvert.ToString(rdr["NAME"]);
ctlListHeader.Title = Translation.GetTranslation.Term("ProductTypes.LBL_NAME") + " " +
txtNAME.Text;
txtDESCRIPTION.Text = CommonTypeConvert.ToString(rdr["DESCRIPTION"]);
txtLIST_ORDER.Text = CommonTypeConvert.ToString(rdr["LIST_ORDER"]);
}
}
}
else
{
var oQuery = new InlineQueryDBManager();
string innerSql = ApplicationSQL.SQL["ProductTypes_EditView_104"].ToString();
oQuery.CommandText = innerSql;
txtLIST_ORDER.Text = (CommonTypeConvert.ToInteger(oQuery.ExecuteScalar()) + 1).ToString();
}
}
}
public Invoice GetInvoiceByName(Guid gCURRENCY_ID, string sNAME)
{
var item = new Invoice();
{
if (Security.USER_ID == Guid.Empty)
{
throw (new Exception("Authentication required"));
}
var oQuery = new InlineQueryDBManager();
string innerSql = ApplicationSQL.SQL["Invoices_AutoComplete_50"].ToString();
oQuery.CommandText = innerSql;
CRMSecurity.Filter(oQuery, "Invoices", "list");
TypeConvert.AppendParameter(oQuery, sNAME, CommonTypeConvert.SqlFilterMode.StartsWith, "NAME");
using (SqlDataReader rdr = oQuery.ExecuteReader(CommandBehavior.SingleRow))
{
if (rdr.Read())
{
item.ID = CommonTypeConvert.ToGuid(rdr["ID"]);
item.NAME = CommonTypeConvert.ToString(rdr["NAME"]);
item.AMOUNT_DUE = CommonTypeConvert.ToDecimal(rdr["AMOUNT_DUE"]);
item.AMOUNT_DUE_USDOLLAR = CommonTypeConvert.ToDecimal(rdr["AMOUNT_DUE_USDOLLAR"]);
if (gCURRENCY_ID != CommonTypeConvert.ToGuid(rdr["CURRENCY_ID"]))
{
Currency C10n = Currency.CreateCurrency(gCURRENCY_ID);
item.AMOUNT_DUE = Currency.GetCurrency.ToCurrency(item.AMOUNT_DUE_USDOLLAR);
}
}
}
if (CommonTypeConvert.IsEmptyGuid(item.ID))
{
throw (new Exception("Item not found"));
}
}
return(item);
}
protected void Page_Load(object sender, EventArgs e)
{
SetPageTitle(Translation.GetTranslation.Term(".moduleList." + m_sMODULE));
Visible = (Security.GetUserAccess(m_sMODULE, "edit") >= 0);
if (!Visible)
{
return;
}
gID = CommonTypeConvert.ToGuid(Request["ID"]);
if (CommonTypeConvert.IsEmptyGuid(gID))
{
gID = CommonTypeConvert.ToGuid(ViewState["ID"]);
}
if (!IsPostBack)
{
Guid gDuplicateID = CommonTypeConvert.ToGuid(Request["DuplicateID"]);
if (!CommonTypeConvert.IsEmptyGuid(gID) || !CommonTypeConvert.IsEmptyGuid(gDuplicateID))
{
var oQuery = new InlineQueryDBManager();
string innerSql = ApplicationSQL.SQL["Payments_EditView_259"].ToString();
oQuery.CommandText = innerSql;
CRMSecurity.Filter(oQuery, m_sMODULE, "edit");
if (!CommonTypeConvert.IsEmptyGuid(gDuplicateID))
{
TypeConvert.AppendParameter(oQuery, gDuplicateID, "ID", false);
gID = Guid.Empty;
}
else
{
TypeConvert.AppendParameter(oQuery, gID, "ID", false);
}
using (SqlDataReader rdr = oQuery.ExecuteReader(CommandBehavior.SingleRow))
{
if (rdr.Read())
{
ctlModuleHeader.Title = CommonTypeConvert.ToString(rdr["PAYMENT_NUM"]);
SetPageTitle(Translation.GetTranslation.Term(".moduleList." + m_sMODULE) + " - " +
ctlModuleHeader.Title);
Utils.UpdateTracker(Page, m_sMODULE, gID, ctlModuleHeader.Title);
ViewState["ctlModuleHeader.Title"] = ctlModuleHeader.Title;
AppendEditViewFields(m_sMODULE + ".EditView", tblMain, rdr);
ctlDynamicButtons.AppendButtons(m_sMODULE + ".EditView",
CommonTypeConvert.ToGuid(rdr["ASSIGNED_USER_ID"]), rdr);
var CURRENCY_ID = tblMain.FindControl("CURRENCY_ID") as DropDownList;
if (CURRENCY_ID != null)
{
CURRENCY_ID.AutoPostBack = true;
CURRENCY_ID.SelectedIndexChanged += CURRENCY_ID_Changed;
}
var PAYMENT_TYPE = tblMain.FindControl("PAYMENT_TYPE") as DropDownList;
if (PAYMENT_TYPE != null)
{
PAYMENT_TYPE.AutoPostBack = true;
PAYMENT_TYPE.SelectedIndexChanged += PAYMENT_TYPE_Changed;
PAYMENT_TYPE_Changed(null, null);
}
Guid gACCOUNT_ID = CommonTypeConvert.ToGuid(rdr["ACCOUNT_ID"]);
ctlAllocationsView.LoadLineItems(gID, gACCOUNT_ID, gDuplicateID, oQuery, rdr);
}
else
{
Guid gPARENT_ID = CommonTypeConvert.ToGuid(Request["PARENT_ID"]);
ctlAllocationsView.LoadLineItems(gID, gPARENT_ID, gDuplicateID, oQuery, null);
ctlDynamicButtons.AppendButtons(m_sMODULE + ".EditView", Guid.Empty, null);
ctlDynamicButtons.DisableAll();
ctlDynamicButtons.ErrorText = Translation.GetTranslation.Term("ACL.LBL_NO_ACCESS");
}
}
}
else
{
AppendEditViewFields(m_sMODULE + ".EditView", tblMain, null);
ctlDynamicButtons.AppendButtons(m_sMODULE + ".EditView", Guid.Empty, null);
var CURRENCY_ID = tblMain.FindControl("CURRENCY_ID") as DropDownList;
if (CURRENCY_ID != null)
{
CURRENCY_ID.AutoPostBack = true;
CURRENCY_ID.SelectedIndexChanged += CURRENCY_ID_Changed;
}
Guid gACCOUNT_ID = Guid.Empty;
Guid gPARENT_ID = CommonTypeConvert.ToGuid(Request["PARENT_ID"]);
new DynamicControl(this, "PAYMENT_DATE").DateValue = DateTime.Today;
Guid gINVOICE_ID = gPARENT_ID;
if (!CommonTypeConvert.IsEmptyGuid(gPARENT_ID))
{
string sMODULE = String.Empty;
string sPARENT_TYPE = String.Empty;
string sPARENT_NAME = String.Empty;
CommonProcedure.ParentGet(ref gPARENT_ID, ref sMODULE, ref sPARENT_TYPE, ref sPARENT_NAME);
if (!CommonTypeConvert.IsEmptyGuid(gPARENT_ID) && sMODULE == "Accounts")
{
gACCOUNT_ID = gPARENT_ID;
new DynamicControl(this, "ACCOUNT_ID").ID = gPARENT_ID;
new DynamicControl(this, "ACCOUNT_NAME").Text = sPARENT_NAME;
var oQuery = new InlineQueryDBManager();
ctlAllocationsView.LoadLineItems(gID, gACCOUNT_ID, gDuplicateID, oQuery, null);
}
else if (!CommonTypeConvert.IsEmptyGuid(gINVOICE_ID))
{
var oQuery = new InlineQueryDBManager();
string innerSql = ApplicationSQL.SQL["Payments_EditView"].ToString();
oQuery.CommandText = innerSql;
CRMSecurity.Filter(oQuery, "Invoices", "edit");
TypeConvert.AppendParameter(oQuery, gINVOICE_ID, "ID", false);
using (SqlDataReader rdr = oQuery.ExecuteReader(CommandBehavior.SingleRow))
{
if (rdr.Read())
{
gACCOUNT_ID = CommonTypeConvert.ToGuid(rdr["BILLING_ACCOUNT_ID"]);
new DynamicControl(this, "ACCOUNT_ID").ID =
CommonTypeConvert.ToGuid(rdr["BILLING_ACCOUNT_ID"]);
new DynamicControl(this, "ACCOUNT_NAME").Text =
CommonTypeConvert.ToString(rdr["BILLING_ACCOUNT_NAME"]);
ctlAllocationsView.LoadLineItems(gID, gACCOUNT_ID, gDuplicateID, oQuery, null);
new DynamicControl(this, "AMOUNT").Text =
Currency.GetCurrency.ToCurrency(
CommonTypeConvert.ToDecimal(rdr["AMOUNT_DUE_USDOLLAR"])).ToString("0.00");
}
}
}
}
var PAYMENT_TYPE = tblMain.FindControl("PAYMENT_TYPE") as DropDownList;
if (PAYMENT_TYPE != null)
{
PAYMENT_TYPE.AutoPostBack = true;
PAYMENT_TYPE.SelectedIndexChanged += PAYMENT_TYPE_Changed;
PAYMENT_TYPE_Changed(null, null);
}
}
}
else
{
ctlModuleHeader.Title = CommonTypeConvert.ToString(ViewState["ctlModuleHeader.Title"]);
SetPageTitle(Translation.GetTranslation.Term(".moduleList." + m_sMODULE) + " - " + ctlModuleHeader.Title);
}
}
protected void PAYMENT_TYPE_Changed(object sender, EventArgs e)
{
var PAYMENT_TYPE = tblMain.FindControl("PAYMENT_TYPE") as DropDownList;
if (PAYMENT_TYPE != null)
{
bool bCreditCard = PAYMENT_TYPE.SelectedValue == "Credit Card";
ctlDynamicButtons.ShowButton("Charge", bCreditCard);
new DynamicControl(this, "CREDIT_CARD_ID_LABEL").Visible = bCreditCard;
new DynamicControl(this, "CREDIT_CARD_NAME").Visible = bCreditCard;
new DynamicControl(this, "CREDIT_CARD_ID_btnChange").Visible = bCreditCard;
new DynamicControl(this, "CREDIT_CARD_ID_btnClear").Visible = bCreditCard;
if (bCreditCard && CommonTypeConvert.IsEmptyGuid(new DynamicControl(this, "CREDIT_CARD_ID").ID))
{
var oQuery = new InlineQueryDBManager();
string innerSql = ApplicationSQL.SQL["Payments_EditView_214"].ToString();
oQuery.CommandText = innerSql;
Guid gACCOUNT_ID = new DynamicControl(this, "ACCOUNT_ID").ID;
TypeConvert.AppendParameter(oQuery, gACCOUNT_ID, "ACCOUNT_ID", false);
using (SqlDataReader rdr = oQuery.ExecuteReader(CommandBehavior.SingleRow))
{
if (rdr.Read())
{
new DynamicControl(this, "CREDIT_CARD_ID").ID = CommonTypeConvert.ToGuid(rdr["ID"]);
new DynamicControl(this, "CREDIT_CARD_NAME").Text = CommonTypeConvert.ToString(rdr["NAME"]);
}
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
SetPageTitle(Translation.GetTranslation.Term(".moduleList." + m_sMODULE));
Visible = (Security.GetUserAccess(m_sMODULE, "edit") >= 0);
if (!Visible)
return;
gID = CommonTypeConvert.ToGuid(Request["ID"]);
if (CommonTypeConvert.IsEmptyGuid(gID))
gID = CommonTypeConvert.ToGuid(ViewState["ID"]);
if (!IsPostBack)
{
Guid gDuplicateID = CommonTypeConvert.ToGuid(Request["DuplicateID"]);
if (!CommonTypeConvert.IsEmptyGuid(gID) || !CommonTypeConvert.IsEmptyGuid(gDuplicateID))
{
var oQuery = new InlineQueryDBManager();
string innerSql = ApplicationSQL.SQL["Payments_EditView_259"].ToString();
oQuery.CommandText = innerSql;
CRMSecurity.Filter(oQuery, m_sMODULE, "edit");
if (!CommonTypeConvert.IsEmptyGuid(gDuplicateID))
{
TypeConvert.AppendParameter(oQuery, gDuplicateID, "ID", false);
gID = Guid.Empty;
}
else
{
TypeConvert.AppendParameter(oQuery, gID, "ID", false);
}
using (SqlDataReader rdr = oQuery.ExecuteReader(CommandBehavior.SingleRow))
{
if (rdr.Read())
{
ctlModuleHeader.Title = CommonTypeConvert.ToString(rdr["PAYMENT_NUM"]);
SetPageTitle(Translation.GetTranslation.Term(".moduleList." + m_sMODULE) + " - " +
ctlModuleHeader.Title);
Utils.UpdateTracker(Page, m_sMODULE, gID, ctlModuleHeader.Title);
ViewState["ctlModuleHeader.Title"] = ctlModuleHeader.Title;
AppendEditViewFields(m_sMODULE + ".EditView", tblMain, rdr);
ctlDynamicButtons.AppendButtons(m_sMODULE + ".EditView",
CommonTypeConvert.ToGuid(rdr["ASSIGNED_USER_ID"]), rdr);
var CURRENCY_ID = tblMain.FindControl("CURRENCY_ID") as DropDownList;
if (CURRENCY_ID != null)
{
CURRENCY_ID.AutoPostBack = true;
CURRENCY_ID.SelectedIndexChanged += CURRENCY_ID_Changed;
}
var PAYMENT_TYPE = tblMain.FindControl("PAYMENT_TYPE") as DropDownList;
if (PAYMENT_TYPE != null)
{
PAYMENT_TYPE.AutoPostBack = true;
PAYMENT_TYPE.SelectedIndexChanged += PAYMENT_TYPE_Changed;
PAYMENT_TYPE_Changed(null, null);
}
Guid gACCOUNT_ID = CommonTypeConvert.ToGuid(rdr["ACCOUNT_ID"]);
ctlAllocationsView.LoadLineItems(gID, gACCOUNT_ID, gDuplicateID, oQuery, rdr);
}
else
{
Guid gPARENT_ID = CommonTypeConvert.ToGuid(Request["PARENT_ID"]);
ctlAllocationsView.LoadLineItems(gID, gPARENT_ID, gDuplicateID, oQuery, null);
ctlDynamicButtons.AppendButtons(m_sMODULE + ".EditView", Guid.Empty, null);
ctlDynamicButtons.DisableAll();
ctlDynamicButtons.ErrorText = Translation.GetTranslation.Term("ACL.LBL_NO_ACCESS");
}
}
}
else
{
AppendEditViewFields(m_sMODULE + ".EditView", tblMain, null);
ctlDynamicButtons.AppendButtons(m_sMODULE + ".EditView", Guid.Empty, null);
var CURRENCY_ID = tblMain.FindControl("CURRENCY_ID") as DropDownList;
if (CURRENCY_ID != null)
{
CURRENCY_ID.AutoPostBack = true;
CURRENCY_ID.SelectedIndexChanged += CURRENCY_ID_Changed;
}
Guid gACCOUNT_ID = Guid.Empty;
Guid gPARENT_ID = CommonTypeConvert.ToGuid(Request["PARENT_ID"]);
new DynamicControl(this, "PAYMENT_DATE").DateValue = DateTime.Today;
Guid gINVOICE_ID = gPARENT_ID;
if (!CommonTypeConvert.IsEmptyGuid(gPARENT_ID))
{
string sMODULE = String.Empty;
string sPARENT_TYPE = String.Empty;
string sPARENT_NAME = String.Empty;
CommonProcedure.ParentGet(ref gPARENT_ID, ref sMODULE, ref sPARENT_TYPE, ref sPARENT_NAME);
if (!CommonTypeConvert.IsEmptyGuid(gPARENT_ID) && sMODULE == "Accounts")
{
gACCOUNT_ID = gPARENT_ID;
new DynamicControl(this, "ACCOUNT_ID").ID = gPARENT_ID;
new DynamicControl(this, "ACCOUNT_NAME").Text = sPARENT_NAME;
var oQuery = new InlineQueryDBManager();
ctlAllocationsView.LoadLineItems(gID, gACCOUNT_ID, gDuplicateID, oQuery, null);
}
else if (!CommonTypeConvert.IsEmptyGuid(gINVOICE_ID))
{
var oQuery = new InlineQueryDBManager();
string innerSql = ApplicationSQL.SQL["Payments_EditView"].ToString();
oQuery.CommandText = innerSql;
CRMSecurity.Filter(oQuery, "Invoices", "edit");
TypeConvert.AppendParameter(oQuery, gINVOICE_ID, "ID", false);
using (SqlDataReader rdr = oQuery.ExecuteReader(CommandBehavior.SingleRow))
{
if (rdr.Read())
{
gACCOUNT_ID = CommonTypeConvert.ToGuid(rdr["BILLING_ACCOUNT_ID"]);
new DynamicControl(this, "ACCOUNT_ID").ID =
CommonTypeConvert.ToGuid(rdr["BILLING_ACCOUNT_ID"]);
new DynamicControl(this, "ACCOUNT_NAME").Text =
CommonTypeConvert.ToString(rdr["BILLING_ACCOUNT_NAME"]);
ctlAllocationsView.LoadLineItems(gID, gACCOUNT_ID, gDuplicateID, oQuery, null);
new DynamicControl(this, "AMOUNT").Text =
Currency.GetCurrency.ToCurrency(
CommonTypeConvert.ToDecimal(rdr["AMOUNT_DUE_USDOLLAR"])).ToString("0.00");
}
}
}
}
var PAYMENT_TYPE = tblMain.FindControl("PAYMENT_TYPE") as DropDownList;
if (PAYMENT_TYPE != null)
{
PAYMENT_TYPE.AutoPostBack = true;
PAYMENT_TYPE.SelectedIndexChanged += PAYMENT_TYPE_Changed;
PAYMENT_TYPE_Changed(null, null);
}
}
}
else
{
ctlModuleHeader.Title = CommonTypeConvert.ToString(ViewState["ctlModuleHeader.Title"]);
SetPageTitle(Translation.GetTranslation.Term(".moduleList." + m_sMODULE) + " - " + ctlModuleHeader.Title);
}
}
public void LoadLineItems(Guid gID, Guid gACCOUNT_ID, Guid gDuplicateID, InlineQueryDBManager oQuery,
SqlDataReader rdr)
{
this.gACCOUNT_ID = gACCOUNT_ID;
if (!IsPostBack)
{
GetCurrencyControl();
CURRENCY_ID.SelectedValue = Currency.GetCurrency.ID.ToString();
EXCHANGE_RATE.Value = Currency.GetCurrency.CONVERSION_RATE.ToString();
foreach (DataControlField col in grdMain.Columns)
{
if (!CommonTypeConvert.IsEmptyString(col.HeaderText))
{
col.HeaderText = Translation.GetTranslation.Term(col.HeaderText);
}
var cf = col as CommandField;
if (cf != null)
{
cf.EditText = Translation.GetTranslation.Term(cf.EditText);
cf.DeleteText = Translation.GetTranslation.Term(cf.DeleteText);
cf.UpdateText = Translation.GetTranslation.Term(cf.UpdateText);
cf.CancelText = Translation.GetTranslation.Term(cf.CancelText);
}
}
if ((!CommonTypeConvert.IsEmptyGuid(gID) || !CommonTypeConvert.IsEmptyGuid(gDuplicateID)) &&
(oQuery != null) && (rdr != null))
{
CURRENCY_ID.SelectedValue = CommonTypeConvert.ToString(rdr["CURRENCY_ID"]);
EXCHANGE_RATE.Value = Currency.GetCurrency.CONVERSION_RATE.ToString();
float fEXCHANGE_RATE = CommonTypeConvert.ToFloat(rdr["EXCHANGE_RATE"]);
if (fEXCHANGE_RATE == 0.0f)
fEXCHANGE_RATE = 1.0f;
EXCHANGE_RATE.Value = fEXCHANGE_RATE.ToString();
if (CURRENCY_ID.Items.Count > 0)
{
Guid gCURRENCY_ID = CommonTypeConvert.ToGuid(CURRENCY_ID.SelectedValue);
SetCurrency(gCURRENCY_ID, fEXCHANGE_RATE);
EXCHANGE_RATE.Value = Currency.GetCurrency.CONVERSION_RATE.ToString();
}
ALLOCATED.Text =
Currency.GetCurrency.ToCurrency(CommonTypeConvert.ToDecimal(rdr["TOTAL_ALLOCATED_USDOLLAR"])).
ToString("c");
ALLOCATED_USDOLLAR.Value =
CommonTypeConvert.ToDecimal(rdr["TOTAL_ALLOCATED_USDOLLAR"]).ToString("0.00");
rdr.Close();
string innerSql = ApplicationSQL.SQL["Payments_AllocationsView_233"].ToString();
oQuery.CommandText = innerSql;
TypeConvert.AppendParameter(oQuery, gID, "PAYMENT_ID", false);
oQuery.CommandText += " order by DATE_MODIFIED asc" + ControlChars.CrLf;
DataTable dtLineItems = oQuery.GetTable();
if (!CommonTypeConvert.IsEmptyGuid(gDuplicateID))
{
foreach (DataRow row in dtLineItems.Rows)
{
row["ID"] = Guid.NewGuid();
}
}
DataRow rowNew = dtLineItems.NewRow();
dtLineItems.Rows.Add(rowNew);
ViewState["LineItems"] = dtLineItems;
grdMain.DataSource = dtLineItems;
grdMain.EditIndex = dtLineItems.Rows.Count - 1;
grdMain.DataBind();
}
else
{
dtLineItems = new DataTable();
var colID = new DataColumn("ID", Type.GetType("System.Guid"));
var colINVOICE_NAME = new DataColumn("INVOICE_NAME", Type.GetType("System.String"));
var colINVOICE_ID = new DataColumn("INVOICE_ID", Type.GetType("System.Guid"));
var colAMOUNT_DUE = new DataColumn("AMOUNT_DUE", Type.GetType("System.Decimal"));
var colAMOUNT_DUE_USDOLLAR = new DataColumn("AMOUNT_DUE_USDOLLAR", Type.GetType("System.Decimal"));
var colAMOUNT = new DataColumn("AMOUNT", Type.GetType("System.Decimal"));
var colAMOUNT_USDOLLAR = new DataColumn("AMOUNT_USDOLLAR", Type.GetType("System.Decimal"));
dtLineItems.Columns.Add(colID);
dtLineItems.Columns.Add(colINVOICE_NAME);
dtLineItems.Columns.Add(colINVOICE_ID);
dtLineItems.Columns.Add(colAMOUNT_DUE);
dtLineItems.Columns.Add(colAMOUNT_DUE_USDOLLAR);
dtLineItems.Columns.Add(colAMOUNT);
dtLineItems.Columns.Add(colAMOUNT_USDOLLAR);
DataRow rowNew = null;
string innerSql = ApplicationSQL.SQL["Payments_AllocationsView"].ToString();
oQuery.CommandText = innerSql;
Guid gPARENT_ID = CommonTypeConvert.ToGuid(Request["PARENT_ID"]);
TypeConvert.AppendParameter(oQuery, gPARENT_ID, "ID", false);
using (SqlDataReader rdrInvoice = oQuery.ExecuteReader(CommandBehavior.SingleRow))
{
if (rdrInvoice.Read())
{
rowNew = dtLineItems.NewRow();
rowNew["INVOICE_NAME"] = CommonTypeConvert.ToString(rdrInvoice["NAME"]);
rowNew["INVOICE_ID"] = CommonTypeConvert.ToGuid(rdrInvoice["ID"]);
rowNew["AMOUNT_DUE"] = CommonTypeConvert.ToDecimal(rdrInvoice["AMOUNT_DUE"]);
rowNew["AMOUNT_DUE_USDOLLAR"] =
CommonTypeConvert.ToDecimal(rdrInvoice["AMOUNT_DUE_USDOLLAR"]);
rowNew["AMOUNT"] = CommonTypeConvert.ToDecimal(rdrInvoice["AMOUNT_DUE"]);
rowNew["AMOUNT_USDOLLAR"] = CommonTypeConvert.ToDecimal(rdrInvoice["AMOUNT_DUE_USDOLLAR"]);
if (rdrInvoice["AMOUNT_DUE"] == DBNull.Value)
{
rowNew["AMOUNT_DUE"] = CommonTypeConvert.ToDecimal(rdrInvoice["TOTAL"]);
rowNew["AMOUNT_DUE_USDOLLAR"] = CommonTypeConvert.ToDecimal(rdrInvoice["TOTAL_USDOLLAR"]);
rowNew["AMOUNT"] = CommonTypeConvert.ToDecimal(rdrInvoice["TOTAL"]);
rowNew["AMOUNT_USDOLLAR"] = CommonTypeConvert.ToDecimal(rdrInvoice["TOTAL_USDOLLAR"]);
}
dtLineItems.Rows.Add(rowNew);
}
}
rowNew = dtLineItems.NewRow();
dtLineItems.Rows.Add(rowNew);
ViewState["LineItems"] = dtLineItems;
grdMain.DataSource = dtLineItems;
grdMain.EditIndex = dtLineItems.Rows.Count - 1;
grdMain.DataBind();
UpdateTotals();
}
}
}
private void UpdateContact(Guid gCONTACT_ID, bool bUpdateBilling, bool bUpdateShipping)
{
string innerSql = ApplicationSQL.SQL["Invoices_EditView_267"].ToString();
var oQuery = new InlineQueryDBManager();
oQuery.CommandText = innerSql;
oQuery.Add("@ID", SqlDbType.UniqueIdentifier, gCONTACT_ID);
using (SqlDataReader rdr = oQuery.ExecuteReader(CommandBehavior.SingleRow))
{
if (rdr.Read())
{
if (bUpdateBilling)
{
new DynamicControl(this, "BILLING_CONTACT_ID").ID = CommonTypeConvert.ToGuid(rdr["ID"]);
new DynamicControl(this, "BILLING_CONTACT_NAME").Text = CommonTypeConvert.ToString(rdr["NAME"]);
}
if (bUpdateShipping)
{
new DynamicControl(this, "SHIPPING_CONTACT_ID").ID = CommonTypeConvert.ToGuid(rdr["ID"]);
new DynamicControl(this, "SHIPPING_CONTACT_NAME").Text = CommonTypeConvert.ToString(rdr["NAME"]);
}
Guid gACCOUNT_ID = CommonTypeConvert.ToGuid(rdr["ACCOUNT_ID"]);
if (!CommonTypeConvert.IsEmptyGuid(gACCOUNT_ID))
{
UpdateAccount(gACCOUNT_ID, bUpdateBilling, bUpdateShipping);
}
}
}
}
private void UpdateAccount(Guid gACCOUNT_ID, bool bUpdateBilling, bool bUpdateShipping)
{
string innerSql = ApplicationSQL.SQL["Invoices_EditView_223"].ToString();
var oQuery = new InlineQueryDBManager();
oQuery.CommandText = innerSql;
oQuery.Add("@ID", SqlDbType.UniqueIdentifier, gACCOUNT_ID);
using (SqlDataReader rdr = oQuery.ExecuteReader(CommandBehavior.SingleRow))
{
if (rdr.Read())
{
if (bUpdateBilling)
{
new DynamicControl(this, "BILLING_ACCOUNT_ID").ID = CommonTypeConvert.ToGuid(rdr["ID"]);
new DynamicControl(this, "BILLING_ACCOUNT_NAME").Text = CommonTypeConvert.ToString(rdr["NAME"]);
new DynamicControl(this, "BILLING_ADDRESS_STREET").Text =
CommonTypeConvert.ToString(rdr["BILLING_ADDRESS_STREET"]);
new DynamicControl(this, "BILLING_ADDRESS_CITY").Text =
CommonTypeConvert.ToString(rdr["BILLING_ADDRESS_CITY"]);
new DynamicControl(this, "BILLING_ADDRESS_STATE").Text =
CommonTypeConvert.ToString(rdr["BILLING_ADDRESS_STATE"]);
new DynamicControl(this, "BILLING_ADDRESS_POSTALCODE").Text =
CommonTypeConvert.ToString(rdr["BILLING_ADDRESS_POSTALCODE"]);
new DynamicControl(this, "BILLING_ADDRESS_COUNTRY").Text =
CommonTypeConvert.ToString(rdr["BILLING_ADDRESS_COUNTRY"]);
}
if (bUpdateShipping)
{
new DynamicControl(this, "SHIPPING_ACCOUNT_ID").ID = CommonTypeConvert.ToGuid(rdr["ID"]);
new DynamicControl(this, "SHIPPING_ACCOUNT_NAME").Text = CommonTypeConvert.ToString(rdr["NAME"]);
new DynamicControl(this, "SHIPPING_ADDRESS_STREET").Text =
CommonTypeConvert.ToString(rdr["SHIPPING_ADDRESS_STREET"]);
new DynamicControl(this, "SHIPPING_ADDRESS_CITY").Text =
CommonTypeConvert.ToString(rdr["SHIPPING_ADDRESS_CITY"]);
new DynamicControl(this, "SHIPPING_ADDRESS_STATE").Text =
CommonTypeConvert.ToString(rdr["SHIPPING_ADDRESS_STATE"]);
new DynamicControl(this, "SHIPPING_ADDRESS_POSTALCODE").Text =
CommonTypeConvert.ToString(rdr["SHIPPING_ADDRESS_POSTALCODE"]);
new DynamicControl(this, "SHIPPING_ADDRESS_COUNTRY").Text =
CommonTypeConvert.ToString(rdr["SHIPPING_ADDRESS_COUNTRY"]);
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
SetPageTitle(Translation.GetTranslation.Term(".moduleList." + m_sMODULE));
Visible = (Security.GetUserAccess(m_sMODULE, "edit") >= 0);
if (!Visible)
return;
gID = CommonTypeConvert.ToGuid(Request["ID"]);
if (!IsPostBack)
{
string sLOAD_MODULE = "Invoices";
string sLOAD_MODULE_KEY = "INVOICE_ID";
Guid gQUOTE_ID = CommonTypeConvert.ToGuid(Request["QUOTE_ID"]);
Guid gORDER_ID = CommonTypeConvert.ToGuid(Request["ORDER_ID"]);
Guid gDuplicateID = CommonTypeConvert.ToGuid(Request["DuplicateID"]);
if (!CommonTypeConvert.IsEmptyGuid(gID) || !CommonTypeConvert.IsEmptyGuid(gDuplicateID) ||
!CommonTypeConvert.IsEmptyGuid(gQUOTE_ID) || !CommonTypeConvert.IsEmptyGuid(gORDER_ID))
{
string innerSql = ApplicationSQL.SQL["Invoices_EditView_323"].ToString();
var oQuery = new InlineQueryDBManager();
oQuery.CommandText = innerSql;
if (!CommonTypeConvert.IsEmptyGuid(gQUOTE_ID))
{
//Load the data from the QUOTES record.
sLOAD_MODULE = "Quotes";
sLOAD_MODULE_KEY = "QUOTE_ID";
innerSql = ApplicationSQL.SQL["Invoices_EditView_333"].ToString();
oQuery.CommandText = innerSql;
//Filter by the module we are loading.
CRMSecurity.Filter(oQuery, sLOAD_MODULE, "edit");
TypeConvert.AppendParameter(oQuery, gQUOTE_ID, "ID", false);
}
else if (!CommonTypeConvert.IsEmptyGuid(gORDER_ID))
{
// Load the data from the ORDERS record.
sLOAD_MODULE = "Orders";
sLOAD_MODULE_KEY = "ORDER_ID";
innerSql = ApplicationSQL.SQL["Invoices_EditView"].ToString();
oQuery.CommandText = innerSql;
//Filter by the module we are loading.
CRMSecurity.Filter(oQuery, sLOAD_MODULE, "edit");
TypeConvert.AppendParameter(oQuery, gORDER_ID, "ID", false);
}
else
{
//Use new CRMSecurity.Filter() function to apply Team and ACL security rules.
CRMSecurity.Filter(oQuery, m_sMODULE, "edit");
if (!CommonTypeConvert.IsEmptyGuid(gDuplicateID))
{
TypeConvert.AppendParameter(oQuery, gDuplicateID, "ID", false);
gID = Guid.Empty;
}
else
{
TypeConvert.AppendParameter(oQuery, gID, "ID", false);
}
}
using (SqlDataReader rdr = oQuery.ExecuteReader(CommandBehavior.SingleRow))
{
if (rdr.Read())
{
ctlModuleHeader.Title = CommonTypeConvert.ToString(rdr["NAME"]);
SetPageTitle(Translation.GetTranslation.Term(".moduleList." + m_sMODULE) + " - " +
ctlModuleHeader.Title);
Utils.UpdateTracker(Page, m_sMODULE, gID, ctlModuleHeader.Title);
ViewState["ctlModuleHeader.Title"] = ctlModuleHeader.Title;
ViewState["BILLING_ACCOUNT_ID"] = CommonTypeConvert.ToGuid(rdr["BILLING_ACCOUNT_ID"]);
ViewState["SHIPPING_ACCOUNT_ID"] = CommonTypeConvert.ToGuid(rdr["SHIPPING_ACCOUNT_ID"]);
new DynamicControl(this, "QUOTE_ID").ID = CommonTypeConvert.ToGuid(rdr["QUOTE_ID"]);
new DynamicControl(this, "ORDER_ID").ID = CommonTypeConvert.ToGuid(rdr["ORDER_ID"]);
AppendEditViewFields(m_sMODULE + ".EditView", tblMain, rdr);
AppendEditViewFields(m_sMODULE + ".EditAddress", tblAddress, rdr);
AppendEditViewFields(m_sMODULE + ".EditDescription", tblDescription, rdr);
//Dynamic buttons need to be recreated in order for events to fire.
ctlDynamicButtons.AppendButtons(m_sMODULE + ".EditView",
CommonTypeConvert.ToGuid(rdr["ASSIGNED_USER_ID"]), rdr);
if (!CommonTypeConvert.IsEmptyGuid(gQUOTE_ID))
{
new DynamicControl(this, "QUOTE_ID").ID = gQUOTE_ID;
new DynamicControl(this, "QUOTE_NAME").Text = CommonTypeConvert.ToString(rdr["NAME"]);
ctlEditLineItemsView.LoadLineItems(gQUOTE_ID, Guid.Empty, rdr, sLOAD_MODULE,
sLOAD_MODULE_KEY);
}
else if (!CommonTypeConvert.IsEmptyGuid(gORDER_ID))
{
new DynamicControl(this, "ORDER_ID").ID = gORDER_ID;
new DynamicControl(this, "ORDER_NAME").Text = CommonTypeConvert.ToString(rdr["NAME"]);
ctlEditLineItemsView.LoadLineItems(gORDER_ID, Guid.Empty, rdr, sLOAD_MODULE,
sLOAD_MODULE_KEY);
}
else
{
ctlEditLineItemsView.LoadLineItems(gID, gDuplicateID, rdr, sLOAD_MODULE,
sLOAD_MODULE_KEY);
}
}
else
{
ctlEditLineItemsView.LoadLineItems(gID, gDuplicateID, null, String.Empty, String.Empty);
//If item is not visible, then don't allow save
//Dynamic buttons need to be recreated in order for events to fire.
ctlDynamicButtons.AppendButtons(m_sMODULE + ".EditView", Guid.Empty, null);
ctlDynamicButtons.DisableAll();
ctlDynamicButtons.ErrorText = Translation.GetTranslation.Term("ACL.LBL_NO_ACCESS");
}
}
}
else
{
AppendEditViewFields(m_sMODULE + ".EditView", tblMain, null);
AppendEditViewFields(m_sMODULE + ".EditAddress", tblAddress, null);
AppendEditViewFields(m_sMODULE + ".EditDescription", tblDescription, null);
//Dynamic buttons need to be recreated in order for events to fire.
ctlDynamicButtons.AppendButtons(m_sMODULE + ".EditView", Guid.Empty, null);
//Prepopulate the Account.
Guid gPARENT_ID = CommonTypeConvert.ToGuid(Request["PARENT_ID"]);
if (!CommonTypeConvert.IsEmptyGuid(gPARENT_ID))
{
string sMODULE = String.Empty;
string sPARENT_TYPE = String.Empty;
string sPARENT_NAME = String.Empty;
CommonProcedure.ParentGet(ref gPARENT_ID, ref sMODULE, ref sPARENT_TYPE, ref sPARENT_NAME);
if (!CommonTypeConvert.IsEmptyGuid(gPARENT_ID) && sMODULE == "Accounts")
{
UpdateAccount(gPARENT_ID, true, true);
}
if (!CommonTypeConvert.IsEmptyGuid(gPARENT_ID) && sMODULE == "Contacts")
{
UpdateContact(gPARENT_ID, true, true);
}
else if (!CommonTypeConvert.IsEmptyGuid(gPARENT_ID) && sMODULE == "Opportunities")
{
new DynamicControl(this, "OPPORTUNITY_ID").ID = gPARENT_ID;
new DynamicControl(this, "OPPORTUNITY_NAME").Text = sPARENT_NAME;
}
}
ctlEditLineItemsView.LoadLineItems(gID, gDuplicateID, new InlineQueryDBManager(), null, String.Empty,
String.Empty);
}
}
else
{
// When validation fails, the header title does not retain its value. Update manually.
ctlModuleHeader.Title = CommonTypeConvert.ToString(ViewState["ctlModuleHeader.Title"]);
SetPageTitle(Translation.GetTranslation.Term(".moduleList." + m_sMODULE) + " - " + ctlModuleHeader.Title);
var ctlBILLING_ACCOUNT_ID = new DynamicControl(this, "BILLING_ACCOUNT_ID");
var ctlSHIPPING_ACCOUNT_ID = new DynamicControl(this, "SHIPPING_ACCOUNT_ID");
if (CommonTypeConvert.ToGuid(ViewState["BILLING_ACCOUNT_ID"]) != ctlBILLING_ACCOUNT_ID.ID)
{
UpdateAccount(ctlBILLING_ACCOUNT_ID.ID, true, true);
ViewState["BILLING_ACCOUNT_ID"] = ctlBILLING_ACCOUNT_ID.ID;
ViewState["SHIPPING_ACCOUNT_ID"] = ctlBILLING_ACCOUNT_ID.ID;
}
if (CommonTypeConvert.ToGuid(ViewState["SHIPPING_ACCOUNT_ID"]) != ctlSHIPPING_ACCOUNT_ID.ID)
{
UpdateAccount(ctlSHIPPING_ACCOUNT_ID.ID, false, true);
ViewState["SHIPPING_ACCOUNT_ID"] = ctlSHIPPING_ACCOUNT_ID.ID;
}
}
}
public void LoadLineItems(Guid gID, Guid gACCOUNT_ID, Guid gDuplicateID, InlineQueryDBManager oQuery,
SqlDataReader rdr)
{
this.gACCOUNT_ID = gACCOUNT_ID;
if (!IsPostBack)
{
GetCurrencyControl();
CURRENCY_ID.SelectedValue = Currency.GetCurrency.ID.ToString();
EXCHANGE_RATE.Value = Currency.GetCurrency.CONVERSION_RATE.ToString();
foreach (DataControlField col in grdMain.Columns)
{
if (!CommonTypeConvert.IsEmptyString(col.HeaderText))
{
col.HeaderText = Translation.GetTranslation.Term(col.HeaderText);
}
var cf = col as CommandField;
if (cf != null)
{
cf.EditText = Translation.GetTranslation.Term(cf.EditText);
cf.DeleteText = Translation.GetTranslation.Term(cf.DeleteText);
cf.UpdateText = Translation.GetTranslation.Term(cf.UpdateText);
cf.CancelText = Translation.GetTranslation.Term(cf.CancelText);
}
}
if ((!CommonTypeConvert.IsEmptyGuid(gID) || !CommonTypeConvert.IsEmptyGuid(gDuplicateID)) &&
(oQuery != null) && (rdr != null))
{
CURRENCY_ID.SelectedValue = CommonTypeConvert.ToString(rdr["CURRENCY_ID"]);
EXCHANGE_RATE.Value = Currency.GetCurrency.CONVERSION_RATE.ToString();
float fEXCHANGE_RATE = CommonTypeConvert.ToFloat(rdr["EXCHANGE_RATE"]);
if (fEXCHANGE_RATE == 0.0f)
{
fEXCHANGE_RATE = 1.0f;
}
EXCHANGE_RATE.Value = fEXCHANGE_RATE.ToString();
if (CURRENCY_ID.Items.Count > 0)
{
Guid gCURRENCY_ID = CommonTypeConvert.ToGuid(CURRENCY_ID.SelectedValue);
SetCurrency(gCURRENCY_ID, fEXCHANGE_RATE);
EXCHANGE_RATE.Value = Currency.GetCurrency.CONVERSION_RATE.ToString();
}
ALLOCATED.Text =
Currency.GetCurrency.ToCurrency(CommonTypeConvert.ToDecimal(rdr["TOTAL_ALLOCATED_USDOLLAR"])).
ToString("c");
ALLOCATED_USDOLLAR.Value =
CommonTypeConvert.ToDecimal(rdr["TOTAL_ALLOCATED_USDOLLAR"]).ToString("0.00");
rdr.Close();
string innerSql = ApplicationSQL.SQL["Payments_AllocationsView_233"].ToString();
oQuery.CommandText = innerSql;
TypeConvert.AppendParameter(oQuery, gID, "PAYMENT_ID", false);
oQuery.CommandText += " order by DATE_MODIFIED asc" + ControlChars.CrLf;
DataTable dtLineItems = oQuery.GetTable();
if (!CommonTypeConvert.IsEmptyGuid(gDuplicateID))
{
foreach (DataRow row in dtLineItems.Rows)
{
row["ID"] = Guid.NewGuid();
}
}
DataRow rowNew = dtLineItems.NewRow();
dtLineItems.Rows.Add(rowNew);
ViewState["LineItems"] = dtLineItems;
grdMain.DataSource = dtLineItems;
grdMain.EditIndex = dtLineItems.Rows.Count - 1;
grdMain.DataBind();
}
else
{
dtLineItems = new DataTable();
var colID = new DataColumn("ID", Type.GetType("System.Guid"));
var colINVOICE_NAME = new DataColumn("INVOICE_NAME", Type.GetType("System.String"));
var colINVOICE_ID = new DataColumn("INVOICE_ID", Type.GetType("System.Guid"));
var colAMOUNT_DUE = new DataColumn("AMOUNT_DUE", Type.GetType("System.Decimal"));
var colAMOUNT_DUE_USDOLLAR = new DataColumn("AMOUNT_DUE_USDOLLAR", Type.GetType("System.Decimal"));
var colAMOUNT = new DataColumn("AMOUNT", Type.GetType("System.Decimal"));
var colAMOUNT_USDOLLAR = new DataColumn("AMOUNT_USDOLLAR", Type.GetType("System.Decimal"));
dtLineItems.Columns.Add(colID);
dtLineItems.Columns.Add(colINVOICE_NAME);
dtLineItems.Columns.Add(colINVOICE_ID);
dtLineItems.Columns.Add(colAMOUNT_DUE);
dtLineItems.Columns.Add(colAMOUNT_DUE_USDOLLAR);
dtLineItems.Columns.Add(colAMOUNT);
dtLineItems.Columns.Add(colAMOUNT_USDOLLAR);
DataRow rowNew = null;
string innerSql = ApplicationSQL.SQL["Payments_AllocationsView"].ToString();
oQuery.CommandText = innerSql;
Guid gPARENT_ID = CommonTypeConvert.ToGuid(Request["PARENT_ID"]);
TypeConvert.AppendParameter(oQuery, gPARENT_ID, "ID", false);
using (SqlDataReader rdrInvoice = oQuery.ExecuteReader(CommandBehavior.SingleRow))
{
if (rdrInvoice.Read())
{
rowNew = dtLineItems.NewRow();
rowNew["INVOICE_NAME"] = CommonTypeConvert.ToString(rdrInvoice["NAME"]);
rowNew["INVOICE_ID"] = CommonTypeConvert.ToGuid(rdrInvoice["ID"]);
rowNew["AMOUNT_DUE"] = CommonTypeConvert.ToDecimal(rdrInvoice["AMOUNT_DUE"]);
rowNew["AMOUNT_DUE_USDOLLAR"] =
CommonTypeConvert.ToDecimal(rdrInvoice["AMOUNT_DUE_USDOLLAR"]);
rowNew["AMOUNT"] = CommonTypeConvert.ToDecimal(rdrInvoice["AMOUNT_DUE"]);
rowNew["AMOUNT_USDOLLAR"] = CommonTypeConvert.ToDecimal(rdrInvoice["AMOUNT_DUE_USDOLLAR"]);
if (rdrInvoice["AMOUNT_DUE"] == DBNull.Value)
{
rowNew["AMOUNT_DUE"] = CommonTypeConvert.ToDecimal(rdrInvoice["TOTAL"]);
rowNew["AMOUNT_DUE_USDOLLAR"] = CommonTypeConvert.ToDecimal(rdrInvoice["TOTAL_USDOLLAR"]);
rowNew["AMOUNT"] = CommonTypeConvert.ToDecimal(rdrInvoice["TOTAL"]);
rowNew["AMOUNT_USDOLLAR"] = CommonTypeConvert.ToDecimal(rdrInvoice["TOTAL_USDOLLAR"]);
}
dtLineItems.Rows.Add(rowNew);
}
}
rowNew = dtLineItems.NewRow();
dtLineItems.Rows.Add(rowNew);
ViewState["LineItems"] = dtLineItems;
grdMain.DataSource = dtLineItems;
grdMain.EditIndex = dtLineItems.Rows.Count - 1;
grdMain.DataBind();
UpdateTotals();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
SetPageTitle(Translation.GetTranslation.Term(".moduleList." + m_sMODULE));
Visible = (Security.GetUserAccess(m_sMODULE, "edit") >= 0);
if (!Visible)
return;
gID = CommonTypeConvert.ToGuid(Request["ID"]);
if (!IsPostBack)
{
ctlDynamicButtons.AppendButtons(m_sMODULE + ".EditView", Guid.Empty, null);
Guid gDuplicateID = CommonTypeConvert.ToGuid(Request["DuplicateID"]);
if (!CommonTypeConvert.IsEmptyGuid(gID) || !CommonTypeConvert.IsEmptyGuid(gDuplicateID))
{
var oQuery = new InlineQueryDBManager();
string innerSql = ApplicationSQL.SQL["Administration_ProductTemplates_EditView"].ToString();
oQuery.CommandText = innerSql;
if (!CommonTypeConvert.IsEmptyGuid(gDuplicateID))
{
oQuery.Add("@ID", SqlDbType.UniqueIdentifier, gDuplicateID);
gID = Guid.Empty;
}
else
{
oQuery.Add("@ID", SqlDbType.UniqueIdentifier, gID);
}
using (SqlDataReader rdr = oQuery.ExecuteReader(CommandBehavior.SingleRow))
{
if (rdr.Read())
{
ctlModuleHeader.Title = CommonTypeConvert.ToString(rdr["NAME"]);
SetPageTitle(Translation.GetTranslation.Term(".moduleList." + m_sMODULE) + " - " +
ctlModuleHeader.Title);
Utils.UpdateTracker(Page, m_sMODULE, gID, ctlModuleHeader.Title);
ViewState["ctlModuleHeader.Title"] = ctlModuleHeader.Title;
AppendEditViewFields(m_sMODULE + ".EditView", tblMain, rdr);
}
}
}
else
{
AppendEditViewFields(m_sMODULE + ".EditView", tblMain, null);
}
}
else
{
ctlModuleHeader.Title = CommonTypeConvert.ToString(ViewState["ctlModuleHeader.Title"]);
SetPageTitle(Translation.GetTranslation.Term(".moduleList." + m_sMODULE) + " - " + ctlModuleHeader.Title);
}
}
protected void Page_Load(object sender, EventArgs e)
{
SetPageTitle(Translation.GetTranslation.Term(".moduleList." + m_sMODULE));
Visible = (Security.GetUserAccess(m_sMODULE, "edit") >= 0);
if (!Visible)
{
return;
}
gID = CommonTypeConvert.ToGuid(Request["ID"]);
if (!IsPostBack)
{
Guid gDuplicateID = CommonTypeConvert.ToGuid(Request["DuplicateID"]);
if (!CommonTypeConvert.IsEmptyGuid(gID) || !CommonTypeConvert.IsEmptyGuid(gDuplicateID))
{
var oQuery = new InlineQueryDBManager();
string innerSql = ApplicationSQL.SQL["Products_EditView"].ToString();
oQuery.CommandText = innerSql;
CRMSecurity.Filter(oQuery, m_sMODULE, "edit");
if (!CommonTypeConvert.IsEmptyGuid(gDuplicateID))
{
TypeConvert.AppendParameter(oQuery, gDuplicateID, "ID", false);
gID = Guid.Empty;
}
else
{
TypeConvert.AppendParameter(oQuery, gID, "ID", false);
}
using (SqlDataReader rdr = oQuery.ExecuteReader(CommandBehavior.SingleRow))
{
if (rdr.Read())
{
ctlModuleHeader.Title = CommonTypeConvert.ToString(rdr["NAME"]);
SetPageTitle(Translation.GetTranslation.Term(".moduleList." + m_sMODULE) + " - " +
ctlModuleHeader.Title);
Utils.UpdateTracker(Page, m_sMODULE, gID, ctlModuleHeader.Title);
ViewState["ctlModuleHeader.Title"] = ctlModuleHeader.Title;
AppendEditViewFields(m_sMODULE + ".EditView", tblMain, rdr);
AppendEditViewFields(m_sMODULE + ".CostView", tblCost, rdr);
AppendEditViewFields(m_sMODULE + ".MftView", tblManufacturer, rdr);
ctlDynamicButtons.AppendButtons(m_sMODULE + ".EditView",
CommonTypeConvert.ToGuid(rdr["ASSIGNED_USER_ID"]), rdr);
var txtNAME = FindControl("NAME") as TextBox;
if (txtNAME != null)
{
txtNAME.ReadOnly = false;
}
}
else
{
ctlDynamicButtons.AppendButtons(m_sMODULE + ".EditView", Guid.Empty, null);
ctlDynamicButtons.DisableAll();
ctlDynamicButtons.ErrorText = Translation.GetTranslation.Term("ACL.LBL_NO_ACCESS");
}
}
}
else
{
AppendEditViewFields(m_sMODULE + ".EditView", tblMain, null);
AppendEditViewFields(m_sMODULE + ".CostView", tblCost, null);
AppendEditViewFields(m_sMODULE + ".MftView", tblManufacturer, null);
ctlDynamicButtons.AppendButtons(m_sMODULE + ".EditView", Guid.Empty, null);
var txtNAME = FindControl("NAME") as TextBox;
if (txtNAME != null)
{
txtNAME.ReadOnly = false;
}
Guid gPARENT_ID = CommonTypeConvert.ToGuid(Request["PARENT_ID"]);
if (!CommonTypeConvert.IsEmptyGuid(gPARENT_ID))
{
string sMODULE = String.Empty;
string sPARENT_TYPE = String.Empty;
string sPARENT_NAME = String.Empty;
CommonProcedure.ParentGet(ref gPARENT_ID, ref sMODULE, ref sPARENT_TYPE, ref sPARENT_NAME);
if (!CommonTypeConvert.IsEmptyGuid(gPARENT_ID) && sMODULE == "Accounts")
{
new DynamicControl(this, "ACCOUNT_ID").ID = gPARENT_ID;
new DynamicControl(this, "ACCOUNT_NAME").Text = sPARENT_NAME;
}
else if (!CommonTypeConvert.IsEmptyGuid(gPARENT_ID) && sMODULE == "Contacts")
{
new DynamicControl(this, "CONTACT_ID").ID = gPARENT_ID;
new DynamicControl(this, "CONTACT_NAME").Text = sPARENT_NAME;
}
}
}
}
else
{
ctlModuleHeader.Title = CommonTypeConvert.ToString(ViewState["ctlModuleHeader.Title"]);
SetPageTitle(Translation.GetTranslation.Term(".moduleList." + m_sMODULE) + " - " + ctlModuleHeader.Title);
}
}
protected void Page_Load(object sender, EventArgs e)
{
SetPageTitle(Translation.GetTranslation.Term(".moduleList." + m_sMODULE));
Visible = (Security.GetUserAccess(m_sMODULE, "edit") >= 0);
if (!Visible)
{
return;
}
gID = CommonTypeConvert.ToGuid(Request["ID"]);
if (!IsPostBack)
{
string sLOAD_MODULE = "Invoices";
string sLOAD_MODULE_KEY = "INVOICE_ID";
Guid gQUOTE_ID = CommonTypeConvert.ToGuid(Request["QUOTE_ID"]);
Guid gORDER_ID = CommonTypeConvert.ToGuid(Request["ORDER_ID"]);
Guid gDuplicateID = CommonTypeConvert.ToGuid(Request["DuplicateID"]);
if (!CommonTypeConvert.IsEmptyGuid(gID) || !CommonTypeConvert.IsEmptyGuid(gDuplicateID) ||
!CommonTypeConvert.IsEmptyGuid(gQUOTE_ID) || !CommonTypeConvert.IsEmptyGuid(gORDER_ID))
{
string innerSql = ApplicationSQL.SQL["Invoices_EditView_323"].ToString();
var oQuery = new InlineQueryDBManager();
oQuery.CommandText = innerSql;
if (!CommonTypeConvert.IsEmptyGuid(gQUOTE_ID))
{
//Load the data from the QUOTES record.
sLOAD_MODULE = "Quotes";
sLOAD_MODULE_KEY = "QUOTE_ID";
innerSql = ApplicationSQL.SQL["Invoices_EditView_333"].ToString();
oQuery.CommandText = innerSql;
//Filter by the module we are loading.
CRMSecurity.Filter(oQuery, sLOAD_MODULE, "edit");
TypeConvert.AppendParameter(oQuery, gQUOTE_ID, "ID", false);
}
else if (!CommonTypeConvert.IsEmptyGuid(gORDER_ID))
{
// Load the data from the ORDERS record.
sLOAD_MODULE = "Orders";
sLOAD_MODULE_KEY = "ORDER_ID";
innerSql = ApplicationSQL.SQL["Invoices_EditView"].ToString();
oQuery.CommandText = innerSql;
//Filter by the module we are loading.
CRMSecurity.Filter(oQuery, sLOAD_MODULE, "edit");
TypeConvert.AppendParameter(oQuery, gORDER_ID, "ID", false);
}
else
{
//Use new CRMSecurity.Filter() function to apply Team and ACL security rules.
CRMSecurity.Filter(oQuery, m_sMODULE, "edit");
if (!CommonTypeConvert.IsEmptyGuid(gDuplicateID))
{
TypeConvert.AppendParameter(oQuery, gDuplicateID, "ID", false);
gID = Guid.Empty;
}
else
{
TypeConvert.AppendParameter(oQuery, gID, "ID", false);
}
}
using (SqlDataReader rdr = oQuery.ExecuteReader(CommandBehavior.SingleRow))
{
if (rdr.Read())
{
ctlModuleHeader.Title = CommonTypeConvert.ToString(rdr["NAME"]);
SetPageTitle(Translation.GetTranslation.Term(".moduleList." + m_sMODULE) + " - " +
ctlModuleHeader.Title);
Utils.UpdateTracker(Page, m_sMODULE, gID, ctlModuleHeader.Title);
ViewState["ctlModuleHeader.Title"] = ctlModuleHeader.Title;
ViewState["BILLING_ACCOUNT_ID"] = CommonTypeConvert.ToGuid(rdr["BILLING_ACCOUNT_ID"]);
ViewState["SHIPPING_ACCOUNT_ID"] = CommonTypeConvert.ToGuid(rdr["SHIPPING_ACCOUNT_ID"]);
new DynamicControl(this, "QUOTE_ID").ID = CommonTypeConvert.ToGuid(rdr["QUOTE_ID"]);
new DynamicControl(this, "ORDER_ID").ID = CommonTypeConvert.ToGuid(rdr["ORDER_ID"]);
AppendEditViewFields(m_sMODULE + ".EditView", tblMain, rdr);
AppendEditViewFields(m_sMODULE + ".EditAddress", tblAddress, rdr);
AppendEditViewFields(m_sMODULE + ".EditDescription", tblDescription, rdr);
//Dynamic buttons need to be recreated in order for events to fire.
ctlDynamicButtons.AppendButtons(m_sMODULE + ".EditView",
CommonTypeConvert.ToGuid(rdr["ASSIGNED_USER_ID"]), rdr);
if (!CommonTypeConvert.IsEmptyGuid(gQUOTE_ID))
{
new DynamicControl(this, "QUOTE_ID").ID = gQUOTE_ID;
new DynamicControl(this, "QUOTE_NAME").Text = CommonTypeConvert.ToString(rdr["NAME"]);
ctlEditLineItemsView.LoadLineItems(gQUOTE_ID, Guid.Empty, rdr, sLOAD_MODULE,
sLOAD_MODULE_KEY);
}
else if (!CommonTypeConvert.IsEmptyGuid(gORDER_ID))
{
new DynamicControl(this, "ORDER_ID").ID = gORDER_ID;
new DynamicControl(this, "ORDER_NAME").Text = CommonTypeConvert.ToString(rdr["NAME"]);
ctlEditLineItemsView.LoadLineItems(gORDER_ID, Guid.Empty, rdr, sLOAD_MODULE,
sLOAD_MODULE_KEY);
}
else
{
ctlEditLineItemsView.LoadLineItems(gID, gDuplicateID, rdr, sLOAD_MODULE,
sLOAD_MODULE_KEY);
}
}
else
{
ctlEditLineItemsView.LoadLineItems(gID, gDuplicateID, null, String.Empty, String.Empty);
//If item is not visible, then don't allow save
//Dynamic buttons need to be recreated in order for events to fire.
ctlDynamicButtons.AppendButtons(m_sMODULE + ".EditView", Guid.Empty, null);
ctlDynamicButtons.DisableAll();
ctlDynamicButtons.ErrorText = Translation.GetTranslation.Term("ACL.LBL_NO_ACCESS");
}
}
}
else
{
AppendEditViewFields(m_sMODULE + ".EditView", tblMain, null);
AppendEditViewFields(m_sMODULE + ".EditAddress", tblAddress, null);
AppendEditViewFields(m_sMODULE + ".EditDescription", tblDescription, null);
//Dynamic buttons need to be recreated in order for events to fire.
ctlDynamicButtons.AppendButtons(m_sMODULE + ".EditView", Guid.Empty, null);
//Prepopulate the Account.
Guid gPARENT_ID = CommonTypeConvert.ToGuid(Request["PARENT_ID"]);
if (!CommonTypeConvert.IsEmptyGuid(gPARENT_ID))
{
string sMODULE = String.Empty;
string sPARENT_TYPE = String.Empty;
string sPARENT_NAME = String.Empty;
CommonProcedure.ParentGet(ref gPARENT_ID, ref sMODULE, ref sPARENT_TYPE, ref sPARENT_NAME);
if (!CommonTypeConvert.IsEmptyGuid(gPARENT_ID) && sMODULE == "Accounts")
{
UpdateAccount(gPARENT_ID, true, true);
}
if (!CommonTypeConvert.IsEmptyGuid(gPARENT_ID) && sMODULE == "Contacts")
{
UpdateContact(gPARENT_ID, true, true);
}
else if (!CommonTypeConvert.IsEmptyGuid(gPARENT_ID) && sMODULE == "Opportunities")
{
new DynamicControl(this, "OPPORTUNITY_ID").ID = gPARENT_ID;
new DynamicControl(this, "OPPORTUNITY_NAME").Text = sPARENT_NAME;
}
}
ctlEditLineItemsView.LoadLineItems(gID, gDuplicateID, new InlineQueryDBManager(), null, String.Empty,
String.Empty);
}
}
else
{
// When validation fails, the header title does not retain its value. Update manually.
ctlModuleHeader.Title = CommonTypeConvert.ToString(ViewState["ctlModuleHeader.Title"]);
SetPageTitle(Translation.GetTranslation.Term(".moduleList." + m_sMODULE) + " - " + ctlModuleHeader.Title);
var ctlBILLING_ACCOUNT_ID = new DynamicControl(this, "BILLING_ACCOUNT_ID");
var ctlSHIPPING_ACCOUNT_ID = new DynamicControl(this, "SHIPPING_ACCOUNT_ID");
if (CommonTypeConvert.ToGuid(ViewState["BILLING_ACCOUNT_ID"]) != ctlBILLING_ACCOUNT_ID.ID)
{
UpdateAccount(ctlBILLING_ACCOUNT_ID.ID, true, true);
ViewState["BILLING_ACCOUNT_ID"] = ctlBILLING_ACCOUNT_ID.ID;
ViewState["SHIPPING_ACCOUNT_ID"] = ctlBILLING_ACCOUNT_ID.ID;
}
if (CommonTypeConvert.ToGuid(ViewState["SHIPPING_ACCOUNT_ID"]) != ctlSHIPPING_ACCOUNT_ID.ID)
{
UpdateAccount(ctlSHIPPING_ACCOUNT_ID.ID, false, true);
ViewState["SHIPPING_ACCOUNT_ID"] = ctlSHIPPING_ACCOUNT_ID.ID;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
SetPageTitle(Translation.GetTranslation.Term(".moduleList." + m_sMODULE));
Visible = (Security.GetUserAccess(m_sMODULE, "edit") >= 0);
if (!Visible)
return;
gID = CommonTypeConvert.ToGuid(Request["ID"]);
if (!IsPostBack)
{
Guid gDuplicateID = CommonTypeConvert.ToGuid(Request["DuplicateID"]);
if (!CommonTypeConvert.IsEmptyGuid(gID) || !CommonTypeConvert.IsEmptyGuid(gDuplicateID))
{
var oQuery = new InlineQueryDBManager();
string innerSql = ApplicationSQL.SQL["Products_EditView"].ToString();
oQuery.CommandText = innerSql;
CRMSecurity.Filter(oQuery, m_sMODULE, "edit");
if (!CommonTypeConvert.IsEmptyGuid(gDuplicateID))
{
TypeConvert.AppendParameter(oQuery, gDuplicateID, "ID", false);
gID = Guid.Empty;
}
else
{
TypeConvert.AppendParameter(oQuery, gID, "ID", false);
}
using (SqlDataReader rdr = oQuery.ExecuteReader(CommandBehavior.SingleRow))
{
if (rdr.Read())
{
ctlModuleHeader.Title = CommonTypeConvert.ToString(rdr["NAME"]);
SetPageTitle(Translation.GetTranslation.Term(".moduleList." + m_sMODULE) + " - " +
ctlModuleHeader.Title);
Utils.UpdateTracker(Page, m_sMODULE, gID, ctlModuleHeader.Title);
ViewState["ctlModuleHeader.Title"] = ctlModuleHeader.Title;
AppendEditViewFields(m_sMODULE + ".EditView", tblMain, rdr);
AppendEditViewFields(m_sMODULE + ".CostView", tblCost, rdr);
AppendEditViewFields(m_sMODULE + ".MftView", tblManufacturer, rdr);
ctlDynamicButtons.AppendButtons(m_sMODULE + ".EditView",
CommonTypeConvert.ToGuid(rdr["ASSIGNED_USER_ID"]), rdr);
var txtNAME = FindControl("NAME") as TextBox;
if (txtNAME != null)
txtNAME.ReadOnly = false;
}
else
{
ctlDynamicButtons.AppendButtons(m_sMODULE + ".EditView", Guid.Empty, null);
ctlDynamicButtons.DisableAll();
ctlDynamicButtons.ErrorText = Translation.GetTranslation.Term("ACL.LBL_NO_ACCESS");
}
}
}
else
{
AppendEditViewFields(m_sMODULE + ".EditView", tblMain, null);
AppendEditViewFields(m_sMODULE + ".CostView", tblCost, null);
AppendEditViewFields(m_sMODULE + ".MftView", tblManufacturer, null);
ctlDynamicButtons.AppendButtons(m_sMODULE + ".EditView", Guid.Empty, null);
var txtNAME = FindControl("NAME") as TextBox;
if (txtNAME != null)
txtNAME.ReadOnly = false;
Guid gPARENT_ID = CommonTypeConvert.ToGuid(Request["PARENT_ID"]);
if (!CommonTypeConvert.IsEmptyGuid(gPARENT_ID))
{
string sMODULE = String.Empty;
string sPARENT_TYPE = String.Empty;
string sPARENT_NAME = String.Empty;
CommonProcedure.ParentGet(ref gPARENT_ID, ref sMODULE, ref sPARENT_TYPE, ref sPARENT_NAME);
if (!CommonTypeConvert.IsEmptyGuid(gPARENT_ID) && sMODULE == "Accounts")
{
new DynamicControl(this, "ACCOUNT_ID").ID = gPARENT_ID;
new DynamicControl(this, "ACCOUNT_NAME").Text = sPARENT_NAME;
}
else if (!CommonTypeConvert.IsEmptyGuid(gPARENT_ID) && sMODULE == "Contacts")
{
new DynamicControl(this, "CONTACT_ID").ID = gPARENT_ID;
new DynamicControl(this, "CONTACT_NAME").Text = sPARENT_NAME;
}
}
}
}
else
{
ctlModuleHeader.Title = CommonTypeConvert.ToString(ViewState["ctlModuleHeader.Title"]);
SetPageTitle(Translation.GetTranslation.Term(".moduleList." + m_sMODULE) + " - " + ctlModuleHeader.Title);
}
}