public void btnSave_Click(object sender, EventArgs e)
{
if (!sec.UserRight("2542", "002"))
{
Response.Redirect("~/Test.aspx");
}
if (Convert.ToDateTime(myFunc.SaveDate(txtDCDate.Text)).Date > Convert.ToDateTime(DateTime.Now.Date.ToString("yyyy-MM-dd")).Date)
{
myFunc.UserMsg(lblMessage, Color.Red, "DC Date should not greater then current date.");
return;
}
if (Convert.ToDateTime(myFunc.SaveDate(txtDCDate.Text)).Date < Convert.ToDateTime(myFunc.SaveDate(txtPODate.Text)).Date)
{
myFunc.UserMsg(lblMessage, Color.Red, "DC Date should not less then PO Date.");
return;
}
if (txtVendorDCn0.Text == "")
{
myFunc.UserMsg(lblMessage, Color.Red, "Please enter vendor DC Number.");
return;
}
if (gv_DC.Rows.Count == 0)
{
lblMessage.ForeColor = Color.Red;
lblMessage.Text = "Please Select PO Number.";
return;
}
string newDCNo = "";
if (ddlDCno.SelectedValue == "0")
{
//newDCNo = myFunc.GetNewDCNumber(this.Session["DealerCode"].ToString());
newDCNo = myFunc.AutoGen("DCMaster", "DCNo", DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("dd/MM/yyyy"));
}
else
{
if (ddlDCno.SelectedValue != "")
{
if (!sec.UserRight("2542", "003"))
{
Response.Redirect("~/Test.aspx");
}
newDCNo = ddlDCno.SelectedValue;
}
else
{
newDCNo = this.Session["DCNumber"].ToString();
}
}
string sql = "";
if (myFunc.isDCExist(newDCNo, Session["DealerCode"].ToString()))
{
sql = "UPDATE DCMaster SET VendorDCNo='" + txtVendorDCn0.Text + "',Remarks='" + txtRemarks.Text + "' where DCNo='" + newDCNo + "' and DealerCode = '" + Session["DealerCode"].ToString() + "'";
}
else
{
sql = "INSERT INTO DCMaster (DealerCode,DCNo,DCDate,PONo,VendorDCNo,VendorCode,Remarks,DelFlag,UpdUser,UpdDate,UpdTime)";
sql += " VALUES ('" + this.Session["DealerCode"].ToString() + "','" + newDCNo + "','" + myFunc.SaveDate(txtDCDate.Text) + "','" + ddlPONo.SelectedValue + "','";
sql += txtVendorDCn0.Text.Trim() + "','" + txtVendor.Text + "','" + txtRemarks.Text.Trim() + "','N','" + this.Session["UserID"].ToString() + "',";
sql += "CURRENT_TIMESTAMP,CURRENT_TIMESTAMP)";
}
try
{
int slct = 0;
if (ObjTrans.BeginTransaction(ref Trans) == true)
{
myFunc.ExecuteQuery_NonQuery(sql, Trans);
// save detail
RemoveQTYFromPO(newDCNo, "-");
sql = "delete from DCDetail where DCNo ='" + newDCNo + "' and DealerCode = '" + Session["DealerCode"].ToString() + "'";
myFunc.ExecuteQuery_NonQuery(sql, Trans);
DataTable dt = (DataTable)Session["DCTable"];
string ItemCode = "";
int i = 0;
foreach (GridViewRow row in gv_DC.Rows)
{
CheckBox chkSelect = (CheckBox)row.FindControl("cbSelect");
if (chkSelect.Checked)
{
ItemCode = myFunc.GetItemCodeByPartItemNo(dt.Rows[i]["PartItemNo"].ToString(), Session["DealerCode"].ToString());
sql = "INSERT INTO DCDetail (DealerCode, DCNo, ItemCode, PONo, POQty, BalQty, DCQty)";
sql += " VALUES('" + this.Session["DealerCode"].ToString() + "','" + newDCNo + "','" + ItemCode + "','" + ddlPONo.SelectedValue + "','";
sql += dt.Rows[i]["POQuantity"].ToString() + "','" + dt.Rows[i]["BalanceQuantity"].ToString() + "','" + dt.Rows[i]["DCQuantity"].ToString() + "')";
myFunc.ExecuteQuery_NonQuery(sql, Trans);
slct++;
}
i++;
}
}
else
{
ObjTrans.RollBackTransaction(ref Trans);
}
//Commented By Uzair
//for (int i = 0; i < dt.Rows.Count; i++)
//{
// slct = dt.Rows[i]["Selected"].ToString();
// if (slct == "True")
// {
// ItemCode = myFunc.GetItemCodeByPartItemNo(dt.Rows[i]["PartItemNo"].ToString());
// sql = "INSERT INTO DCDetail (DealerCode, DCNo, ItemCode, PONo, POQty, BalQty, DCQty)";
// sql += " VALUES('" + this.Session["DealerCode"].ToString() + "','" + newDCNo + "','" + ItemCode + "','" + ddlPONo.SelectedValue + "','";
// sql += dt.Rows[i]["POQuantity"].ToString() + "','" + dt.Rows[i]["BalanceQuantity"].ToString() + "','" + dt.Rows[i]["DCQuantity"].ToString() + "')";
// myFunc.GetData(sql);
// }
//}
if (slct > 0)
{
ObjTrans.CommittTransaction(ref Trans);
RemoveQTYFromPO(newDCNo, "+");
lblMessage.ForeColor = Color.Green;
lblMessage.Text = newDCNo + " has been saved";
ScriptManager.RegisterClientScriptBlock(Page, typeof(Page), "ClientScript", "alert('Record Saved,Updated Successfully: " + newDCNo + "')", true);
ClearAll();
lOADddl();
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "Savealert()", true);
}
else
{
ObjTrans.RollBackTransaction(ref Trans);
lblMessage.ForeColor = Color.Red;
lblMessage.Text = "At least one row should be selected";
}
}
catch (Exception)
{
ObjTrans.RollBackTransaction(ref Trans);
}
//ddDCNumber.Text = newDCNo;
}
private void Save_InsertMasterDetail(SqlTransaction Trans, string strIssueDate, string strReqSource, string strJobCardNO, string strInvoiceNo, ref bool Check, ref string StrReturnNo)
{
string StrIssueDate = "";
try
{
StrIssueDate = txtRetDate.Text;
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char, 5), //0
new SqlParameter("@ReturnNo", SqlDbType.Char, 8), //1
new SqlParameter("@ReturnDate", SqlDbType.DateTime), //2
new SqlParameter("@IssueNo", SqlDbType.Char, 8), //3
new SqlParameter("@ReqSource", SqlDbType.VarChar, 10), //4
new SqlParameter("@JobCardNO", SqlDbType.Char, 8), //5
new SqlParameter("@InvoiceNo", SqlDbType.Char, 8), //6
new SqlParameter("@Remarks", SqlDbType.VarChar, 70), //7
new SqlParameter("@UpdUser", SqlDbType.VarChar, 50), //8
new SqlParameter("@UpdTerm", SqlDbType.VarChar, 50), //9
};
param[0].Value = Session["DealerCode"].ToString();
param[1].Value = SysFunc.AutoGen("StockReturn", "ReturnNo", txtRetDate.Text.Trim());;
param[2].Value = SysFunc.SaveDate(txtRetDate.Text);
param[3].Value = ddlIssueNo.SelectedValue.ToString().Trim();
param[4].Value = strReqSource.Trim();
param[5].Value = strJobCardNO.Trim();
param[6].Value = strInvoiceNo.Trim();
param[7].Value = txtRemarks.Text.Replace("'", " ");
param[8].Value = Session["UserName"].ToString();
param[9].Value = GlobalVar.mUserIPAddress;;
if (SysFunc.ExecuteSP_NonQuery("sp_W2_StockReturne_Insert", param, Trans))
{
StrReturnNo = param[1].Value.ToString();
for (int i = 0; i < GvMain.Rows.Count; i++)
{
SqlParameter[] param1 =
{
new SqlParameter("@DealerCode", SqlDbType.Char), //0
new SqlParameter("@ReturnNo", SqlDbType.Char, 8), //1
new SqlParameter("@ItemCode", SqlDbType.Char, 8), //2
new SqlParameter("@IssueNo", SqlDbType.Char, 8), //3
new SqlParameter("@PartsTransLocCode", SqlDbType.VarChar, 7), //4
new SqlParameter("@ReturnQty", SqlDbType.Float), //5
new SqlParameter("@Rate", SqlDbType.Float), //6
new SqlParameter("@Amount", SqlDbType.Float) //7
};
Label LbItemCode = (Label)GvMain.Rows[i].FindControl("LbItemCode");
Label LbPartsTransLocCode = (Label)GvMain.Rows[i].FindControl("LbPartsTransLocCode");
HiddenField HDPartsTransLocCode = (HiddenField)GvMain.Rows[i].FindControl("HDPartsTransLocCode");
Label LbRetQty = (Label)GvMain.Rows[i].FindControl("LbRetQty");
Label LbAmount = (Label)GvMain.Rows[i].FindControl("LbAmount");
Label LbRate = (Label)GvMain.Rows[i].FindControl("LbRate");
param1[0].Value = Session["DealerCode"].ToString();
param1[1].Value = StrReturnNo;
param1[2].Value = LbItemCode.Text;
param1[3].Value = ddlIssueNo.SelectedValue.ToString().Trim();
param1[4].Value = HDPartsTransLocCode.Value;
param1[5].Value = LbRetQty.Text;
param1[6].Value = LbRate.Text;
param1[7].Value = LbAmount.Text;
if (SysFunc.ExecuteSP_NonQuery("sp_W2_StockReturneDetail_Insert", param1, Trans))
{
Check = true;
}
else
{
Check = false;
break;
}
}
}
}
catch (Exception ex)
{
LbErr.Text = ex.Message;
}
}
private void Save_InsertMasterDetail(SqlTransaction Trans, ref bool Check)
{
//Trans = null;
//Check = false;
string StrIssueDate = "";
try
{
//if (GvMain.Rows.Count == 0)
//{
// ObjGeneral.UserMsg(LbErr, Color.Red, "At least one part must be add...", txtPartItem);
// return;
//}
//else
//{
// LbErr.Text = "";
//}
StrIssueDate = txtIssueDate.Text;
int IssueDate = Convert.ToInt32(txtIssueDate.Text.Substring(6, 4) + txtIssueDate.Text.Substring(3, 2) + txtIssueDate.Text.Substring(0, 2));
int SIRDate = Convert.ToInt32(txtSIRDate.Text.Substring(6, 4) + txtSIRDate.Text.Substring(3, 2) + txtSIRDate.Text.Substring(0, 2));
if (txtSource.Text == "J")
{
if (IssueDate < SIRDate)
{
SysFunc.UserMsg(LbErr, Color.Red, "Issuance date should not be less than jobcard date...", txtIssueDate);
return;
}
else
{
LbErr.Text = "";
}
}
if (txtSource.Text == "C")
{
if (IssueDate < SIRDate)
{
SysFunc.UserMsg(LbErr, Color.Red, "Issuance date should not be less than counter sale date...", txtIssueDate);
return;
}
else
{
LbErr.Text = "";
}
}
//if (ObjTrans.BeginTransaction(ref Trans) == false)
//{
// return;
//}
//if (ObjGeneral.IsPosted("StockIssue", "IssueNo", txtIssueNo.Text) == true)
//{
// ObjGeneral.UserMsg(LbErr, Color.Red, "The Issuance is already posted; now you could not change/delete/Post the record...", txtIssueNo);
// return;
//}
//else
//{
// LbErr.Text = "";
//}
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char), //0
new SqlParameter("@IssueNo", SqlDbType.Char), //1
new SqlParameter("@IssueDate", SqlDbType.DateTime), //2
new SqlParameter("@SIRNo", SqlDbType.Char), //3
new SqlParameter("@ReqSource", SqlDbType.VarChar), //4
new SqlParameter("@JobCardNO", SqlDbType.Char), //5
new SqlParameter("@InvoiceNo", SqlDbType.Char), //6
new SqlParameter("@Remarks", SqlDbType.VarChar), //7
new SqlParameter("@UpdUser", SqlDbType.VarChar), //8
//new SqlParameter("@UpdDate",SqlDbType.DateTime),//9
//new SqlParameter("@UpdTime",SqlDbType.DateTime),//10
new SqlParameter("@UpdTerm", SqlDbType.VarChar), //11
};
param[0].Value = Session["DealerCode"].ToString();
strIssueNo = SysFunc.AutoGen("StockIssue", "IssueNo", txtIssueDate.Text.Trim());
param[1].Value = strIssueNo;
param[2].Value = SysFunc.SaveDate(txtIssueDate.Text);;
param[3].Value = ddlSirNo.SelectedValue.ToString().Trim();
param[4].Value = txtSource.Text;
if (txtSource.Text == "J")
{
param[5].Value = txtJC_CS_No.Text;
param[6].Value = (Object)DBNull.Value;
}
else if (txtSource.Text == "C")
{
param[5].Value = (Object)DBNull.Value;
param[6].Value = txtJC_CS_No.Text;
}
param[7].Value = txtRemarks.Text.Replace("'", " ");
param[8].Value = Session["UserName"].ToString();
//param[9].Value = ObjGeneral.SaveDate(DateTime.Now.ToString("dd/MM/yyyy"));
//param[10].Value = ObjGeneral.SaveDate(DateTime.Now.ToString("dd/MM/yyyy"));
param[9].Value = GlobalVar.mUserIPAddress;
if (SysFunc.SP_Parts_Insert_StockIssue(Trans, param))
{
foreach (GridViewRow gvr in GvMain.Rows)
{
CheckBox chkSelect = (CheckBox)gvr.Cells[0].FindControl("ChkSelect");
if (chkSelect.Checked)
{
SqlParameter[] param1 =
{
new SqlParameter("@DealerCode", SqlDbType.Char), //0
new SqlParameter("@IssueNo", SqlDbType.Char), //1
new SqlParameter("@ItemCode", SqlDbType.Char), //2
new SqlParameter("@SIRNo", SqlDbType.Char), //3
new SqlParameter("@PartsTransLocCode", SqlDbType.Char), //4
new SqlParameter("@IssueQty", SqlDbType.Float), //5
new SqlParameter("@Rate", SqlDbType.Float), //6
new SqlParameter("@Amount", SqlDbType.Float) //7
};
//Label LbItemCode = (Label)GvMain.Rows[i].FindControl("LbItemCode");
DropDownList ddlLocation = (DropDownList)gvr.FindControl("ddlLocation");
//HiddenField HDPartsTransLocCode = (HiddenField)GvMain.Rows[i].FindControl("HDPartsTransLocCode");
TextBox txtIssueQty = (TextBox)gvr.FindControl("txtIssueQty");
Label lblAvgCost = (Label)gvr.FindControl("lblAvgCost");
Label LbAmount = (Label)gvr.FindControl("LbAmount");
param1[0].Value = Session["DealerCode"].ToString();
param1[1].Value = strIssueNo;
param1[2].Value = gvr.Cells[1].Text.Trim();
param1[3].Value = ddlSirNo.SelectedValue.ToString();
param1[4].Value = ddlLocation.SelectedValue.ToString();
param1[5].Value = txtIssueQty.Text.Trim();
param1[6].Value = lblAvgCost.Text;
param1[7].Value = LbAmount.Text;
if (SysFunc.Sp_Parts_Insert_StockIssueDetail(Trans, param1))
{
Check = true;
}
else
{
Check = false;
break;
}
}
}
}
}
catch (Exception ex)
{
//ObjTrans.RollBackTransaction(ref Trans);
SysFunc.UserMsg(LbErr, Color.Red, ex.Message);
}
}
private void JobCardEntry()
{ /////////////////
if (txtSRNo.Text.Trim() == string.Empty)
{
txtSRNo.Text = sysfuncs.AutoGen("FIRMaster", "FIRCode", DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("dd/MM/yyyy"));
}
#region JobCard Master Param
SqlParameter[] JobCardMaster_param =
{
/*0*/ new SqlParameter("@DealerCode", SqlDbType.Char, 5),
/*1*/ new SqlParameter("@FIRCode", SqlDbType.VarChar, 8),
/*2*/ new SqlParameter("@FIRDate", SqlDbType.DateTime),
/*3*/ new SqlParameter("@Subject", SqlDbType.VarChar, 100),
/*4*/ new SqlParameter("@RegNo", SqlDbType.VarChar, 15),
/*5*/ new SqlParameter("@ChassisNo", SqlDbType.VarChar, 30),
/*6*/ new SqlParameter("@EngineNo", SqlDbType.VarChar, 30),
/*7*/ new SqlParameter("@CusComment", SqlDbType.VarChar, 400),
/*8*/ new SqlParameter("@KM", SqlDbType.Char, 8),
/*9*/ new SqlParameter("@ProblemDate", SqlDbType.DateTime),
/*10*/ new SqlParameter("@ItemCode", SqlDbType.Char, 25),
/*11*/ new SqlParameter("@VendorCode", SqlDbType.Char, 6),
/*12*/ new SqlParameter("@Defect", SqlDbType.VarChar, 100),
/*13*/ new SqlParameter("@Problem", SqlDbType.VarChar, 100),
/*14*/ new SqlParameter("@CorrectiveAction", SqlDbType.VarChar, 100),
/*15*/ new SqlParameter("@DelFlag", SqlDbType.Char, 1),
/*16*/ new SqlParameter("@UpdUser", SqlDbType.Char, 50),
/*17*/ new SqlParameter("@UpdTerm", SqlDbType.Char, 50),
/*18*/ new SqlParameter("@Pic1", SqlDbType.VarChar, 200),
/*19*/ new SqlParameter("@Part1", SqlDbType.Char, 8),
/*20*/ new SqlParameter("@Part2", SqlDbType.Char, 8),
/*21*/ new SqlParameter("@Part3", SqlDbType.Char, 8),
/*22*/ new SqlParameter("@Part4", SqlDbType.Char, 8),
/*23*/ new SqlParameter("@InspDate", SqlDbType.DateTime),
/*24*/ new SqlParameter("@Status", SqlDbType.VarChar, 30),
/*25*/ new SqlParameter("@Result", SqlDbType.VarChar, 30),
/*26*/ new SqlParameter("@RoNo", SqlDbType.VarChar, 10),
/*27*/ new SqlParameter("@RoDate", SqlDbType.DateTime),
/*28*/ new SqlParameter("@PartAttach", SqlDbType.Char, 1),
/*29*/ new SqlParameter("@followupdate", SqlDbType.DateTime),
/*30*/ new SqlParameter("@Request", SqlDbType.VarChar, 200),
/*31*/ new SqlParameter("@KeyNo", SqlDbType.VarChar, 15),
/*31*/ new SqlParameter("@SerialNo", SqlDbType.Char, 8)
};
JobCardMaster_param[0].Value = Session["DealerCode"].ToString();
JobCardMaster_param[2].Value = sysfunc.SaveDate(txtDate.Text.Trim());
JobCardMaster_param[3].Value = txtSubject.Text.Trim();
JobCardMaster_param[4].Value = txtRegNo.Text.Trim().ToUpper();
JobCardMaster_param[5].Value = ddlVinNo.SelectedValue.ToString().Trim();
JobCardMaster_param[6].Value = txtEngineNo.Text.Trim();
JobCardMaster_param[7].Value = txtCustComp.Text.Trim();
JobCardMaster_param[8].Value = txtKM.Text.Trim().ToUpper();
JobCardMaster_param[9].Value = sysfunc.SaveDate(txtFailureDate.Text);
JobCardMaster_param[10].Value = txtFailedPart.Text.Trim();
JobCardMaster_param[11].Value = Session["DealerCode"].ToString();
if (RadioButton1.Checked)
{
JobCardMaster_param[12].Value = "Y";
}
else
{
JobCardMaster_param[12].Value = "N";
}
JobCardMaster_param[13].Value = txtPrblmCause.Text.Trim();
JobCardMaster_param[14].Value = txtCorAction.Text.Trim();
JobCardMaster_param[15].Value = "N";
if (Session["UserName"] == null)
{
JobCardMaster_param[16].Value = "";
}
else
{
JobCardMaster_param[16].Value = Session["UserName"].ToString().Trim();
}
JobCardMaster_param[16].Value = Session["UserName"].ToString().Trim();
JobCardMaster_param[17].Value = GlobalVar.mUserIPAddress;
if (Session["Sketch"].ToString() == null || Session["Sketch"].ToString().Trim() == "" || Session["Sketch"] == null)
{
JobCardMaster_param[18].Value = "";
}
else
{
JobCardMaster_param[18].Value = Session["Sketch"].ToString().Trim();
}
JobCardMaster_param[19].Value = txtPart1.Text.Trim();
JobCardMaster_param[20].Value = txtPart2.Text.Trim();
JobCardMaster_param[21].Value = txtPart3.Text.Trim();
JobCardMaster_param[22].Value = txtPart4.Text.Trim();
JobCardMaster_param[23].Value = sysfunc.SaveDate(txtInspDate.Text.Trim());
JobCardMaster_param[24].Value = ddlStatus.SelectedValue.Trim();
JobCardMaster_param[25].Value = ddlResult.SelectedValue.Trim();
JobCardMaster_param[26].Value = txtRoNo.Text.Trim();
JobCardMaster_param[27].Value = sysfunc.SaveDate(txtRepairDate.Text.Trim());
if (RadioButton3.Checked)
{
JobCardMaster_param[28].Value = "Y";
}
else
{
JobCardMaster_param[28].Value = "N";
}
JobCardMaster_param[29].Value = sysfunc.SaveDate(txtFollowUpDate.Text);
JobCardMaster_param[30].Value = txtRequest.Text.Trim();
JobCardMaster_param[31].Value = txtKeyNo.Text.Trim();
JobCardMaster_param[32].Value = txtSerial.Text.Trim();
#endregion
try
{
if (ObjTrans.BeginTransaction(ref Trans) == true)
{
DataSet dsJc = new DataSet();
if (ddlDRNo.SelectedIndex == 0)
{
JobCardMaster_param[1].Value = sysfuncs.AutoGen("FIRMaster", "FIRCode", DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("dd/MM/yyyy")); //txtReferenceNo.Text;
HFJobCard.Value = JobCardMaster_param[1].Value.ToString();
sysfunc.ExecuteSP_NonQuery("[sp_FIRMaster_Insert]", JobCardMaster_param, Trans);
}
else
{
JobCardMaster_param[1].Value = ddlDRNo.SelectedValue.ToString().Trim();
HFJobCard.Value = JobCardMaster_param[1].Value.ToString();
sysfunc.ExecuteSP_NonQuery("[sp_UpdateFIRMasterFull]", JobCardMaster_param, Trans);
}
if (ObjTrans.CommittTransaction(ref Trans) == true)
{
sysfunc.UserMsg(lblMsg, Color.Green, "Record Saved Successfully: " + HFJobCard.Value);
}
else
{
ObjTrans.RollBackTransaction(ref Trans);
sysfunc.UserMsg(lblMsg, Color.Red, "Record not saved Try again. Or contact to support team ");
}
clearAll();
}
}
catch (Exception ex)
{
sysfunc.UserMsg(lblMsg, Color.Red, "Error: " + ex.Message, txtSRNo);
ObjTrans.RollBackTransaction(ref Trans);
}
}
protected void BtnSave_Click(object sender, EventArgs e)
{
if (!sec.UserRight("2544", "002"))
{
Response.Redirect("~/Test.aspx");
}
SqlTransaction Trans = null;
bool Chek = false;
bool chkSelectRow = false;
string strPurInvNo = string.Empty;
try
{
if (ddlPayInvNo.SelectedIndex > 0)
{
if (!sec.UserRight("2544", "003"))
{
Response.Redirect("~/Test.aspx");
}
SysFunc.UserMsg(LbErr, Color.Red, "Update not allowd please delete and save again");
return;
}
if (ddlVendor.SelectedIndex == 0)
{
SysFunc.UserMsg(LbErr, Color.Red, "Select Vendor");
return;
}
if (ddlGRN.SelectedIndex == 0)
{
SysFunc.UserMsg(LbErr, Color.Red, "Select GRN Number.");
return;
}
if (txtPrincipalInvNo.Text.Trim() == string.Empty)
{
SysFunc.UserMsg(LbErr, Color.Red, "Principal Inv No can not be empty");
return;
}
if (txtPayInvDate.Text.Trim() == string.Empty)
{
SysFunc.UserMsg(LbErr, Color.Red, "Principal Inv Date can not be empty");
return;
}
if (txtOrder.Text.Trim() == string.Empty)
{
SysFunc.UserMsg(LbErr, Color.Red, "Order No can not be empty");
return;
}
foreach (GridViewRow gvr in gvPurInvDetail.Rows)
{
CheckBox chkSelect = (CheckBox)gvr.Cells[0].FindControl("chkSelect");
//TextBox txtPayableQty = (TextBox)gvr.Cells[6].FindControl("txtPayableQty");
if (chkSelect.Checked == true)
{
chkSelectRow = true;
break;
}
else
{
chkSelectRow = false;
}
}
if (chkSelectRow == false)
{
SysFunc.UserMsg(LbErr, Color.Red, "Select Rows from list");
return;
}
foreach (GridViewRow gvr in gvPurInvDetail.Rows)
{
CheckBox chkSelect = (CheckBox)gvr.Cells[0].FindControl("chkSelect");
TextBox txtPayableQty = (TextBox)gvr.Cells[6].FindControl("txtPayableQty");
decimal dtxtPayableQty = Convert.ToDecimal(txtPayableQty.Text == "" ? "0" : txtPayableQty.Text);
decimal dAccQty = Convert.ToDecimal(gvr.Cells[4].Text.Trim());
decimal dPaidQty = Convert.ToDecimal(gvr.Cells[5].Text.Trim());
decimal dRemainingQty = dAccQty - dPaidQty;
if (chkSelect.Checked == true && dtxtPayableQty == 0)
{
SysFunc.UserMsg(LbErr, Color.Red, "Payable quantity can not be Zero(0) or empty.");
return;
}
if (chkSelect.Checked == true && dtxtPayableQty > dRemainingQty)
{
chkSelect.Checked = false;
SysFunc.UserMsg(LbErr, Color.Red, "Remaining payable Qty is " + dRemainingQty + " you can not enter greater then Remaining Qty");
return;
}
}
if (ObjTrans.BeginTransaction(ref Trans) == false)
{
return;
}
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char, 5), //0
new SqlParameter("@PurInvNo", SqlDbType.Char, 8), //1
new SqlParameter("@PurInvDate", SqlDbType.DateTime), //2
new SqlParameter("@VendorCode", SqlDbType.Char, 6), //3
new SqlParameter("@GRNNo", SqlDbType.Char, 8), //4
new SqlParameter("@VendorInvNo", SqlDbType.VarChar, 20), //5
new SqlParameter("@VendorInvDate", SqlDbType.DateTime), //6
new SqlParameter("@OrderNo", SqlDbType.VarChar, 20), //7
new SqlParameter("@DiscountAmt", SqlDbType.Decimal), //8
new SqlParameter("@Remarks", SqlDbType.VarChar, 70), //9
new SqlParameter("@TotalAmt", SqlDbType.Decimal), //10
new SqlParameter("@TotPayment", SqlDbType.Decimal), //11
new SqlParameter("@UpdUser", SqlDbType.VarChar), //12
new SqlParameter("@UpdTerm", SqlDbType.VarChar), //13
new SqlParameter("@TotPaidQty", SqlDbType.Int), //14
new SqlParameter("@GSTPercent", SqlDbType.Decimal), //15
new SqlParameter("@GSTTotal", SqlDbType.Decimal), //16
new SqlParameter("@ExTaxPercent", SqlDbType.Decimal), //17
new SqlParameter("@ExTaxTotal", SqlDbType.Decimal), //18
new SqlParameter("@FurTaxPercent", SqlDbType.Decimal), //19
new SqlParameter("@FurTaxTotal", SqlDbType.Decimal), //20
new SqlParameter("@TotalIncTax", SqlDbType.Decimal), //21
};
param[0].Value = Session["DealerCode"].ToString();
if (ddlPayInvNo.SelectedIndex == 0)
{
strPurInvNo = SysFunc.AutoGen("PurInvMaster", "PurInvNo", DateTime.Parse(SysFunc.SaveDate(txtPayInvDate.Text).ToString()).ToString("dd-MM-yyyy"));
}
else
{
if (!sec.UserRight("2544", "003"))
{
Response.Redirect("~/Test.aspx");
}
strPurInvNo = ddlPayInvNo.SelectedValue;
}
param[1].Value = strPurInvNo.Trim();
param[2].Value = SysFunc.SaveDate(txtPayInvDate.Text);
param[3].Value = ddlVendor.SelectedValue.ToString().Trim();
param[4].Value = ddlGRN.SelectedValue.ToString().Trim();
param[5].Value = txtPrincipalInvNo.Text.Trim(); //txtRemarks.Text.Trim().Replace(",", " ");
param[6].Value = SysFunc.SaveDate(txtPrincipalInvDate.Text); //Convert.ToDecimal((lblFooterTotalAmt.Text == "" ? "0" : lblFooterTotalAmt.Text));
param[7].Value = txtOrder.Text.Trim();
param[8].Value = Convert.ToDecimal(ViewState["TotalDiscount"].ToString() == "" ? "0" : ViewState["TotalDiscount"].ToString());
param[9].Value = txtRemarks.Text.Trim().Replace(",", " ");
param[10].Value = Convert.ToDecimal(ViewState["TotalAmt"].ToString() == "" ? "0" : ViewState["TotalAmt"].ToString());
param[11].Value = "0";//Convert.ToDecimal(ViewState["TotalAmt"].ToString() == "" ? "0" : ViewState["TotalAmt"].ToString());
param[12].Value = Session["UserName"].ToString();
param[13].Value = GlobalVar.mUserIPAddress.ToString();
param[14].Value = Convert.ToDecimal(ViewState["TotalPaidQty"].ToString() == "" ? "0" : ViewState["TotalPaidQty"].ToString());
param[15].Value = Convert.ToDecimal(lblGstPerc.Text.Trim().Replace("%", ""));
param[16].Value = Convert.ToDecimal(txtGstAmt.Text.Trim() == "" ? "0" : txtGstAmt.Text.Trim());
param[17].Value = Convert.ToDecimal(lblExTaxPerc.Text.Trim().Replace("%", ""));
param[18].Value = Convert.ToDecimal(txtExTaxAmt.Text.Trim() == "" ? "0" : txtExTaxAmt.Text.Trim());
param[19].Value = Convert.ToDecimal(lblFurTaxPerc.Text.Trim().Replace("%", ""));
param[20].Value = Convert.ToDecimal(txtFurTaxAmt.Text.Trim() == "" ? "0" : txtFurTaxAmt.Text.Trim());
param[21].Value = Convert.ToDecimal(txtTotalAmt.Text.Trim() == "" ? "0" : txtTotalAmt.Text.Trim());
if (SysFunc.sp_PurInvMaster_Insert(Trans, param))
{
foreach (GridViewRow gvr in gvPurInvDetail.Rows)
{
TextBox txtPayableQty = (TextBox)gvr.Cells[6].FindControl("txtPayableQty");
Label lblDiscountAmt = (Label)gvr.Cells[9].FindControl("lblDiscountAmt");
Label lblGrossAmt = (Label)gvr.Cells[10].FindControl("lblGrossAmt");
CheckBox chkSelect = (CheckBox)gvr.Cells[0].FindControl("chkSelect");
if (chkSelect.Checked)
{
SqlParameter[] param1 =
{
new SqlParameter("@DealerCode", SqlDbType.Char, 10), //0
new SqlParameter("@GRNNo", SqlDbType.Char, 8), //1
new SqlParameter("@PurInvNo", SqlDbType.Char, 8), //2
new SqlParameter("@ItemCode", SqlDbType.Char, 8), //3
new SqlParameter("@AccQty", SqlDbType.Decimal), //4
new SqlParameter("@paidQty", SqlDbType.Decimal), //5
new SqlParameter("@Rate", SqlDbType.Decimal), //6
new SqlParameter("@DiscountAmt", SqlDbType.Decimal), //7
new SqlParameter("@Amount", SqlDbType.Decimal), //8
new SqlParameter("@DiscountPerc", SqlDbType.Decimal), //9
};
param1[0].Value = Session["DealerCode"].ToString();
param1[1].Value = ddlGRN.SelectedValue.ToString();
param1[2].Value = strPurInvNo;
param1[3].Value = gvr.Cells[1].Text.Trim();
param1[4].Value = Convert.ToDecimal(gvr.Cells[4].Text.Trim() == "" ? "0" : gvr.Cells[4].Text.Trim());
param1[5].Value = Convert.ToDecimal(txtPayableQty.Text.Trim() == "" ? "0" : txtPayableQty.Text.Trim());
param1[6].Value = Convert.ToDecimal(gvr.Cells[7].Text.Trim() == "" ? "0" : gvr.Cells[7].Text.Trim());
param1[7].Value = Convert.ToDecimal(lblDiscountAmt.Text.Trim() == "" ? "0" : lblDiscountAmt.Text.Trim());
param1[8].Value = Convert.ToDecimal(lblGrossAmt.Text.Trim() == "" ? "0" : lblGrossAmt.Text.Trim());
param1[9].Value = Convert.ToDecimal(gvr.Cells[8].Text.Trim() == "" ? "0" : gvr.Cells[8].Text.Trim());
if (SysFunc.sp_PurInvDetail_Insert(Trans, param1))
{
Chek = true;
}
else
{
Chek = false;
break;
}
}
}
if (Chek == false)
{
ObjTrans.RollBackTransaction(ref Trans);
SysFunc.UserMsg(LbErr, Color.Red, "Recored not saved try again ");
}
else
{
ObjTrans.CommittTransaction(ref Trans);
SysFunc.UserMsg(LbErr, Color.Green, "Saved Successfully Sales Invoice No. " + strPurInvNo);
ScriptManager.RegisterClientScriptBlock(Page, typeof(Page), "ClientScript", "alert('Record Saved,Updated Successfully: " + strPurInvNo + "')", true);
btnClear_Click(BtnSave, EventArgs.Empty);
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "Savealert()", true);
}
}
}
catch (Exception ex)
{
ObjTrans.RollBackTransaction(ref Trans);
SysFunc.UserMsg(LbErr, Color.Red, ex.Message);
}
}
private bool InsertPPRMaster(SqlTransaction Trans)
{
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char, 5), //0
new SqlParameter("@PPRCode", SqlDbType.Char, 8), //1
new SqlParameter("@JobCardCode", SqlDbType.Char, 8), //2
new SqlParameter("@PPRDate", SqlDbType.DateTime), //3
new SqlParameter("@CusCode", SqlDbType.Char, 8), //4
new SqlParameter("@UserName", SqlDbType.Char, 75), //5
new SqlParameter("@UserAddress1", SqlDbType.VarChar, 100), //6
new SqlParameter("@UserPhoneNo", SqlDbType.Char, 50), //7
new SqlParameter("@VehEngineNo", SqlDbType.VarChar, 30), //8
new SqlParameter("@VehChassisNo", SqlDbType.VarChar, 30), //9
new SqlParameter("@VehRegNo", SqlDbType.Char, 15), //10
new SqlParameter("@InvoiceDate", SqlDbType.DateTime), //11
new SqlParameter("@MeterReadingKM", SqlDbType.Char, 5), //12
new SqlParameter("@DateOfProblem", SqlDbType.DateTime), //13
new SqlParameter("@RoadCondition", SqlDbType.Char, 10), //14
new SqlParameter("@NoOfProblems", SqlDbType.Int), //15
new SqlParameter("@CompletionDate", SqlDbType.DateTime), //16
new SqlParameter("@PostFlag", SqlDbType.Char, 1), //17
new SqlParameter("@DelFlag", SqlDbType.Char, 1), //18
new SqlParameter("@UpdUser", SqlDbType.VarChar, 50), //19
//new SqlParameter("@UpdDate",SqlDbType.DateTime),//20
//new SqlParameter("@UpdTime",SqlDbType.DateTime),//21
new SqlParameter("@UpdTerm", SqlDbType.VarChar, 50), //20
new SqlParameter("@TransferStatus", SqlDbType.Char, 1), //21
new SqlParameter("@Status", SqlDbType.Char, 1), //22
new SqlParameter("@Remarks", SqlDbType.VarChar, 200), //23
new SqlParameter("@TotalAmount", SqlDbType.Float), //24
new SqlParameter("@SaleDealerCode", SqlDbType.Char, 5), //25
new SqlParameter("@SaleDealerName", SqlDbType.VarChar, 100), //26
};
param[0].Value = Session["DealerCode"].ToString();
if (ddlPRNo.SelectedValue == "0" || ddlPRNo.SelectedValue.ToString().Trim() == "__/_____")
{
param[1].Value = sysFuncs.AutoGen("PPRMaster", "PPRCode", DateTime.Now.ToString("dd-MM-yyyy"));
//txtPPRNo.Text = param[1].Value.ToString();
ViewState["PPRCode"] = param[1].Value.ToString();
}
else
{
param[1].Value = ddlPRNo.SelectedValue;
}
//param[1].Value =txtPPRNo.Text;
param[2].Value = txtJobCardNo.Text;
param[3].Value = sysFuncs.SaveDate(txtPPRDate.Text);
param[4].Value = txtCustCode.Text;
param[5].Value = txtUserName.Text;
param[6].Value = txtUserAddress.Text;
param[7].Value = txtPhoneNo.Text;
param[8].Value = txtEngNo.Text;
param[9].Value = txtChasisNo.Text;
param[10].Value = txtRegNo.Text;
param[11].Value = sysFuncs.SaveDate(txtInvDate.Text);
param[12].Value = txtKM.Text;
param[13].Value = sysFuncs.SaveDate(dtProblemDate.Text);
param[14].Value = ddlRoadCond.SelectedValue;
param[15].Value = 1;
param[16].Value = sysFuncs.SaveDate(dtComplitionDate.Text);
param[17].Value = "N";
param[18].Value = "N";
param[19].Value = Session["UserName"].ToString();
//param[19].Value = ObjGenral.SaveDate(DateTime.Now.ToString("dd-MM-yyyy"));
//param[20].Value = ObjGenral.SaveTime(DateTime.Now.ToString("HH:MM"));
param[20].Value = GlobalVar.mUserIPAddress;
param[21].Value = "C";
param[22].Value = "C";
param[23].Value = txtCompletionDesc.Text;
param[24].Value = txtPPRTotalAmount.Text;
param[25].Value = "";
param[26].Value = "";
if (sysFuncs.ExecuteSP_NonQuery("sp_2W_Service_Insert_PPRMaster", param, Trans))
{
return(true);
}
else
{
return(false);
}
}
//protected void ChkBox_CheckedChanged(object sender, EventArgs e)
//{
// if (ChkBox.Checked)
// {
// foreach (GridViewRow gvr in Grdbillings.Rows)
// {
// TotalAmount = TotalAmount + Convert.ToDecimal(gvr.Cells[5].Text.Trim());
// CheckBox Chk = (CheckBox)gvr.Cells[0].FindControl("ChkBox");
// Chk.Checked = true;
// }
// txtTotalAmount.Text = TotalAmount.ToString();
// CalculatePSTPercentage();
// }
// else
// {
// foreach (GridViewRow gvr in Grdbillings.Rows)
// {
// CheckBox Chk = (CheckBox)gvr.Cells[0].FindControl("ChkBox");
// Chk.Checked = false;
// txtTotalAmount.Text = "0.00";
// //txtPstAmt.Text = "0.00";
// }
// }
//}
protected void btnSave_Click(object sender, EventArgs e)
{
if (!sec.UserRight("2583", "002"))
{
Response.Redirect("~/Test.aspx");
}
try
{
int grd = Grdbillings.Rows.Count;
if (grd > 0)
{
//Auto Generated Code//
DateTime dt = DateTime.Now;
string strYear = dt.Year.ToString();
string BillNo;
if (ddlBillingNo.SelectedValue.Trim() == "0")
{
BillNo = ObjGenral.AutoGen("JENBillMaster", "JENBillNo", DateTime.Now.ToString("dd-MM-yyyy"));
}
else
{
BillNo = ddlBillingNo.SelectedValue.Trim();
}
//Auto Generated Code//
string Remarks = txtRemarks.Text.Trim().ToString();
float BillRecAmount = 0;
string DelFlag = "N", PostFlag = "N";
string UpdUser = Session["UserName"].ToString();
//FFI PDI Master Insert here
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char, 5), //0
new SqlParameter("@FPBillNo", SqlDbType.Char, 8), //1
new SqlParameter("@BillDate", SqlDbType.DateTime), //2
new SqlParameter("@Remarks", SqlDbType.VarChar, 100), //3
new SqlParameter("@BillQty", SqlDbType.Int), //4
new SqlParameter("@BillAmount", SqlDbType.Float, 15), //5
new SqlParameter("@BillRecAmount", SqlDbType.Float, 15), //6
new SqlParameter("@DelFlag", SqlDbType.Char, 1), //7
new SqlParameter("@PostFlag", SqlDbType.Char, 1), //8
new SqlParameter("@UpdUser", SqlDbType.VarChar, 5), //9
//new SqlParameter("@UpdDate",SqlDbType.DateTime),//10
//new SqlParameter("@UpdTime",SqlDbType.DateTime),//11
new SqlParameter("@UpdTerm", SqlDbType.VarChar, 50), //12
new SqlParameter("@TransferStatus", SqlDbType.Char, 1), //13
new SqlParameter("@VoucherNo", SqlDbType.VarChar, 50), //14
new SqlParameter("@VoucherFlag", SqlDbType.Char, 1), //15
new SqlParameter("@SoftwareVersion", SqlDbType.VarChar, 25), //16
new SqlParameter("@BillType", SqlDbType.VarChar, 5), //17
new SqlParameter("@VehType", SqlDbType.Char, 3), //17
new SqlParameter("@CreditNo", SqlDbType.VarChar, 50), //17
new SqlParameter("@GSTAmount", SqlDbType.Decimal, 50), //17
new SqlParameter("@SSTAmount", SqlDbType.Decimal, 50), //17
//new SqlParameter("@SSTAge",SqlDbType.Decimal,18),//18
//new SqlParameter("@SSTAmount",SqlDbType.Decimal,18),//19
};
param[0].Value = Session["DealerCode"].ToString();
param[1].Value = BillNo;
param[2].Value = ObjGenral.SaveDate(txtBillDate.Text);
//param[2].Value = txtBillDate.Text;
param[3].Value = Remarks.ToUpper();
param[4].Value = Grdbillings.Rows.Count;
param[5].Value = txtTotalAmount.Text.Trim().ToString();
param[6].Value = BillRecAmount;
param[7].Value = DelFlag;
param[8].Value = PostFlag;
param[9].Value = Session["UserName"].ToString();
//param[10].Value = ObjGenral.SaveDate(DateTime.Now.ToString());
//param[11].Value = ObjGenral.SaveTime(DateTime.Now.ToString());
param[10].Value = GlobalVar.mUserIPAddress;
param[11].Value = "C";
param[12].Value = null;
param[13].Value = null;
param[14].Value = null;
param[15].Value = ddlTypes.SelectedValue.ToString();
param[16].Value = txtCreditNo.Text;
param[17].Value = txtGSTAmt.Text.Trim();
param[18].Value = txtLabPST.Text.Trim();
if (ObjTrans.BeginTransaction(ref Trans) == true)
{
if (ObjGenral.ExecuteSP_NonQuery("sp_Service_JENBillMaster_Insert", param, Trans))
{
lblLastBillNo.Text = "Last Code Generated : " + " " + BillNo;
}
}
else
{
lblMessage.Text = "Error";
}
//FFI PDI Master Insert here
//Insert Detail Data Here
foreach (GridViewRow gvr in Grdbillings.Rows)
{
string DealerCode = Session["DealerCode"].ToString();
string PPRCode = gvr.Cells[1].Text.Trim().ToString();
string BillNoDetail = BillNo;
// string Billtype = ddlTypes.SelectedValue.ToString();
string BillAmount = gvr.Cells[5].Text.Trim().ToString();
CheckBox Chk = (CheckBox)gvr.Cells[0].FindControl("ChkBox");
SqlParameter[] param1 =
{
new SqlParameter("@DealerCode", SqlDbType.Char, 5), //0
new SqlParameter("@JENBillNo", SqlDbType.Char, 8), //1
new SqlParameter("@PPRCode", SqlDbType.Char, 8), //2
new SqlParameter("@PPRDate", SqlDbType.DateTime), //3
new SqlParameter("@ChassisNo", SqlDbType.VarChar, 15), //4
new SqlParameter("@Parts", SqlDbType.Float), //5
new SqlParameter("@Sublet", SqlDbType.Float), //6
new SqlParameter("@Labor", SqlDbType.Float), //7
new SqlParameter("@TotalAmount", SqlDbType.Float), //8
new SqlParameter("@GSTAmount", SqlDbType.Float), //9
new SqlParameter("@PSTLaborAmount", SqlDbType.Float), //10
new SqlParameter("@PSTSublet", SqlDbType.Float), //11
new SqlParameter("@HandlingAmount", SqlDbType.Float), //12
};
param1[0].Value = Session["DealerCode"].ToString();
param1[1].Value = BillNoDetail;
param1[2].Value = PPRCode;
param1[3].Value = sysFunc.SaveDate(gvr.Cells[2].Text.Trim().ToString());
param1[4].Value = gvr.Cells[4].Text.Trim().ToString();
param1[5].Value = SysFunctions.CustomCDBL(gvr.Cells[12].Text);
param1[6].Value = SysFunctions.CustomCDBL(gvr.Cells[13].Text);
param1[7].Value = SysFunctions.CustomCDBL(gvr.Cells[14].Text);
param1[8].Value = SysFunctions.CustomCDBL(gvr.Cells[15].Text);
param1[9].Value = SysFunctions.CustomCDBL(gvr.Cells[7].Text);
param1[10].Value = SysFunctions.CustomCDBL(gvr.Cells[9].Text);
param1[11].Value = SysFunctions.CustomCDBL(gvr.Cells[11].Text);
param1[12].Value = SysFunctions.CustomCDBL(gvr.Cells[6].Text);
// param1[3].Value = Billtype;
if (Chk.Checked == true)
{
if (ObjGenral.ExecuteSP_NonQuery("sp_Service_JENBillDetail_Insert", param1, Trans))
{
lblMessage.Text = "Record Has been Inserted Sucessfully !!!";
ClearAll();
}
// ObjGenral.ExecuteSP_NonQuery("sp_Service_JENBillDetail_Insert", param1,Trans);
}
//Insert Detail Data Here
}
}
else
{
string script = "alert(\"User should select some Bills !!!\");";
ScriptManager.RegisterStartupScript(this, this.GetType(), "ServerControlScript", script, true);
}
}
catch (Exception ex)
{
ObjTrans.RollBackTransaction(ref Trans);
lblMessage.Text = ex.Message;
}
ObjTrans.CommittTransaction(ref Trans);
}
public bool Insert_PaymentRefund()
{
SqlParameter[] PmtRecMaster_param =
{
/*0*/ new SqlParameter("@DealerCode", SqlDbType.Char, 5), /*1*/ new SqlParameter("@RefundNo",SqlDbType.Char, 8),
/*2*/ new SqlParameter("@RefundDate", SqlDbType.DateTime), /*3*/ new SqlParameter("@AdvanceCode", SqlDbType.Char, 8),
/*4*/ new SqlParameter("@CusCode", SqlDbType.VarChar, 8),
/*5*/ new SqlParameter("@Remarks", SqlDbType.Char, 100), /*6*/ new SqlParameter("@PayModeCode",SqlDbType.Char, 1),
/*7*/ new SqlParameter("@InsNo", SqlDbType.VarChar, 15), /*8*/ new SqlParameter("@InsDate",SqlDbType.DateTime),
/*9*/ new SqlParameter("@AmountPaid", SqlDbType.Float), /*10*/ new SqlParameter("@BankCode", SqlDbType.Char, 5),
/*11*/ new SqlParameter("@Branch", SqlDbType.VarChar, 50),
/*12*/ new SqlParameter("@DelFlag", SqlDbType.Char, 1),
/*13*/ new SqlParameter("@UpdUser", SqlDbType.Char, 50), /*14*/ new SqlParameter("@UpdTerm",SqlDbType.Char, 50),
/*15*/ new SqlParameter("@VoucherNo", SqlDbType.VarChar, 50), /*16*/ new SqlParameter("@VoucherFlag",SqlDbType.Char, 1),
/*17*/ new SqlParameter("@TransType", SqlDbType.VarChar, 30), /*17*/ new SqlParameter("@RefundType",SqlDbType.VarChar, 30),
};
PmtRecMaster_param[0].Value = Session["DealerCode"].ToString();
PmtRecMaster_param[2].Value = SysFuncs.SaveDate(txtRefundDate.Text); //EstimateCode
PmtRecMaster_param[3].Value = ddlReceiptNo.SelectedItem.Value;
PmtRecMaster_param[4].Value = txtCusVenCode.Text;
PmtRecMaster_param[5].Value = "";
PmtRecMaster_param[6].Value = ddlpayment_mode.SelectedItem.Value;
PmtRecMaster_param[7].Value = txtinstrument_no.Text.Trim().ToUpper();
PmtRecMaster_param[8].Value = SysFuncs.SaveDate(txtinstrument_date.Text);
PmtRecMaster_param[9].Value = txtins_amount.Text.Trim().Replace(" ", "") == "" ? "0" : txtins_amount.Text.Trim();
PmtRecMaster_param[10].Value = ddlbank.SelectedItem.Value;
PmtRecMaster_param[11].Value = txtbranch.Text.Trim().Replace(" ", "");
PmtRecMaster_param[12].Value = "N";
PmtRecMaster_param[13].Value = Session["UserName"].ToString();
PmtRecMaster_param[14].Value = GlobalVar.mUserIPAddress;
PmtRecMaster_param[15].Value = "";
PmtRecMaster_param[16].Value = "N";
PmtRecMaster_param[17].Value = txtInvType.Text;
if (RbtnType.SelectedValue == "Customer")
{
PmtRecMaster_param[18].Value = "Customer";
}
else
{
PmtRecMaster_param[18].Value = "Vendor";
}
try
{
if (ObjTrans.BeginTransaction(ref Trans) == true)
{
if (txtRefundCode.Text == "")
{
strReceiptNo = SysFunc.AutoGen("RefundPayment", "RefundCode", DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("dd/MM/yyyy"));
}
else
{
strReceiptNo = txtRefundCode.Text;
}
PmtRecMaster_param[1].Value = strReceiptNo;
if (SysFuncs.ExecuteSP_NonQuery("[sp_W2_PaymentRefund_Master_Insert]", PmtRecMaster_param, Trans))
{
SqlParameter[] UpdateAdvance_param =
{
/*0*/ new SqlParameter("@DealerCode", SqlDbType.Char, 5),
/*1*/ new SqlParameter("@ReceiptNo", SqlDbType.Char, 8),
/*2*/ new SqlParameter("@AdvanceReceiptNo", SqlDbType.Char, 8),
/*3*/ new SqlParameter("@AdvanceAdjustedAmount", SqlDbType.Float)
};
UpdateAdvance_param[0].Value = Session["DealerCode"].ToString();
UpdateAdvance_param[1].Value = ddlReceiptNo.SelectedValue.ToString();
UpdateAdvance_param[2].Value = strReceiptNo;
UpdateAdvance_param[3].Value = double.Parse(txtins_amount.Text == "" ? "0" : txtins_amount.Text);
SysFuncs.ExecuteSP_NonQuery("[sp_PaymentRefund_UpdateOnAdvance]", UpdateAdvance_param, Trans);
ObjTrans.CommittTransaction(ref Trans);
ClearAll();
SysFuncs.UserMsg(success_add_item, Color.Green, "Record Saved Sucessfully against Refund No" + strReceiptNo);
ScriptManager.RegisterClientScriptBlock(Page, typeof(Page), "ClientScript", "alert('Record Saved,Updated Successfully: " + strReceiptNo + "')", true);
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "Savealert()", true);
return(true);
}
else
{
ObjTrans.RollBackTransaction(ref Trans);
return(false);
}
}
else
{
return(false);
}
}
catch (Exception ex)
{
SysFuncs.UserMsg(success_add_item, Color.Red, ex.Message);
return(false);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
if (ddlGType.SelectedValue == "0")
{
sysfun.UserMsg(lblMessage, Color.Red, "Please Select GatePass Type First!", txtRegNo);
}
if (ddlModule.SelectedValue == "0")
{
sysfun.UserMsg(lblMessage, Color.Red, "Please Select Trans Type First!", txtRegNo);
}
if (txtGatePassCode.Text == "")
{
if (!sec.UserRight("2590", "002"))
{
Response.Redirect("~/Test.aspx");
}
Autostr = myFunc.AutoGen("GatePassTemp", "GatePassCode", DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("dd/MM/yyyy"));
}
else
{
if (!sec.UserRight("2590", "003"))
{
Response.Redirect("~/Test.aspx");
}
Autostr = txtGatePassCode.Text;
string CCon = CConnection.GetConnectionString();
SqlDataAdapter dta = new SqlDataAdapter("Select Post from GatePassTemp where CompCode='" + Session["DealerCode"].ToString() + "' and GatePassCode='" + txtGatePassCode.Text + "' and DelFlag<>'Y' ", CCon);
DataTable dt = new DataTable();
dta.Fill(dt);
if (dt.Rows.Count > 0)
{
string Postflag = dt.Rows[0]["Post"].ToString();
if (Postflag == "Y")
{
sysfun.UserMsg(lblMessage, Color.Red, "GatePass Can't Be Edit or Delete. . .! It is Already Posted. ");
return;
}
}
}
SqlParameter[] GatePass_param =
{
/*0*/ new SqlParameter("@DealerCode", SqlDbType.Char, 5),
/*1*/ new SqlParameter("@GatePassCode", SqlDbType.Char, 8),
/*2*/ new SqlParameter("@GatePassDate", SqlDbType.DateTime),
/*4*/ new SqlParameter("@TransCode", SqlDbType.VarChar, 8),
/*3*/ new SqlParameter("@GatePassType", SqlDbType.Char, 1),
/*4*/ new SqlParameter("@Remarks", SqlDbType.Char, 100),
/*6*/ new SqlParameter("@Module", SqlDbType.VarChar, 50),
/*7*/ new SqlParameter("@UpdUser", SqlDbType.Char, 50),
/*8*/ new SqlParameter("@UpdTerm", SqlDbType.Char, 50),
/*9*/ new SqlParameter("@DelFlag", SqlDbType.Char, 1),
/*10*/ new SqlParameter("@InvoiceNo", SqlDbType.VarChar, 8),
/*11*/ new SqlParameter("@InDate", SqlDbType.DateTime),
/*12*/ new SqlParameter("@InTime", SqlDbType.DateTime),
/*13*/ new SqlParameter("@OutDate", SqlDbType.DateTime),
/*14*/ new SqlParameter("@OutTime", SqlDbType.DateTime),
};
GatePass_param[0].Value = Session["DealerCode"].ToString();
GatePass_param[1].Value = Autostr;
GatePass_param[2].Value = sysfun.SaveDate(txtGatePassDate.Text);
GatePass_param[3].Value = "";
GatePass_param[4].Value = ddlGType.SelectedValue;
GatePass_param[5].Value = txtRemarks.Text;
GatePass_param[6].Value = ddlModule.SelectedValue;
GatePass_param[7].Value = Session["UserName"].ToString();
GatePass_param[8].Value = GlobalVar.mUserIPAddress;
GatePass_param[9].Value = "N";
GatePass_param[10].Value = "";
GatePass_param[11].Value = sysfun.SaveDate(txtInDate.Text);
GatePass_param[12].Value = Convert.ToDateTime(txtInTime.Text).ToString("HH:mm");
GatePass_param[13].Value = sysfun.SaveDate(txtOutDate.Text);
GatePass_param[14].Value = Convert.ToDateTime(txtOutTime.Text).ToString("HH:mm");;
if (ObjTrans.BeginTransaction(ref Trans) == true)
{
if (txtGatePassCode.Text == "")
{
if (myFunc.ExecuteSP_NonQuery("[Sp_Insert_GatePassTemp_GPForm]", GatePass_param, Trans))
{
bool a = (rowsInVehicle(gvVehicle) == true ? Inser_JobCardDetail() : false);
}
}
else
{
if (myFunc.ExecuteSP_NonQuery("[Sp_Insert_GatePassTemp_GPForm]", GatePass_param, Trans))
{
bool a = (rowsInVehicle(gvVehicle) == true ? Inser_JobCardDetail() : false);
}
}
}
if (ObjTrans.CommittTransaction(ref Trans) == true)
{
lblMessage.ForeColor = Color.Green;
if (txtGatePassCode.Text.Trim() == "") //ddlJobCardCode.SelectedIndex
{
lblMessage.Text = "Record Saved Successfully: " + Autostr;
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "Savealert()", true);
}
else
{
lblMessage.Text = "Record Updated Successfully: " + Autostr;
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "Updatealert()", true);
}
}
else
{
ObjTrans.RollBackTransaction(ref Trans);
sysfun.UserMsg(lblMessage, Color.Red, "Record not saved Try again. Or contact to support team ");
}
ClearGatePassTextBoxes();
}
catch (Exception ex)
{
sysfun.UserMsg(lblMessage, Color.Red, ex.Message, txtGatePassCode);
}
}
private void Save_InsertMasterDetail(SqlTransaction Trans, ref bool Check, ref string StrSRNo)
{
try
{
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char, 5), //0
new SqlParameter("@SRNo", SqlDbType.Char, 8), //1
new SqlParameter("@SRDate", SqlDbType.DateTime), //2
new SqlParameter("@CusCode", SqlDbType.Char, 8), //3
new SqlParameter("@Remarks", SqlDbType.Text), //4
new SqlParameter("@TotalQty", SqlDbType.Float), //5
new SqlParameter("@TotalAmount", SqlDbType.Float), //6
new SqlParameter("@DelFlag", SqlDbType.Char, 1), //7
new SqlParameter("@PostFlag", SqlDbType.Char, 1), //8
new SqlParameter("@UpdUser", SqlDbType.VarChar, 50), //9
new SqlParameter("@UpdTerm", SqlDbType.VarChar, 50), //10
new SqlParameter("@VoucherNo", SqlDbType.VarChar, 50), //11
new SqlParameter("@VoucherFlag", SqlDbType.Char, 1), //12
new SqlParameter("@SaleInvNo", SqlDbType.Char, 8), //13
new SqlParameter("@SaleType", SqlDbType.VarChar, 15), //14
};
param[0].Value = Session["DealerCode"].ToString();
param[1].Value = SysFunc.AutoGen("SRMaster", "SRNo", txtRetDate.Text.Trim());
param[2].Value = SysFunc.SaveDate(txtRetDate.Text);
param[3].Value = ddlCustomer.SelectedValue.ToString().Trim();
param[4].Value = txtRemarks.Text.Trim();
param[5].Value = txtTotalQty.Text.Trim();
param[6].Value = txtTotalAmount.Text.Trim();
param[10].Value = GlobalVar.mUserIPAddress;
param[7].Value = "N";
param[8].Value = "N";
param[9].Value = Session["UserName"].ToString();
param[11].Value = "";
param[12].Value = "";
param[13].Value = ddlSaleInvNo.SelectedValue.ToString();
if (rdCounterSale.Checked)
{
param[14].Value = rdCounterSale.Text;
}
else if (rdJobCard.Checked)
{
param[14].Value = rdJobCard.Text;
}
if (SysFunc.sp_2W_SRMaster_Insert(Trans, param))
{
StrSRNo = param[1].Value.ToString();
for (int i = 0; i < GvMain.Rows.Count; i++)
{
SqlParameter[] param1 =
{
new SqlParameter("@DealerCode", SqlDbType.Char), //0
new SqlParameter("@SRNo", SqlDbType.Char, 8), //1
new SqlParameter("@ItemCode", SqlDbType.Char, 8), //2
new SqlParameter("@PartsTransLocCode", SqlDbType.VarChar, 7), //3
new SqlParameter("@RetQty", SqlDbType.Float), //4
new SqlParameter("@Rate", SqlDbType.Float), //5
new SqlParameter("@Amount", SqlDbType.Float), //6
new SqlParameter("@AvgRate", SqlDbType.Float) //7
};
Label LbItemCode = (Label)GvMain.Rows[i].FindControl("LbItemCode");
Label LbPartsTransLocCode = (Label)GvMain.Rows[i].FindControl("LbPartsTransLocCode");
HiddenField HDPartsTransLocCode = (HiddenField)GvMain.Rows[i].FindControl("HDPartsTransLocCode");
Label LbIssueQty = (Label)GvMain.Rows[i].FindControl("LbQty");
Label LbAmount = (Label)GvMain.Rows[i].FindControl("LbAmount");
Label LbRate = (Label)GvMain.Rows[i].FindControl("LbRate");
Label LbAvgRate = (Label)GvMain.Rows[i].FindControl("LbAvgCost");
param1[0].Value = Session["DealerCode"].ToString();
param1[1].Value = StrSRNo;
param1[2].Value = LbItemCode.Text;
param1[3].Value = HDPartsTransLocCode.Value;
param1[4].Value = LbIssueQty.Text;
param1[5].Value = LbRate.Text;
param1[6].Value = LbAmount.Text;
param1[7].Value = LbAvgRate.Text;
if (SysFunc.sp_W2_SRDetail_Insert(Trans, param1))
{
Check = true;
}
else
{
Check = false;
break;
}
}
}
}
catch (Exception ex)
{
LbErr.Text = ex.Message;
}
}
protected void btnSave1_Click(object sender, EventArgs e)
{
if (ddlSolution.SelectedIndex == 0)
{
sysFuncs.UserMsg(lblMessage, Color.Red, "Please Select Solution", txtComment);
return;
}
else if (ddlPolicyType.SelectedIndex == 0)
{
sysFuncs.UserMsg(lblMessage, Color.Red, "Please Select PolicyType", txtComment);
return;
}
else if (ddlStatus.SelectedIndex == 0)
{
sysFuncs.UserMsg(lblMessage, Color.Red, "Please Select Status", txtComment);
return;
}
else if (txtComment.Text == "")
{
sysFuncs.UserMsg(lblMessage, Color.Red, "Please Enter Comment", txtComment);
return;
}
else
{
lblMessage.Text = string.Empty;
}
try
{
SqlParameter[] param1 =
{
new SqlParameter("@DealerCode", SqlDbType.Char), //0
new SqlParameter("@WFPolicyMasterID", SqlDbType.Char), //1
new SqlParameter("@WFPolicyMasterCode", SqlDbType.Char), //2 WFPolicyMasterDesc
new SqlParameter("@WFPolicyMasterDesc", SqlDbType.VarChar), //3
new SqlParameter("@Solution_Code", SqlDbType.Char), //4
new SqlParameter("@PolicyType", SqlDbType.VarChar), //5
new SqlParameter("@PolicyStartDate", SqlDbType.DateTime), //6
new SqlParameter("@PolicyEndDate", SqlDbType.DateTime), //7
new SqlParameter("@Status", SqlDbType.VarChar), //8
new SqlParameter("@Comments", SqlDbType.VarChar), //9
new SqlParameter("@DelFlag", SqlDbType.Char), //10
new SqlParameter("@UpdUser", SqlDbType.VarChar), //11
new SqlParameter("@UpdTerm", SqlDbType.VarChar), //12
};
string max2;
string max1 = sysFuncs.GetNewMaxID("WFPolicyMaster", "WFPolicyMasterID", 4, Session["DealerCode"].ToString());
if (ddlWFPolicyMasterCode.SelectedIndex == 0)
{
max2 = sysFuncs.AutoGen("WFPolicyMaster", "WFPolicyMasterCode", DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("dd/MM/yyyy"));
}
else
{
max2 = ddlWFPolicyMasterCode.SelectedValue;
}
param1[0].Value = Session["DealerCode"].ToString();
param1[1].Value = max1;
param1[2].Value = max2;
param1[3].Value = txtPolicyDesc.Text;
param1[4].Value = ddlSolution.SelectedValue;
param1[5].Value = ddlPolicyType.SelectedValue;
param1[6].Value = txtStartDate.Text.Trim();
param1[7].Value = txtEndDate.Text.Trim();
param1[8].Value = ddlStatus.SelectedValue;
param1[9].Value = txtComment.Text.Trim();
param1[10].Value = 'N';
param1[11].Value = Session["UserName"].ToString();
param1[12].Value = "1";
if (sysFunc.ExecuteSP_NonQuery("SP_WFPolicyMaster_insert", param1))
{
SqlParameter[] param2 =
{
new SqlParameter("@DealerCode", SqlDbType.Char), //0
new SqlParameter("@WFPolicyMasterID", SqlDbType.Char), //1
new SqlParameter("@WFPolicyMasterCode", SqlDbType.Char), //2
new SqlParameter("@ApprovalCode", SqlDbType.Char), //3
new SqlParameter("@Priority", SqlDbType.Int), //4
new SqlParameter("@ApprovalRoll", SqlDbType.VarChar), //5
new SqlParameter("@BatchNo", SqlDbType.Char), //6
// new SqlParameter("@IsMandatory",SqlDbType.VarChar), //7
new SqlParameter("@Status", SqlDbType.VarChar), //7
};
//string max3 = sysFuncs.GetNewMaxID("WFPolicyDetail", "ApprovalCode", 10, Session["DealerCode"].ToString());
PartsDT = (DataTable)ViewState["WFPolicyDS"];
DataSet ds = (DataSet)Session["WFPolicyDS"];
DataRow[] drr = ds.Tables[0].Select();
for (int j = 0; j < drr.Length; j++)
{
if (ds.Tables[0].Rows[j]["ApprovalCode"].ToString() != "")
{
param2[0].Value = Session["DealerCode"].ToString();
param2[1].Value = max1;
param2[2].Value = max2;
param2[3].Value = ds.Tables[0].Rows[j]["ApprovalCode"].ToString();
param2[4].Value = ds.Tables[0].Rows[j]["Priority"].ToString();
param2[5].Value = ds.Tables[0].Rows[j]["ApprovalRoll"].ToString();
param2[6].Value = ds.Tables[0].Rows[j]["BatchNo"].ToString();
param2[7].Value = ds.Tables[0].Rows[j]["Status"].ToString();
}
sysFunc.ExecuteSP_NonQuery("SP_WFPolicyDetail_insert", param2);
sysFuncs.UserMsg(lblMsg, Color.Green, "Data Inserted", txtComment);
}
}
}
catch (Exception ex)
{
lblMsg.Visible = true;
lblMsg.ForeColor = Color.Red;
lblMsg.Text = ex.Message;
}
}
protected void BtnSubmit_Click(object sender, EventArgs e)
{
try
{
string max;
if (ddlfeedbackNo.SelectedIndex <= 0)
{
max = sysFuncs.AutoGen("FeedBackMaster", "FeedBackCode", DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("dd/MM/yyyy"));
}
else
{
max = ddlfeedbackNo.SelectedValue.Trim();
}
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char, 5), //0
new SqlParameter("@FeedBackCode", SqlDbType.Char, 8), //1
new SqlParameter("@FeedBackDate", SqlDbType.DateTime), //2
new SqlParameter("@JobcardCode", SqlDbType.Char, 8), //2
new SqlParameter("@CusCode", SqlDbType.Char, 8),
new SqlParameter("@ServiceType", SqlDbType.VarChar, 50),
new SqlParameter("@DelFlag", SqlDbType.Char, 1),
new SqlParameter("@UpdUser", SqlDbType.VarChar, 50),
};
FeedBackDT = (DataTable)Session["FeedbackQuestionsDS"];
DataRow[] drr = FeedBackDT.Select();
param[0].Value = Session["DealerCode"].ToString(); // 0
param[1].Value = max;
param[2].Value = sysFuncs.SaveDate(txtfeedbackDate.Text);
param[3].Value = ddlJobCardCode.SelectedValue;
param[4].Value = txtCusCode.Text;
param[5].Value = ddlServiceType.SelectedValue.ToString();
param[6].Value = "N";
param[7].Value = Session["UserName"];
if (sysFunc.ExecuteSP_NonQuery("SP_SaveFeedbackQuestions", param))
{
SqlParameter[] param2 =
{
new SqlParameter("@DealerCode", SqlDbType.Char, 5), //0
new SqlParameter("@FeedBackCode", SqlDbType.Char, 8), //1
new SqlParameter("@JobcardCode", SqlDbType.Char, 8),
new SqlParameter("@ParentQuestionCode", SqlDbType.Char, 8), //3
new SqlParameter("@Rating", SqlDbType.VarChar,20), //4
};
FeedBackDT = (DataTable)Session["FeedbackQuestionsDS"];
for (int i = 0; i < drr.Length; i++)
{
//if (FeedBackDT.Rows[i]["ItemCode"].ToString() != "")
//{
//}
param2[0].Value = Session["DealerCode"].ToString(); // 0
param2[1].Value = max; //1
param2[2].Value = ddlJobCardCode.SelectedValue;
param2[3].Value = FeedBackDT.Rows[i]["ParentQuestionCode"].ToString();
param2[4].Value = FeedBackDT.Rows[i]["Rating"].ToString();
sysFunc.ExecuteSP_NonQuery("SP_InsertQuestionsDetail", param2);
}
//createGrid();
lblMessage.Text = "FeeBack Inserted.";
BtnClear_Click(null, null);
gv_FeedbackQuestions.DataSource = null;
gv_FeedbackQuestions.DataBind();
}
}
catch (Exception ex)
{
sysFunc.UserMsg(lblMessage, System.Drawing.Color.Red, ex.Message);
}
}
