protected void Page_Command(object sender, CommandEventArgs e)
{
switch (e.CommandName)
{
case "Payments.Create":
Response.Redirect("~/CRM/Payments/edit.aspx?PARENT_ID=" + gID);
break;
case "Payments.Edit":
{
Guid gPAYMENT_ID = CommonTypeConvert.ToGuid(e.CommandArgument);
Response.Redirect("~/CRM/Payments/edit.aspx?ID=" + gPAYMENT_ID);
break;
}
case "Payments.Remove":
{
Guid gINVOICE_PAYMENT_ID = CommonTypeConvert.ToGuid(e.CommandArgument);
CommonProcedure.InvoicesPAYMENTS_Delete(gINVOICE_PAYMENT_ID);
BindGrid();
break;
}
default:
break;
}
}
protected void Page_Command(Object sender, CommandEventArgs e)
{
if (e.CommandName == "Save" || e.CommandName == "SaveNew")
{
if (Page.IsValid)
{
Guid gPARENT_ID = CommonTypeConvert.ToGuid(txtPARENT_ID.Value);
if (gPARENT_ID == gID)
{
gPARENT_ID = Guid.Empty;
}
CommonProcedure.spPRODUCT_CATEGORIES_Update(
ref gID
, gPARENT_ID
, txtNAME.Text
, txtDESCRIPTION.Text
, CommonTypeConvert.ToInteger(txtLIST_ORDER.Text)
);
Cache.Remove("vwPRODUCT_CATEGORIES_LISTBOX");
if (e.CommandName == "SaveNew")
{
Response.Redirect("edit.aspx");
}
else
{
Response.Redirect("Index.aspx");
}
}
}
}
protected void Page_Command(object sender, CommandEventArgs e)
{
switch (e.CommandName)
{
case "Notes.Create":
Response.Redirect("~/CRM/Notes/edit.aspx?PARENT_ID=" + gID);
break;
case "Notes.Edit":
{
Guid gNOTE_ID = CommonTypeConvert.ToGuid(e.CommandArgument);
Response.Redirect("~/CRM/Notes/edit.aspx?ID=" + gNOTE_ID);
break;
}
case "Notes.Delete":
{
Guid gNOTE_ID = CommonTypeConvert.ToGuid(e.CommandArgument);
CommonProcedure.NotesDelete(gNOTE_ID);
BindGrid();
break;
}
default:
throw (new Exception("Unknown command: " + e.CommandName));
}
}
protected void Page_Command(Object sender, CommandEventArgs e)
{
if (e.CommandName == "Edit")
{
Response.Redirect("edit.aspx?ID=" + gID);
}
else if (e.CommandName == "Duplicate")
{
Response.Redirect("edit.aspx?DuplicateID=" + gID);
}
else if (e.CommandName == "Delete")
{
CommonProcedure.ProductTemplatesDelete(gID);
Response.Redirect("Index.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
gID = CommonTypeConvert.ToGuid(Request["ID"]);
Guid gCHILD_ID = CommonTypeConvert.ToGuid(txtCHILD_ID.Value);
if (!CommonTypeConvert.IsEmptyGuid(gCHILD_ID))
{
CommonProcedure.ProductProductUpdate(gID, gCHILD_ID);
txtCHILD_ID.Value = String.Empty;
}
BindGrid();
if (!IsPostBack)
{
Guid gASSIGNED_USER_ID = CommonTypeConvert.ToGuid(Page.Items["ASSIGNED_USER_ID"]);
ctlDynamicButtons.AppendButtons(m_sMODULE + ".RelatedProducts", gASSIGNED_USER_ID, gID);
}
}
protected void Page_Command(object sender, CommandEventArgs e)
{
switch (e.CommandName)
{
case "Tasks.Create":
Response.Redirect("~/CRM/Tasks/edit.aspx?PARENT_ID=" + gID);
break;
case "Meetings.Create":
Response.Redirect("~/CRM/Meetings/edit.aspx?PARENT_ID=" + gID);
break;
case "Calls.Create":
Response.Redirect("~/CRM/Calls/edit.aspx?PARENT_ID=" + gID);
break;
case "Emails.Compose":
Response.Redirect("~/CRM/Emails/edit.aspx?PARENT_ID=" + gID);
break;
case "Notes.Create":
Response.Redirect("~/CRM/Notes/edit.aspx?PARENT_ID=" + gID);
break;
case "Emails.Archive":
Response.Redirect("~/CRM/Emails/edit.aspx?PARENT_ID=" + gID);
break;
case "Activities.Delete":
{
Guid gACTIVITY_ID = CommonTypeConvert.ToGuid(e.CommandArgument);
CommonProcedure.ActivitiesDelete(gACTIVITY_ID);
BindGrid();
break;
}
default:
break;
}
}
protected void Page_Command(object sender, CommandEventArgs e)
{
switch (e.CommandName)
{
case "Products.Edit":
{
Guid gPRODUCT_ID = CommonTypeConvert.ToGuid(e.CommandArgument);
Response.Redirect("~/CRM/Products/edit.aspx?ID=" + gPRODUCT_ID);
break;
}
case "Products.Remove":
{
Guid gCHILD_ID = CommonTypeConvert.ToGuid(e.CommandArgument);
CommonProcedure.ProductProductDelete(gID, gCHILD_ID);
BindGrid();
break;
}
default:
throw (new Exception("Unknown command: " + e.CommandName));
}
}
protected void Page_Command(Object sender, CommandEventArgs e)
{
if (e.CommandName == "Save" || e.CommandName == "SaveNew")
{
if (Page.IsValid)
{
CommonProcedure.ManufacturersUpdate(
ref gID
, txtNAME.Text
, lstSTATUS.SelectedValue
, CommonTypeConvert.ToInteger(txtLIST_ORDER.Text)
);
Cache.Remove("vwMANUFACTURERS_LISTBOX");
if (e.CommandName == "SaveNew")
{
Response.Redirect("edit.aspx");
}
else
{
Response.Redirect("Index.aspx");
}
}
}
}
protected void Page_Command(Object sender, CommandEventArgs e)
{
if (e.CommandName == "Save" || e.CommandName == "SaveNew")
{
if (Page.IsValid)
{
CommonProcedure.ProductTypesUpdate(
ref gID
, txtNAME.Text
, txtDESCRIPTION.Text
, CommonTypeConvert.ToInteger(txtLIST_ORDER.Text)
);
Cache.Remove("vwPRODUCT_TYPES_LISTBOX");
if (e.CommandName == "SaveNew")
{
Response.Redirect("edit.aspx");
}
else
{
Response.Redirect("Index.aspx");
}
}
}
}
protected void Page_Command(object sender, CommandEventArgs e)
{
if (e.CommandName == "ProductCategories.Create")
{
Response.Redirect("edit.aspx");
}
else if (e.CommandName == "ProductCategories.Delete")
{
Guid gID = CommonTypeConvert.ToGuid(e.CommandArgument);
CommonProcedure.spPRODUCT_CATEGORIES_Delete(gID);
Cache.Remove("vwPRODUCT_CATEGORIES_LISTBOX");
Response.Redirect("Index.aspx");
}
else if (e.CommandName == "Export")
{
int nACLACCESS = Security.GetUserAccess(m_sMODULE, "export");
if (nACLACCESS >= 0)
{
string[] arrID = Request.Form.GetValues("chkMain");
CRMExport.Export(vwMain, m_sMODULE, ctlExportHeader.ExportFormat, ctlExportHeader.ExportRange,
grdMain.CurrentPageIndex, grdMain.PageSize, arrID);
}
}
}
protected void Page_Command(Object sender, CommandEventArgs e)
{
Guid gPARENT_ID = CommonTypeConvert.ToGuid(Request["PARENT_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 (e.CommandName == "Save")
{
var txtNAME = FindControl("NAME") as TextBox;
var txtPRODUCT_TEMPLATE_ID = FindControl("PRODUCT_TEMPLATE_ID") as HtmlInputHidden;
if (CommonTypeConvert.IsEmptyString(txtNAME.Text.Trim()))
{
txtPRODUCT_TEMPLATE_ID.Value = String.Empty;
}
else if (CommonTypeConvert.IsEmptyString(txtPRODUCT_TEMPLATE_ID.Value))
{
txtPRODUCT_TEMPLATE_ID.Value = Guid.Empty.ToString();
}
ValidateEditViewFields(m_sMODULE + ".EditView");
ValidateEditViewFields(m_sMODULE + ".CostView");
ValidateEditViewFields(m_sMODULE + ".MftView");
if (Page.IsValid)
{
string sCUSTOM_MODULE = "PRODUCTS";
DataTable dtCustomFields = CRMCache.FieldsMetaData_Validated(sCUSTOM_MODULE);
var oQuery = new InlineQueryDBManager();
DataRow rowCurrent = null;
if (!CommonTypeConvert.IsEmptyGuid(gID))
{
string innerSql = ApplicationSQL.SQL["Products_EditView"].ToString();
oQuery.CommandText = innerSql;
CRMSecurity.Filter(oQuery, m_sMODULE, "edit");
TypeConvert.AppendParameter(oQuery, gID, "ID", false);
DataTable dtCurrent = oQuery.GetTable();
if (dtCurrent.Rows.Count > 0)
{
rowCurrent = dtCurrent.Rows[0];
}
else
{
gID = Guid.Empty;
}
}
CommonProcedure.ProductUpdate
(ref gID
, new DynamicControl(this, rowCurrent, "PRODUCT_TEMPLATE_ID").ID
, new DynamicControl(this, rowCurrent, "NAME").Text
, new DynamicControl(this, rowCurrent, "STATUS").SelectedValue
, new DynamicControl(this, rowCurrent, "ACCOUNT_ID").ID
, new DynamicControl(this, rowCurrent, "CONTACT_ID").ID
, new DynamicControl(this, rowCurrent, "QUANTITY").IntegerValue
, new DynamicControl(this, rowCurrent, "DATE_PURCHASED").DateValue
, new DynamicControl(this, rowCurrent, "DATE_SUPPORT_EXPIRES").DateValue
, new DynamicControl(this, rowCurrent, "DATE_SUPPORT_STARTS").DateValue
, new DynamicControl(this, rowCurrent, "MANUFACTURER_ID").ID
, new DynamicControl(this, rowCurrent, "CATEGORY_ID").ID
, new DynamicControl(this, rowCurrent, "TYPE_ID").ID
, new DynamicControl(this, rowCurrent, "WEBSITE").Text
, new DynamicControl(this, rowCurrent, "MFT_PART_NUM").Text
, new DynamicControl(this, rowCurrent, "VENDOR_PART_NUM").Text
, new DynamicControl(this, rowCurrent, "SERIAL_NUMBER").Text
, new DynamicControl(this, rowCurrent, "ASSET_NUMBER").Text
, new DynamicControl(this, rowCurrent, "TAX_CLASS").SelectedValue
, new DynamicControl(this, rowCurrent, "WEIGHT").FloatValue
, new DynamicControl(this, rowCurrent, "CURRENCY_ID").ID
, new DynamicControl(this, rowCurrent, "COST_PRICE").DecimalValue
, new DynamicControl(this, rowCurrent, "LIST_PRICE").DecimalValue
, new DynamicControl(this, rowCurrent, "BOOK_VALUE").DecimalValue
, new DynamicControl(this, rowCurrent, "BOOK_VALUE_DATE").DateValue
, new DynamicControl(this, rowCurrent, "DISCOUNT_PRICE").DecimalValue
, new DynamicControl(this, rowCurrent, "PRICING_FACTOR").IntegerValue
, new DynamicControl(this, rowCurrent, "PRICING_FORMULA").SelectedValue
, new DynamicControl(this, rowCurrent, "SUPPORT_NAME").Text
, new DynamicControl(this, rowCurrent, "SUPPORT_CONTACT").Text
, new DynamicControl(this, rowCurrent, "SUPPORT_DESCRIPTION").Text
, new DynamicControl(this, rowCurrent, "SUPPORT_TERM").SelectedValue
, new DynamicControl(this, rowCurrent, "DESCRIPTION").Text
, new DynamicControl(this, rowCurrent, "TEAM_ID").ID
);
CRMDynamic.UpdateCustomFields(this, gID, sCUSTOM_MODULE, dtCustomFields);
if (!CommonTypeConvert.IsEmptyGuid(gPARENT_ID))
{
Response.Redirect("~/CRM/" + sMODULE + "/view.aspx?ID=" + gPARENT_ID);
}
else
{
Response.Redirect("view.aspx?ID=" + gID);
}
}
}
else if (e.CommandName == "Cancel")
{
if (!CommonTypeConvert.IsEmptyGuid(gPARENT_ID))
{
Response.Redirect("~/CRM/" + sMODULE + "/view.aspx?ID=" + gPARENT_ID);
}
else if (CommonTypeConvert.IsEmptyGuid(gID))
{
Response.Redirect("Index.aspx");
}
else
{
Response.Redirect("view.aspx?ID=" + gID);
}
}
}
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_Command(Object sender, CommandEventArgs e)
{
if (e.CommandName == "Save" || e.CommandName == "Charge")
{
ValidateEditViewFields(m_sMODULE + ".EditView");
bool bIsValid = Page.IsValid;
Decimal dAMOUNT = new DynamicControl(this, "AMOUNT").DecimalValue;
if (dAMOUNT != ctlAllocationsView.ALLOCATED_TOTAL)
{
ctlDynamicButtons.ErrorText =
Translation.GetTranslation.Term("Payments.ERR_AMOUNT_MUST_MATCH_ALLOCATION");
bIsValid = false;
}
if (bIsValid)
{
string sCUSTOM_MODULE = "PAYMENTS";
DataTable dtCustomFields = CRMCache.FieldsMetaData_Validated(sCUSTOM_MODULE);
var oQuery = new InlineQueryDBManager();
DataRow rowCurrent = null;
if (!CommonTypeConvert.IsEmptyGuid(gID))
{
string innerSql = ApplicationSQL.SQL["Payments_EditView_259"].ToString();
oQuery.CommandText = innerSql;
CRMSecurity.Filter(oQuery, m_sMODULE, "edit");
TypeConvert.AppendParameter(oQuery, gID, "ID", false);
DataTable dtCurrent = oQuery.GetTable();
if (dtCurrent.Rows.Count > 0)
{
rowCurrent = dtCurrent.Rows[0];
}
else
{
gID = Guid.Empty;
}
}
Guid gASSIGNED_USER_ID = new DynamicControl(this, rowCurrent, "ASSIGNED_USER_ID").ID;
Guid gACCOUNT_ID = new DynamicControl(this, rowCurrent, "ACCOUNT_ID").ID;
DateTime dtPAYMENT_DATE = new DynamicControl(this, rowCurrent, "PAYMENT_DATE").DateValue;
string sPAYMENT_TYPE = new DynamicControl(this, rowCurrent, "PAYMENT_TYPE").SelectedValue;
string sCUSTOMER_REFERENCE = new DynamicControl(this, rowCurrent, "CUSTOMER_REFERENCE").Text;
Guid gCURRENCY_ID = new DynamicControl(this, rowCurrent, "CURRENCY_ID").ID;
string sDESCRIPTION = new DynamicControl(this, rowCurrent, "DESCRIPTION").Text;
Guid gTEAM_ID = new DynamicControl(this, rowCurrent, "TEAM_ID").ID;
Guid gCREDIT_CARD_ID = new DynamicControl(this, rowCurrent, "CREDIT_CARD_ID").ID;
if (sPAYMENT_TYPE != "Credit Card")
{
gCREDIT_CARD_ID = Guid.Empty;
}
float fEXCHANGE_RATE =
new DynamicControl(ctlAllocationsView, rowCurrent, "EXCHANGE_RATE").FloatValue;
var sbINVOICE_NUMBER = new StringBuilder();
if (dtPAYMENT_DATE == ((DateTime)SqlDateTime.MinValue) || e.CommandName == "Charge")
{
dtPAYMENT_DATE = DateTime.Now;
}
CommonProcedure.PatmentsUpdate
(ref gID
, gASSIGNED_USER_ID
, gACCOUNT_ID
, dtPAYMENT_DATE
, sPAYMENT_TYPE
, sCUSTOMER_REFERENCE
, fEXCHANGE_RATE
, gCURRENCY_ID
, dAMOUNT
, sDESCRIPTION
, gTEAM_ID
, gCREDIT_CARD_ID
);
CRMDynamic.UpdateCustomFields(this, gID, sCUSTOM_MODULE, dtCustomFields);
DataTable dtLineItems = ctlAllocationsView.LineItems;
foreach (DataRow row in dtLineItems.Rows)
{
if (row.RowState == DataRowState.Deleted)
{
Guid gITEM_ID = CommonTypeConvert.ToGuid(row["ID", DataRowVersion.Original]);
if (!CommonTypeConvert.IsEmptyGuid(gITEM_ID))
{
CommonProcedure.InvoicesPAYMENTS_Delete(gITEM_ID);
}
}
}
foreach (DataRow row in dtLineItems.Rows)
{
if (row.RowState != DataRowState.Deleted)
{
Guid gITEM_ID = CommonTypeConvert.ToGuid(row["ID"]);
Guid gINVOICE_ID = CommonTypeConvert.ToGuid(row["INVOICE_ID"]);
Decimal dINVOICE_AMOUNT = CommonTypeConvert.ToDecimal(row["AMOUNT"]);
if (!CommonTypeConvert.IsEmptyGuid(gINVOICE_ID))
{
CommonProcedure.InvoicesPAYMENTS_Update
(ref gITEM_ID
, gINVOICE_ID
, gID
, dINVOICE_AMOUNT
);
if (sbINVOICE_NUMBER.Length > 0)
{
sbINVOICE_NUMBER.Append(",");
}
sbINVOICE_NUMBER.Append(gINVOICE_ID.ToString());
}
}
}
ViewState["ID"] = gID;
if (e.CommandName == "Charge")
{
sbINVOICE_NUMBER.Append(" " + DateTime.UtcNow);
//CRM.Common.Charge.CC.Charge(Application, gID, gCURRENCY_ID, gACCOUNT_ID, gCREDIT_CARD_ID, Request.UserHostAddress, sbINVOICE_NUMBER.ToString(), sDESCRIPTION, dAMOUNT);
}
Response.Redirect("view.aspx?ID=" + gID);
}
}
else if (e.CommandName == "Cancel")
{
if (CommonTypeConvert.IsEmptyGuid(gID))
{
Response.Redirect("Index.aspx");
}
else
{
Response.Redirect("view.aspx?ID=" + gID);
}
}
}
protected void Page_Command(object sender, CommandEventArgs e)
{
if (e.CommandName == "Search")
{
grdMain.CurrentPageIndex = 0;
grdMain.DataBind();
}
else if (e.CommandName == "SortGrid")
{
grdMain.SetSortFields(e.CommandArgument as string[]);
arrSelectFields.Add(grdMain.SortColumn);
}
else if (e.CommandName == "MassUpdate")
{
string[] arrID = Request.Form.GetValues("chkMain");
if (arrID != null)
{
Stack stk = Utils.FilterByACL_Stack(m_sMODULE, "edit", arrID, "INVOICES");
if (stk.Count > 0)
{
while (stk.Count > 0)
{
string sIDs = Utils.BuildMassIDs(stk);
CommonProcedure.InvoicesMassUpdate(sIDs, ctlMassUpdate.ASSIGNED_USER_ID,
ctlMassUpdate.PAYMENT_TERMS, ctlMassUpdate.INVOICE_STAGE,
TimeZone.GetTimeZone.ToServerTime(ctlMassUpdate.DUE_DATE),
ctlMassUpdate.TEAM_ID);
}
Response.Redirect("Index.aspx");
}
}
}
else if (e.CommandName == "MassDelete")
{
string[] arrID = Request.Form.GetValues("chkMain");
if (arrID != null)
{
Stack stk = Utils.FilterByACL_Stack(m_sMODULE, "delete", arrID, "INVOICES");
if (stk.Count > 0)
{
while (stk.Count > 0)
{
string sIDs = Utils.BuildMassIDs(stk);
CommonProcedure.InvoicesMassDelete(sIDs);
}
Response.Redirect("Index.aspx");
}
}
}
else if (e.CommandName == "Export")
{
// Apply ACL rules to Export.
int nACLACCESS = Security.GetUserAccess(m_sMODULE, "export");
if (nACLACCESS >= 0)
{
if (nACLACCESS == ACL_ACCESS.OWNER)
{
vwMain.RowFilter = "ASSIGNED_USER_ID = '" + Security.USER_ID + "'";
}
string[] arrID = Request.Form.GetValues("chkMain");
CRMExport.Export(vwMain, m_sMODULE, ctlExportHeader.ExportFormat, ctlExportHeader.ExportRange,
grdMain.CurrentPageIndex, grdMain.PageSize, arrID);
}
}
}
protected void Page_Command(Object sender, CommandEventArgs e)
{
Guid gORDER_ID = CommonTypeConvert.ToGuid(Request["ORDER_ID"]);
Guid gQUOTE_ID = CommonTypeConvert.ToGuid(Request["QUOTE_ID"]);
Guid gPARENT_ID = CommonTypeConvert.ToGuid(Request["PARENT_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 (e.CommandName == "Save")
{
ValidateEditViewFields(m_sMODULE + ".EditView");
ValidateEditViewFields(m_sMODULE + ".EditAddress");
ValidateEditViewFields(m_sMODULE + ".EditDescription");
if (Page.IsValid)
{
string sCUSTOM_MODULE = "INVOICES";
DataTable dtCustomFields = CRMCache.FieldsMetaData_Validated(sCUSTOM_MODULE);
DataTable dtCustomLineItems =
CRMCache.FieldsMetaData_UnvalidatedCustomFields(sCUSTOM_MODULE + "_LINE_ITEMS");
DataRow rowCurrent = null;
var dtCurrent = new DataTable();
if (!CommonTypeConvert.IsEmptyGuid(gID))
{
string innerSql = ApplicationSQL.SQL["Invoices_EditView_323"].ToString();
var oQuery = new InlineQueryDBManager();
oQuery.CommandText = innerSql;
CRMSecurity.Filter(oQuery, m_sMODULE, "edit");
TypeConvert.AppendParameter(oQuery, gID, "ID", false);
dtCurrent = oQuery.GetTable();
if (dtCurrent.Rows.Count > 0)
{
rowCurrent = dtCurrent.Rows[0];
}
else
{
gID = Guid.Empty;
}
}
ctlEditLineItemsView.UpdateTotals();
CommonProcedure.InvoicesUpdate
(ref gID
, new DynamicControl(this, rowCurrent, "ASSIGNED_USER_ID").ID
, new DynamicControl(this, rowCurrent, "NAME").Text
, new DynamicControl(this, rowCurrent, "QUOTE_ID").ID
, new DynamicControl(this, rowCurrent, "ORDER_ID").ID
, new DynamicControl(this, rowCurrent, "OPPORTUNITY_ID").ID
, new DynamicControl(this, rowCurrent, "PAYMENT_TERMS").SelectedValue
, new DynamicControl(this, rowCurrent, "INVOICE_STAGE").SelectedValue
, new DynamicControl(this, rowCurrent, "PURCHASE_ORDER_NUM").Text
, new DynamicControl(this, rowCurrent, "DUE_DATE").DateValue
, new DynamicControl(ctlEditLineItemsView, rowCurrent, "EXCHANGE_RATE").FloatValue
, new DynamicControl(ctlEditLineItemsView, rowCurrent, "CURRENCY_ID").ID
, new DynamicControl(ctlEditLineItemsView, rowCurrent, "TAXRATE_ID").ID
, new DynamicControl(ctlEditLineItemsView, rowCurrent, "SHIPPER_ID").ID
, new DynamicControl(ctlEditLineItemsView, rowCurrent, "SUBTOTAL").DecimalValue
, new DynamicControl(ctlEditLineItemsView, rowCurrent, "DISCOUNT").DecimalValue
, new DynamicControl(ctlEditLineItemsView, rowCurrent, "SHIPPING").DecimalValue
, new DynamicControl(ctlEditLineItemsView, rowCurrent, "TAX").DecimalValue
, new DynamicControl(ctlEditLineItemsView, rowCurrent, "TOTAL").DecimalValue
, new DynamicControl(ctlEditLineItemsView, rowCurrent, "AMOUNT_DUE").DecimalValue
, new DynamicControl(this, rowCurrent, "BILLING_ACCOUNT_ID").ID
, new DynamicControl(this, rowCurrent, "BILLING_CONTACT_ID").ID
, new DynamicControl(this, rowCurrent, "BILLING_ADDRESS_STREET").Text
, new DynamicControl(this, rowCurrent, "BILLING_ADDRESS_CITY").Text
, new DynamicControl(this, rowCurrent, "BILLING_ADDRESS_STATE").Text
, new DynamicControl(this, rowCurrent, "BILLING_ADDRESS_POSTALCODE").Text
, new DynamicControl(this, rowCurrent, "BILLING_ADDRESS_COUNTRY").Text
, new DynamicControl(this, rowCurrent, "SHIPPING_ACCOUNT_ID").ID
, new DynamicControl(this, rowCurrent, "SHIPPING_CONTACT_ID").ID
, new DynamicControl(this, rowCurrent, "SHIPPING_ADDRESS_STREET").Text
, new DynamicControl(this, rowCurrent, "SHIPPING_ADDRESS_CITY").Text
, new DynamicControl(this, rowCurrent, "SHIPPING_ADDRESS_STATE").Text
, new DynamicControl(this, rowCurrent, "SHIPPING_ADDRESS_POSTALCODE").Text
, new DynamicControl(this, rowCurrent, "SHIPPING_ADDRESS_COUNTRY").Text
, new DynamicControl(this, rowCurrent, "DESCRIPTION").Text
, new DynamicControl(this, rowCurrent, "TEAM_ID").ID
);
CRMDynamic.UpdateCustomFields(this, gID, sCUSTOM_MODULE, dtCustomFields);
DataTable dtLineItems = ctlEditLineItemsView.LineItems;
foreach (DataRow row in dtLineItems.Rows)
{
if (row.RowState == DataRowState.Deleted)
{
Guid gITEM_ID = CommonTypeConvert.ToGuid(row["ID", DataRowVersion.Original]);
if (!CommonTypeConvert.IsEmptyGuid(gITEM_ID))
{
CommonProcedure.InvoicesLINE_ITEMS_Delete(gITEM_ID);
}
}
}
int nPOSITION = 1;
foreach (DataRow row in dtLineItems.Rows)
{
if (row.RowState != DataRowState.Deleted)
{
Guid gITEM_ID = CommonTypeConvert.ToGuid(row["ID"]);
Guid gLINE_GROUP_ID = CommonTypeConvert.ToGuid(row["LINE_GROUP_ID"]);
string sLINE_ITEM_TYPE = CommonTypeConvert.ToString(row["LINE_ITEM_TYPE"]);
string sNAME = CommonTypeConvert.ToString(row["NAME"]);
string sMFT_PART_NUM = CommonTypeConvert.ToString(row["MFT_PART_NUM"]);
string sVENDOR_PART_NUM = CommonTypeConvert.ToString(row["VENDOR_PART_NUM"]);
Guid gPRODUCT_TEMPLATE_ID = CommonTypeConvert.ToGuid(row["PRODUCT_TEMPLATE_ID"]);
string sTAX_CLASS = CommonTypeConvert.ToString(row["TAX_CLASS"]);
int nQUANTITY = CommonTypeConvert.ToInteger(row["QUANTITY"]);
Decimal dCOST_PRICE = CommonTypeConvert.ToDecimal(row["COST_PRICE"]);
Decimal dLIST_PRICE = CommonTypeConvert.ToDecimal(row["LIST_PRICE"]);
Decimal dUNIT_PRICE = CommonTypeConvert.ToDecimal(row["UNIT_PRICE"]);
string sDESCRIPTION = CommonTypeConvert.ToString(row["DESCRIPTION"]);
if (!CommonTypeConvert.IsEmptyGuid(gPRODUCT_TEMPLATE_ID) ||
!CommonTypeConvert.IsEmptyString(sNAME))
{
CommonProcedure.InvoicesLINE_ITEMS_Update
(ref gITEM_ID
, gID
, gLINE_GROUP_ID
, sLINE_ITEM_TYPE
, nPOSITION
, sNAME
, sMFT_PART_NUM
, sVENDOR_PART_NUM
, gPRODUCT_TEMPLATE_ID
, sTAX_CLASS
, nQUANTITY
, dCOST_PRICE
, dLIST_PRICE
, dUNIT_PRICE
, sDESCRIPTION
);
CRMDynamic.UpdateCustomFields(row, gITEM_ID, sCUSTOM_MODULE + "_LINE_ITEMS",
dtCustomLineItems);
nPOSITION++;
}
}
}
CommonProcedure.InvoicesUpdateAmountDue(gID);
if (!CommonTypeConvert.IsEmptyGuid(gPARENT_ID))
{
Response.Redirect("~/CRM/" + sMODULE + "/view.aspx?ID=" + gPARENT_ID);
}
else
{
Response.Redirect("view.aspx?ID=" + gID);
}
}
}
else if (e.CommandName == "Cancel")
{
if (!CommonTypeConvert.IsEmptyGuid(gPARENT_ID))
{
Response.Redirect("~/CRM/" + sMODULE + "/view.aspx?ID=" + gPARENT_ID);
}
else if (!CommonTypeConvert.IsEmptyGuid(gORDER_ID))
{
Response.Redirect("~/CRM/Orders/view.aspx?ID=" + gORDER_ID);
}
else if (!CommonTypeConvert.IsEmptyGuid(gQUOTE_ID))
{
Response.Redirect("~/CRM/Quotes/view.aspx?ID=" + gQUOTE_ID);
}
else if (CommonTypeConvert.IsEmptyGuid(gID))
{
Response.Redirect("Index.aspx");
}
else
{
Response.Redirect("view.aspx?ID=" + gID);
}
}
}
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 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_Command(object sender, CommandEventArgs e)
{
if (e.CommandName == "Search")
{
grdMain.CurrentPageIndex = 0;
grdMain.DataBind();
}
else if (e.CommandName == "SortGrid")
{
grdMain.SetSortFields(e.CommandArgument as string[]);
arrSelectFields.Add(grdMain.SortColumn);
}
else if (e.CommandName == "MassUpdate")
{
string[] arrID = Request.Form.GetValues("chkMain");
if (arrID != null)
{
Stack stk = Utils.FilterByACL_Stack(m_sMODULE, "edit", arrID, "PRODUCTS");
if (stk.Count > 0)
{
var oQuery = new InlineQueryDBManager();
while (stk.Count > 0)
{
string sIDs = Utils.BuildMassIDs(stk);
}
Response.Redirect("Index.aspx");
}
}
}
else if (e.CommandName == "MassDelete")
{
string[] arrID = Request.Form.GetValues("chkMain");
if (arrID != null)
{
Stack stk = Utils.FilterByACL_Stack(m_sMODULE, "delete", arrID, "PRODUCTS");
if (stk.Count > 0)
{
while (stk.Count > 0)
{
string sIDs = Utils.BuildMassIDs(stk);
CommonProcedure.ProductMassDelete(sIDs);
}
Response.Redirect("Index.aspx");
}
}
}
else if (e.CommandName == "Export")
{
int nACLACCESS = Security.GetUserAccess(m_sMODULE, "export");
if (nACLACCESS >= 0)
{
if (nACLACCESS == ACL_ACCESS.OWNER)
{
vwMain.RowFilter = "ASSIGNED_USER_ID = '" + Security.USER_ID + "'";
}
string[] arrID = Request.Form.GetValues("chkMain");
CRMExport.Export(vwMain, m_sMODULE, ctlExportHeader.ExportFormat, ctlExportHeader.ExportRange,
grdMain.CurrentPageIndex, grdMain.PageSize, arrID);
}
}
}
protected void Page_Command(Object sender, CommandEventArgs e)
{
if (e.CommandName == "Save")
{
ValidateEditViewFields(m_sMODULE + ".EditView");
if (Page.IsValid)
{
string sCUSTOM_MODULE = "PRODUCT_TEMPLATES";
DataTable dtCustomFields = CRMCache.FieldsMetaData_Validated(sCUSTOM_MODULE);
var oQuery = new InlineQueryDBManager();
DataRow rowCurrent = null;
var dtCurrent = new DataTable();
if (!CommonTypeConvert.IsEmptyGuid(gID))
{
string innerSql = ApplicationSQL.SQL["Administration_ProductTemplates_EditView_39"].ToString();
oQuery.CommandText = innerSql;
CRMSecurity.Filter(oQuery, m_sMODULE, "edit");
TypeConvert.AppendParameter(oQuery, gID, "ID", false);
dtCurrent = oQuery.GetTable();
if (dtCurrent.Rows.Count > 0)
{
rowCurrent = dtCurrent.Rows[0];
}
else
{
gID = Guid.Empty;
}
}
CommonProcedure.ProductTemplatesUpdate
(ref gID
, new DynamicControl(this, rowCurrent, "NAME").Text
, new DynamicControl(this, rowCurrent, "STATUS").SelectedValue
, new DynamicControl(this, rowCurrent, "QUANTITY").IntegerValue
, new DynamicControl(this, rowCurrent, "DATE_AVAILABLE").DateValue
, new DynamicControl(this, rowCurrent, "DATE_COST_PRICE").DateValue
, new DynamicControl(this, rowCurrent, "ACCOUNT_ID").ID
, new DynamicControl(this, rowCurrent, "MANUFACTURER_ID").ID
, new DynamicControl(this, rowCurrent, "CATEGORY_ID").ID
, new DynamicControl(this, rowCurrent, "TYPE_ID").ID
, new DynamicControl(this, rowCurrent, "WEBSITE").Text
, new DynamicControl(this, rowCurrent, "MFT_PART_NUM").Text
, new DynamicControl(this, rowCurrent, "VENDOR_PART_NUM").Text
, new DynamicControl(this, rowCurrent, "TAX_CLASS").SelectedValue
, new DynamicControl(this, rowCurrent, "WEIGHT").FloatValue
, new DynamicControl(this, rowCurrent, "CURRENCY_ID").ID
, new DynamicControl(this, rowCurrent, "COST_PRICE").DecimalValue
, new DynamicControl(this, rowCurrent, "LIST_PRICE").DecimalValue
, new DynamicControl(this, rowCurrent, "DISCOUNT_PRICE").DecimalValue
, new DynamicControl(this, rowCurrent, "PRICING_FACTOR").IntegerValue
, new DynamicControl(this, rowCurrent, "PRICING_FORMULA").SelectedValue
, new DynamicControl(this, rowCurrent, "SUPPORT_NAME").Text
, new DynamicControl(this, rowCurrent, "SUPPORT_CONTACT").Text
, new DynamicControl(this, rowCurrent, "SUPPORT_DESCRIPTION").Text
, new DynamicControl(this, rowCurrent, "SUPPORT_TERM").SelectedValue
, new DynamicControl(this, rowCurrent, "DESCRIPTION").Text
);
CRMDynamic.UpdateCustomFields(this, gID, sCUSTOM_MODULE, dtCustomFields);
Response.Redirect("view.aspx?ID=" + gID);
}
}
else if (e.CommandName == "Cancel")
{
if (CommonTypeConvert.IsEmptyGuid(gID))
{
Response.Redirect("Index.aspx");
}
else
{
Response.Redirect("view.aspx?ID=" + gID);
}
}
}
