//protected void btnPost_Click(object sender, EventArgs e)
//{
// if (ObjGenral.IsPosted("FFIPDIBillMaster", "FPBillNo", txtBillingNo.Text.Trim(), string.Empty))
// {
// ObjGenral.UserMsg(lblMessage, Color.Red, "Already Posted cannot deleted !!!", null);
// return;
// }
// SqlParameter[] param = {
// new SqlParameter("@FPBillNo",SqlDbType. Char,8),//0
// new SqlParameter("@DealerCode", SqlDbType. Char,5)
// };
// param[0].Value = txtBillingNo.Text.Trim().ToString();
// param[1].Value = Session["DealerCode"].ToString();
// if (ObjGenral.ExecuteSP_NonQuery("sp_2W_Service_FFIPDI_UpdatePostFlag", param))
// {
// ObjGenral.UserMsg(lblMessage, Color.Green, txtBillingNo.Text + " is posted successflly", null);
// }
// else
// {
// ObjGenral.UserMsg(lblMessage, Color.Red, txtBillingNo.Text + " is not posted try again or contact to Pak suzuki help desk", null);
// }
//}
protected void btnDelete_Click(object sender, EventArgs e)
{
if (!sec.UserRight("2583", "004"))
{
Response.Redirect("~/Test.aspx");
}
if (ddlBillingNo.SelectedValue == "")
{
ObjGenral.UserMsg(lblMessage, Color.Red, "Please select any record to delete", null);
return;
}
else
{
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char, 5), //0
new SqlParameter("@FPBillNo", SqlDbType.Char, 8), //0
};
if (ObjGenral.IsPosted("JENBillMaster", "JENBillNo", ddlBillingNo.SelectedValue, string.Empty))
{
ObjGenral.UserMsg(lblMessage, Color.Red, "Already Posted cannot deleted !!!", null);
return;
}
else
{
//Akram
param[0].Value = Session["DealerCode"].ToString();
param[1].Value = ddlBillingNo.SelectedValue.Trim().ToString();
ObjGenral.ExecuteSP_NonQuery("sp_2W_Service_JENBill_Delete", param);
ObjGenral.UserMsg(lblMessage, Color.Red, "Record Has been deleted Sucessfully !!!", null);
ClearAll();
return;
}
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
SqlTransaction Trans = null;
bool Chek = false;
try
{
//TextBox[] textBoxes = { txtJobCardNo, txtCompletionDesc };
//if (!MasterValidation(textBoxes))
//{
// return;
//}
if (txtJobCardNo.Text.Trim() == "")
{
sysFuncs.UserMsg(lblMsg, Color.Red, "Jobcard No Can not be left blank ", null);
return;
}
if (txtCompletionDesc.Text.Trim() == "")
{
sysFuncs.UserMsg(lblMsg, Color.Red, "Complain Description Can not be left blank ", null);
return;
}
if (sysFuncs.IsPosted("PPRMaster", "PPRCode", ddlPRNo.SelectedValue, string.Empty))
{
sysFuncs.UserMsg(lblMsg, Color.Red, "Can not edit PPR already posted", null);
return;
}
//if (ddlPRNo.SelectedValue != "__/_____" && ddlPRNo.SelectedValue != "")
//{
// if (sysFuncs.IsExist("PPRCode", ddlPRNo.SelectedValue, "PPRMaster", string.Empty) == false)
// {
// lblMsg.Text = "Record dose not exist";
// //sysFuncs.UserMsg(lblMsg, Color.Red, "Record dose not exist", ddlPRNo);
// return;
// }
//}
if (dtProblemDate.Text.Trim() == string.Empty)
{
sysFuncs.UserMsg(lblMsg, Color.Red, "Problem date should not be left blank.", null);
dtProblemDate.Focus();
return;
}
if (dtComplitionDate.Text.Trim() == string.Empty)
{
sysFuncs.UserMsg(lblMsg, Color.Red, "Completion date should not be left blank.", null);
dtComplitionDate.Focus();
return;
}
if (ddlComplains.SelectedIndex == 0)
{
sysFuncs.UserMsg(lblMsg, Color.Red, "Complain Code should not be left blank.");
return;
}
if (ddlDefect.SelectedIndex == 0)
{
sysFuncs.UserMsg(lblMsg, Color.Red, "Defect Code should not be left blank.");
return;
}
if (ObjTrans.BeginTransaction(ref Trans) == false)
{
return;
}
if (InsertPPRMaster(Trans))
{
Chek = true;
if (InsertPPRDetail(Trans))
{
Chek = true;
}
else
{
Chek = false;
}
if (Chek == true)
{
//dtParts = (DataTable)ViewState["PartsDataTable"];
dtParts = (DataTable)Session["PartsDetailsDS"];
foreach (DataRow dtRow in dtParts.Rows)
{
if (InsertPPRPartsDetail(dtRow, Trans))
{
Chek = true;
}
else
{
Chek = false;
break;
}
}
}
}
else
{
ObjTrans.RollBackTransaction(ref Trans);
}
if (Chek == true)
{
ObjTrans.CommittTransaction(ref Trans);
lblMsg.Visible = true;
sysFuncs.UserMsg(lblMsg, Color.Green, "Saved Successfully Last Code '" + ddlPRNo.SelectedValue + "'");
ClearAll();
}
}
catch (Exception ex)
{
ObjTrans.RollBackTransaction(ref Trans);
//SendAlert("Error : " + ex.Message);
lblMsg.Visible = true;
lblMsg.Text = ex.Message;
}
}
