private void saveval()
{
try
{
int i = 0;
DataTable dt = new DataTable();
dt.Columns.Add("Trading_Range_Id");
dt.Columns.Add("Trading_Date");
dt.Columns.Add("Trading_Range");
dt.Columns.Add("Trading_Period");
dt.Columns.Add("Min_Ext_Unit");
dt.Columns.Add("Min_Ext_Value");
dt.Columns.Add("Max_Ext_Unit");
dt.Columns.Add("Max_Ext_Value");
int inc = 1;
string WEF = "";
foreach (GridDataItem dataItem in rgdItems.MasterTableView.Items)
{
DropDownList ddlLTGMTP = (DropDownList)(dataItem.FindControl("ddlLTGMTP"));
DropDownList ddlHoursWEFP = (DropDownList)(dataItem.FindControl("ddlHoursWEFP"));
DropDownList ddlMinsWEFP = (DropDownList)(dataItem.FindControl("ddlMinsWEFP"));
TextBox txtPWFF = (TextBox)(dataItem.FindControl("txtPWFF"));
DropDownList ddlminUnit = (DropDownList)(dataItem.FindControl("ddlminUnit"));
DropDownList ddlmaxUnit = (DropDownList)(dataItem.FindControl("ddlmaxUnit"));
TextBox txtTradingRange = (TextBox)(dataItem.FindControl("txtTradingRange"));
TextBox txtTradingPeriod = (TextBox)(dataItem.FindControl("txtTradingPeriod"));
TextBox Min_Ext_Value = (TextBox)(dataItem.FindControl("Min_Ext_Value"));
TextBox Max_Ext_Value = (TextBox)(dataItem.FindControl("Max_Ext_Value"));
HiddenField hdnTPId = (HiddenField)(dataItem.FindControl("hdnTPId"));
if (txtPWFF.Text != "")
{
WEF = AddHourMin(txtPWFF.Text, ddlHoursWEFP.SelectedValue, ddlMinsWEFP.SelectedValue);
}
if (txtTradingRange.Text.Length > 0 && txtTradingPeriod.Text.Length > 0)
{
DataRow dritem = dt.NewRow();
if (hdnTPId.Value == null || hdnTPId.Value == "")
{
dritem["Trading_Range_Id"] = "0";
}
else
{
dritem["Trading_Range_Id"] = hdnTPId.Value;
}
if (WEF != "")
{
WEF = Convert.ToDateTime(WEF).ToString("yyyy-MM-dd hh:mm");
dritem["Trading_Date"] = WEF;
}
else
{
dritem["Trading_Date"] = WEF;
}
dritem["Trading_Range"] = txtTradingRange.Text;
dritem["Trading_Period"] = txtTradingPeriod.Text;
dritem["Min_Ext_Unit"] = ddlminUnit.SelectedValue;
dritem["Min_Ext_Value"] = Min_Ext_Value.Text == "" ? Convert.DBNull : Convert.ToInt32(Min_Ext_Value.Text);
dritem["Max_Ext_Unit"] = ddlmaxUnit.SelectedValue;
dritem["Max_Ext_Value"] = Max_Ext_Value.Text == "" ? Convert.DBNull : Convert.ToDecimal(Max_Ext_Value.Text);
dt.Rows.Add(dritem);
inc++;
}
}
int retval = 0;
if (dt.Rows.Count > 0)
{
retval = objCP.INS_UPD_Trading_Range(UDFLib.ConvertIntegerToNull(ViewState["CPID"]), dt, UDFLib.ConvertIntegerToNull(Session["USERID"].ToString()));
if (retval == 0)
{
lblError.Text = "With effect from cannot be duplicate! ";
}
else
{
BindItems();
}
}
else
{
lblError.Text = "Please provide Item description.";
}
}
catch (Exception ex)
{
string err = ex.ToString();
}
}
