protected void Button1_Click(object sender, EventArgs e)
{
// new RobotTableAdapters.InsuranceCompanyTableAdapter().Insert();
try
{
ValidateIssurance();
RobotTableAdapters.CollateralType_StockHypoTableAdapter robot = new RobotTableAdapters.CollateralType_StockHypoTableAdapter();
RobotTableAdapters.InsuranceTableAdapter robotInsuranceTable = new RobotTableAdapters.InsuranceTableAdapter();
//initialize values
int collateralId = Convert.ToInt32(Request.QueryString["collateralId"]);
int CollateralTypeId = Convert.ToInt32(Request.QueryString["CollateralTypeId"]);
int varTypeOfStock = 0; int varInsuranceCover_id = 0;
double varValueOfStock = 0; int varFrequencyOfValuation = 0;
varTypeOfStock = Convert.ToInt32(TypeOfStock_id.SelectedValue);
varValueOfStock = Convert.ToDouble(ValueOfStock_total.Text);
varFrequencyOfValuation = Convert.ToInt32(FrequencyOfValuation.SelectedValue);
varInsuranceCover_id = Convert.ToInt32(InsuranceCover_id.SelectedValue);
//insert values into CollateralType_Cash and retrieve max id as collateralDetailsId
int collateralDetailsId = Convert.ToInt32(robot.proc_insert_stockHypo(varTypeOfStock, ListOfStock.Text, InvoiceNo.Text,
-1, varValueOfStock, NameOfStockValuer.Text, DateTime.Now, MethodOfValuation.Text, varFrequencyOfValuation,
varInsuranceCover_id, collateralId, Smart.GetEmployeeID(), varFrequencyOfValuation, "NULL"));
hiddenDetailsId.Text = collateralDetailsId.ToString();
//see if he filled the insurance form, then run the block of code that will do the insrt into insurance table
if (insuranceStatusId.SelectedValue == "1")
{
int varPeriodOfInsuranceCover = 0; double varAmountInsured = 0;
varPeriodOfInsuranceCover = Convert.ToInt32(StockPeriodOfInsuranceCover.Text);
varAmountInsured = Convert.ToDouble(StockAmountInsured.Text);
robotInsuranceTable.Insert(Convert.ToInt32(insuranceStatusId.SelectedValue), Convert.ToInt32(InsuranceCover_id.SelectedValue), collateralDetailsId, CollateralTypeId,
InsuranceCompany.Text, DateTime.Now, varPeriodOfInsuranceCover, varAmountInsured, StockKeyClause.Text, Smart.GetEmployeeID(), Convert.ToInt32(InsuranceCompany.SelectedValue));
}
else
{
robotInsuranceTable.Insert(Convert.ToInt32(insuranceStatusId.SelectedValue), null, collateralDetailsId, CollateralTypeId,
null, DateTime.Now, null, null, null, Smart.GetEmployeeID(), null);
}
//enable and move focus to next tab, disable current tab
ASPxPageControl1.TabPages[1].Enabled = true;
ASPxPageControl1.ActiveTabIndex = 1;
}
catch (Exception ex)
{
_errorMessageStock.Text = ex.Message;
}
}
protected void Page_Load(object sender, EventArgs e)
{
String collateraldetails_id = Request.QueryString["collateraldetails_id"];
int collateralId = Convert.ToInt32(Request.QueryString["collateralId"]);
int collateraldetailsid = Convert.ToInt32(Request.QueryString["collateraldetails_id"]);
int CollateralTypeId = Convert.ToInt32(Request.QueryString["CollateralTypeId"]);
//this code is for population of fields when update mode is set
RobotTableAdapters.CollateralType_StockHypoTableAdapter Engine = new RobotTableAdapters.CollateralType_StockHypoTableAdapter();
DataTable returnedData = Engine.getStockHypoById(Convert.ToInt32(collateraldetails_id));
if (!IsPostBack)
{
//insuranceStatusId.SelectedIndex = 1;
ASPxPageControl1.TabPages[0].Enabled = true;
ASPxPageControl1.TabPages[1].Enabled = true;
ASPxPageControl1.TabPages[2].Enabled = false;
ASPxPageControl1.TabPages[3].Enabled = false;
ASPxPageControl1.ActiveTabIndex = 0;
hiddenDetailsId.Text = collateraldetailsid.ToString();
//TextBOXES
InvoiceNo.Text = returnedData.Rows[0]["InvoiceNo"].ToString();
ValueOfStock_total.Text = returnedData.Rows[0]["ValueOfStock_total"].ToString();
// DateOfValuation.Text = returnedData.Rows[0]["DateOfValuation"].ToString();
DateTime dt;
dt = Convert.ToDateTime(returnedData.Rows[0]["DateOfValuation"].ToString());
DateOfValuation.Value = ((DateTime)dt).ToString("MM/dd/yyyy");
ListOfStock.Text = returnedData.Rows[0]["ListOfStock"].ToString();
NameOfStockValuer.Text = returnedData.Rows[0]["NameOfStockValuer"].ToString();
MethodOfValuation.Text = returnedData.Rows[0]["MethodOfValuation"].ToString();
FrequencyOfValuation.SelectedValue = returnedData.Rows[0]["ValuationID"].ToString();
//DROPDOWN
TypeOfStock_id.SelectedValue = returnedData.Rows[0]["TypeOfStock_id"].ToString();
// TypeOfStock_id.SelectedValue = returnedData.Rows[0]["TypeOfStock_id"].ToString();
if (returnedData.Rows[0]["documenttype_id"].ToString() != "-1")
{ documenttype_id.SelectedValue = returnedData.Rows[0]["documenttype_id"].ToString(); }
try
{
RobotTableAdapters.InsuranceTableAdapter InsuranceEngine = new RobotTableAdapters.InsuranceTableAdapter();
DataTable InsuranceData = InsuranceEngine.proc_getInsuranceById(Convert.ToInt32(collateraldetails_id), 3);
//TextBOXES
insuranceStatusId.SelectedValue = InsuranceData.Rows[0]["InsuranceStatus_id"].ToString();
InsuranceID.Value = InsuranceData.Rows[0]["Insurance_id"].ToString();
if (InsuranceData.Rows[0]["InsuranceStatus_id"].ToString() == "1" || InsuranceData.Rows[0]["InsuranceStatus_id"].ToString() == "3")
{
StockPeriodOfInsuranceCover.Text = InsuranceData.Rows[0]["PeriodOfInsuranceCover"].ToString();
StockKeyClause.Text = InsuranceData.Rows[0]["KeyClause"].ToString();
StockAmountInsured.Text = InsuranceData.Rows[0]["AmountInsured"].ToString();
// StockDateOfInsurance.Value = InsuranceData.Rows[0]["DateOfInsurance"].ToString();
DateTime dt1;
dt1 = Convert.ToDateTime(InsuranceData.Rows[0]["DateOfInsurance"].ToString());
StockDateOfInsurance.Value = ((DateTime)dt1).ToString("MM/dd/yyyy");
//DROPDOWNS
InsuranceCompany.SelectedValue = InsuranceData.Rows[0]["InsuranceCompany"].ToString();
InsuranceCover_id.SelectedValue = InsuranceData.Rows[0]["InsuranceCover_id"].ToString();
}
}
catch (Exception)
{
}
}
CheckBoxList1_Load();
}
