protected void SaveData()
{
ltmessage.Text = "";
int ItemId = -1;
int res = -1;
int Trading_Range_Id = -1;
try
{
int RowID = 0;
string Item_Group = ddlItemgroup.SelectedValue;
string Item_Description = txtItemDescription.Text;
int Billing_Interval = Convert.ToInt32(txtBilling_Interval.Text);
string Billing_Interval_Unit = ddlIntervalUnit.SelectedValue;
string Item_Rate = ddlItemRate.SelectedValue;
DataTable dt = GetAddTable();
foreach (GridDataItem item in rgdItems.MasterTableView.Items)
{
DropDownList ddlLTGMTP = (DropDownList)(item.FindControl("ddlLTGMTP"));
DropDownList ddlHoursWEFP = (DropDownList)(item.FindControl("ddlHoursWEFP"));
DropDownList ddlMinsWEFP = (DropDownList)(item.FindControl("ddlMinsWEFP"));
TextBox txtPWFF = (TextBox)(item.FindControl("txtPWFF"));
int hdnBilling_Item_Id = 0;
int hdnTPId = 0;
if (((HiddenField)item.FindControl("hdnBilling_Item_Id")).Value != "")
{
hdnBilling_Item_Id = Convert.ToInt32(((HiddenField)item.FindControl("hdnBilling_Item_Id")).Value);
}
if (((HiddenField)item.FindControl("hdnTPId")).Value != "")
{
hdnTPId = Convert.ToInt32(((HiddenField)item.FindControl("hdnTPId")).Value);
}
string WEF = "";
DataRow dritem = dt.NewRow();
if (txtPWFF.Text != "")
{
WEF = AddHourMin(txtPWFF.Text, ddlHoursWEFP.SelectedValue, ddlMinsWEFP.SelectedValue);
dritem["Billing_Item_Amount_Id"] = hdnBilling_Item_Id;
dritem["Trading_Date"] = WEF;
dritem["Trading_Range_Id"] = hdnTPId;
dritem["Date_Zone"] = ddlLTGMTP.SelectedValue;
dritem["Trading_Range"] = ((TextBox)item.FindControl("txtTradingRange")).Text;
dritem["Amount"] = ((TextBox)item.FindControl("txtItem_Amount")).Text;
dt.Rows.Add(dritem);
}
}
if (dt != null)
{
ItemId = objCP.INS_UPD_Billing_Item(UDFLib.ConvertIntegerToNull(Session["CPID"]), UDFLib.ConvertIntegerToNull(ViewState["ItemId"]), Item_Group, Item_Description, Billing_Interval, Billing_Interval_Unit, Item_Rate, UDFLib.ConvertIntegerToNull(Session["USERID"].ToString()));
if (ItemId > 0)
{
foreach (DataRow dr in dt.Rows)
{
Trading_Range_Id = objCP.INS_UPD_Trading_RangeByItem(UDFLib.ConvertIntegerToNull(dr["Trading_Range_Id"]), UDFLib.ConvertIntegerToNull(Session["CPID"]), UDFLib.ConvertDateToNull(dr["Trading_Date"]), dr["Trading_Range"].ToString(), dr["Date_Zone"].ToString(), UDFLib.ConvertIntegerToNull(Session["USERID"].ToString()));
dr["Trading_Range_Id"] = Trading_Range_Id;
}
if (dt.Columns["Trading_Date"] != null)
{
dt.Columns.Remove(dt.Columns["Trading_Date"]);
}
if (dt.Columns["Date_Zone"] != null)
{
dt.Columns.Remove(dt.Columns["Date_Zone"]);
}
if (dt.Columns["Trading_Range"] != null)
{
dt.Columns.Remove(dt.Columns["Trading_Range"]);
}
if (Trading_Range_Id == 0)
{
ltmessage.Text = "WEF date can not be duplicate!";
}
else
{
res = objCP.INS_UPD_Billing_Item_Price(UDFLib.ConvertIntegerToNull(Session["CPID"]), ItemId, dt, UDFLib.ConvertIntegerToNull(Session["USERID"].ToString()));
BindItems();
}
}
}
else
{
ltmessage.Text = "No trading range information found!";
}
ClearData();
}
catch (Exception ex)
{
ltmessage.Text = ex.ToString();
}
}
