public bool UpdateItemStock(string ItemCode, string FromLocCode, string ToLocCode, double Qty, ref SqlTransaction Trans)
{
string sQuery = String.Empty;
if ((SysFunc.IsExist("ItemCode", ItemCode.Trim(), "ItemStock",
Session["DealerCode"].ToString(), " AND PartsTransLocCode = '" + ToLocCode.Trim() + "'") == true))
{
sQuery = ("UPDATE ItemStock SET RecQty = RecQty + "
+ (Qty + (" WHERE LTrim(RTrim(PartsTransLocCode)) + LTrim(RTrim(ItemCode)) =\'"
+ ((ToLocCode.Trim() + ItemCode.Trim()) + ("\' And DealerCode = \'"
+ (Session["DealerCode"] + "\'"))))));
if (!SysFunc.ExecuteQuery_NonQuery(sQuery))
{
ObjTrans.RollBackTransaction(ref Trans);
return(false);
}
sQuery = ("UPDATE ItemStock SET IssQty = IssQty + "
+ (Qty + (" WHERE LTRIM(RTRIM(PartsTransLocCode))+LTRIM(RTRIM(ItemCode)) =\'"
+ ((FromLocCode.Trim() + ItemCode.Trim()) + ("\' and DealerCode = \'"
+ (Session["DealerCode"] + "\'"))))));
if (!SysFunc.ExecuteQuery_NonQuery(sQuery))
{
ObjTrans.RollBackTransaction(ref Trans);
return(false);
}
}
else
{
sQuery = ("INSERT INTO ItemStock (DealerCode,PartsTransLocCode,ItemCode,RecQty) VALUES (\'"
+ (Session["DealerCode"] + ("\',\'"
+ (ToLocCode.Trim() + ("\',\'"
+ (ItemCode + ("\',"
+ (Qty + ")"))))))));
if (!SysFunc.ExecuteQuery_NonQuery(sQuery))
{
ObjTrans.RollBackTransaction(ref Trans);
return(false);
}
sQuery = ("UPDATE ItemStock SET IssQty = IssQty + "
+ (Qty + (" WHERE LTRIM(RTRIM(PartsTransLocCode))+LTRIM(RTRIM(ItemCode)) =\'"
+ ((FromLocCode.Trim() + ItemCode.Trim()) + ("\' and DealerCode = \'"
+ (Session["DealerCode"] + "\'"))))));
if (!SysFunc.ExecuteQuery_NonQuery(sQuery))
{
ObjTrans.RollBackTransaction(ref Trans);
return(false);
}
}
return(true);
}
protected void btn_delete_Click(object sender, EventArgs e)
{
DataSet dsdelete = new DataSet();
if (ddlEmployee.SelectedIndex > 0)
{
string code = ddlEmployee.SelectedValue;
if (SysFunc.CodeExists("BookOrdMaster", "SalesPerson", code, Session["DealerCode"].ToString(), ref dsdelete))
{
success_add_item.Text = "Cannot delete , this Employee is already in use";
return;
}
if (SysFunc.CodeExists("JobCardMaster", "Advisor", code, Session["DealerCode"].ToString(), ref dsdelete))
{
success_add_item.Text = "Cannot delete , this Employee is already in use";
return;
}
if (SysFunc.CodeExists("JobCardDetail", "EmpCode", code, Session["DealerCode"].ToString(), ref dsdelete))
{
success_add_item.Text = "Cannot delete , this Employee is already in use";
return;
}
if (SysFunc.CodeExists("StockIssueDetail", "EmpCode", code, Session["DealerCode"].ToString(), ref dsdelete))
{
success_add_item.Text = "Cannot delete , this Employee is already in use";
return;
}
try
{
string sql = "Delete From DealerEmp Where EmpCode = " + ddlEmployee.SelectedItem.Value + "AND DealerCode = '" + Session["DealerCode"] + "'";
SysFunc.ExecuteQuery_NonQuery(sql);
LoadDDL_EmpCode();
cleardata();
success_add_item.Visible = true;
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "Deletealert()", true);
success_add_item.Text = "Employee Deleted Successfully";
}
catch (Exception ex)
{
success_add_item.Visible = true;
success_add_item.Text = ex.Message;
}
}
else
{
success_add_item.Visible = true;
success_add_item.ForeColor = Color.Red;
success_add_item.Text = "Select Employee Code";
return;
}
}
protected void btnPost_Click(object sender, EventArgs e)
{
if (txtGatePassCode.Text == "")
{
sysfun.UserMsg(lblMessage, Color.Green, "Please Select GatePass ");
return;
}
if (!sec.UserRight("2590", "005"))
{
Response.Redirect("~/Test.aspx");
}
string sql = "Update GatePassTemp set PostFlag='Y' where GatePassCode='" + txtGatePassCode.Text + "'";
if (sysfun.ExecuteQuery_NonQuery(sql))
{
sysfun.UserMsg(lblMessage, Color.Green, "GatePass Posted");
}
}
public static bool Insert_BalancedPaymentDetail(List <BookingReceiptInstrumentDetailVM> model2, string dealerCode, ref string msg)
{
int count = 0;
try
{
foreach (var item in model2)
{
if (model2.Count >= 1 || item.InstrumentNo != null)
{
string strReceiptNo = sysfun.AutoGen("BookingReceiptInstrumentDetail", "ReceiptNo", DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("dd/MM/yyyy"), dealerCode);
SqlParameter[] param2 =
{
new SqlParameter("@DealerCode", dealerCode), //0
new SqlParameter("@BookRefNo", item.BookRefNo), //1
new SqlParameter("@InstrumentNo", item.InstrumentNo), //2
new SqlParameter("@InstrumentDate", sysfun.SaveDate(item.InstrumentDate)), //3
new SqlParameter("@InstrumentAmount", item.InstrumentAmount), //4
new SqlParameter("@CityCode", item.CityCode), //5
new SqlParameter("@BankCode", item.BankCode), //6
new SqlParameter("@Branch", item.Branch), //7
new SqlParameter("@PaymentMode", item.PaymentMode), //8
new SqlParameter("@PaymentType", item.PaymentType), //9
new SqlParameter("@ReceiptNo", strReceiptNo), //10
new SqlParameter("@DepositEmpCode", item.DepositEmpCode), //10
new SqlParameter("@DepositBankCode", item.DepositBankCode), //10
new SqlParameter("@DepositBranch", item.DepositBranch), //10
new SqlParameter("@DepositNo", item.DepositNo), //10
new SqlParameter("@DepositDate", item.DepositDate == null ?(object)DBNull.Value: sysfun.SaveDate(item.DepositDate)) //10
};
if (sysfun.ExecuteSP_NonQuery("SP_Insert_BookingReceiptInstrumentDetail", param2))
{
string sql = "Update BookOrdMaster set RemainingTotal = RemainingTotal - '" + item.InstrumentAmount + "' where BookRefNo = '" + item.BookRefNo + "'and DealerCode = '" + dealerCode + "'";
sysfun.ExecuteQuery_NonQuery(sql);
IsSaved = true;
}
else
{
IsSaved = false;
}
}
}
}
catch (Exception ex)
{
msg = ex.Message;
}
return(IsSaved);
}
public static bool Insert_VehLocTransDetail(List <VehicleLocTransVM> model2, string dealerCode, ref string msg)
{
int count = 0;
try
{
foreach (var item in model2)
{
if (item.ChasisNo != null || item.ChasisNo != "")
{
SqlParameter[] param2 =
{
new SqlParameter("@DealerCode", dealerCode), //0
new SqlParameter("@TransNo", strAutoCode), //1
new SqlParameter("@BrandCode", item.BrandCode), //2
new SqlParameter("@ProdCode", item.ProdCode.Trim()), //3
new SqlParameter("@VersionCode", item.VersionCode.Trim()), //4
new SqlParameter("@EngineNo", item.EngineNo.Trim()), //5
new SqlParameter("@ChasisNo", item.ChasisNo.Trim()), //6
new SqlParameter("@RegNo", item.RegNo) //7
};
if (sysfun.ExecuteSP_NonQuery("SP_Insert_VehicleLocTransDetail", param2, Trans) == true && IsSaved == true)
{
string sql = "update VehicleStock set LocCode = '" + item.ToLocCode + "' where" +
" BrandCode = '" + item.BrandCode + "' and ProdCode = '" + item.ProdCode + "' and VersionCode = '" + item.VersionCode + "' and EngineNo = '" + item.EngineNo + "'" +
" and ChasisNo = '" + item.ChasisNo + "' and DealerCode = '" + dealerCode + "'";
if (sysfun.ExecuteQuery_NonQuery(sql, Trans))
{
IsSaved = true;
}
else
{
IsSaved = false;
}
}
else
{
IsSaved = false;
}
}
count++;
}
ObjTrans.CommittTransaction(ref Trans);
}
catch (Exception ex)
{
ObjTrans.RollBackTransaction(ref Trans);
msg = ex.Message;
IsSaved = false;
}
return(IsSaved);
}
//// FOR GRIDVIEW ROW UPDATING
protected void gv_Unit_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
try
{
DataTable dt_update = new DataTable();
Label lblUnitCode = (Label)gv_Unit.Rows[e.RowIndex].FindControl("lblUnitCode");
TextBox txtUnitDesc = (TextBox)gv_Unit.Rows[e.RowIndex].FindControl("txtUnitDesc"); // GridView TextBox Field
// Check value in GridView TextBOX
if (txtUnitDesc.Text.Trim() == string.Empty)
{
lblMessage.Visible = true;
lblMessage.Text = "Category Code can not null or empty.";
return;
}
dt_update = (DataTable)Session["UnitCategoryDS"];
//Uzair
//DataRow dr = ds_update.Tables[0].Rows[0];
// Check in GridView
foreach (DataRow dr in dt_update.Rows)
{
if (dr["UnitCode"].ToString() == lblUnitCode.Text)
{
dr["UnitDesc"] = txtUnitDesc.Text.Trim();
}
}
gv_Unit.EditIndex = -1;
gv_Unit.DataSource = dt_update;
gv_Unit.DataBind();
Session["UnitCategoryDS"] = dt_update;
string sql = "update Unit set UnitDesc = '" + txtUnitDesc.Text + "' WHERE UnitCode='" + lblUnitCode.Text + "' ";
if (sysFunc.ExecuteQuery_NonQuery(sql))
{
sysFunc.UserMsg(lblMessage, Color.Green, "Sucessfully Update");
}
}
catch (Exception ex)
{
lblMessage.Visible = true;
lblMessage.Text = ex.Message;
}
}
public static bool Insert_DODetail(List <VehicleDeliveryDetailVM> model2, string dealerCode)
{
int count = 0;
try
{
foreach (var item in model2)
{
if (count >= 1 || item.BrandCode != null)
{
SqlParameter[] param2 =
{
new SqlParameter("@DealerCode", dealerCode), //0
new SqlParameter("@DeliveryNo", strAutoCode), //1
new SqlParameter("@BrandCode", item.BrandCode), //2
new SqlParameter("@ProdCode", item.ProdCode.Trim()), //3
new SqlParameter("@VersionCode", item.VersionCode.Trim()), //4
new SqlParameter("@ColorCode", item.ColorCode.Trim()), //5
new SqlParameter("@EngineNo", item.EngineNo.Trim()), //6
new SqlParameter("@ChasisNo", item.ChasisNo.Trim()), //7
new SqlParameter("@ProdRecNo", item.ProdRecNo.Trim()), //8
new SqlParameter("@LocCode", item.LocCode), //9
new SqlParameter("@SaleType", item.StockType), //10
new SqlParameter("@BookingNo", item.BookingNo), //11
new SqlParameter("@DocNo", item.DocumentNo) //12
};
if (sysfun.ExecuteSP_NonQuery("SP_VehicleDeliveryDetail_Insert", param2, Trans) == true)
{
string sql = "update VehicleStock set DeliveryFlag = 'Y' , InStockFlag = 'N' , OutDate = '" + General.CurrentDate + "' where" +
" BrandCode = '" + item.BrandCode + "' and ProdCode = '" + item.ProdCode + "' and VersionCode = '" + item.VersionCode + "' and EngineNo = '" + item.EngineNo + "'" +
" and ChasisNo = '" + item.ChasisNo + "' and RecNo = '" + item.ProdRecNo + "' and DealerCode = '" + dealerCode + "'";
sysfun.ExecuteQuery_NonQuery(sql, Trans);
IsSaved = true;
}
else
{
ObjTrans.RollBackTransaction(ref Trans);
IsSaved = false;
}
}
count++;
}
}
catch (Exception)
{
ObjTrans.RollBackTransaction(ref Trans);
throw;
}
return(IsSaved);
}
protected void btn_Delete_Click(object sender, EventArgs e)
{
DataSet dsdelete = new DataSet();
DataTable dt = new DataTable();
try
{
string sql = "Delete from Complaint where TicketNo='" + txtTicketNo.Text.Trim() + "'";
sysFunc.ExecuteQuery_NonQuery(sql);
createGrid();
}
catch (Exception ex)
{
lblMsg.Visible = true;
lblMsg.Text = ex.Message;
}
}
protected void btnDelete0_Click(object sender, EventArgs e)
{
try
{
string qry = "DELETE FROM LaborDetail WHERE DealerCode = '" + Session["DealerCode"].ToString() + "' AND DefJobCode = '" + ddljob_code.SelectedValue + "'";
SysFunc.ExecuteQuery_NonQuery(qry);
lblMsg.Visible = true;
lblMsg.Text = "Labor " + ddljob_code.SelectedValue + " Deleted Successfully";
cleadata();
Create_Grid();
}
catch (Exception ex)
{
lblMsg.Visible = true;
lblMsg.Text = ex.Message;
}
}
protected void btnDelete_Click(object sender, EventArgs e)
{
if (ddlBays.SelectedIndex == 0)
{
lblMsg.Text = "Please Select Bay First";
return;
}
string query = "select * from JobCardDetail where BayID = '" + ddlBays.SelectedValue.Trim() + "' and DealerCode in ('" + Session["DealerCode"].ToString() + "','AAAAA')";
DataTable dt = new DataTable();
dt = sysFunc.GetData(query);
if (dt.Rows.Count > 0)
{
lblMsg.Text = "The Bay is in use";
return;
}
try
{
string qry = "DELETE FROM Bay WHERE DealerCode in ('" + Session["DealerCode"].ToString() + "','AAAAA') AND BayID = '" + ddlBays.SelectedValue + "'";
sysFunc.ExecuteQuery_NonQuery(qry);
lblMsg.Visible = true;
lblMsg.Text = "Labor " + ddlBays.SelectedValue + " Deleted Successfully";
cleadata();
Create_Grid();
}
catch (Exception ex)
{
lblMsg.Visible = true;
lblMsg.Text = ex.Message;
}
}
public static bool Delete_VehicleType(string table, string Column, string ColumnCode, string DealerCode)
{
try
{
if (table == "VehicleType")
{
if (sysfun.IsExist("VehTypeCode", ColumnCode, "ProdRecMaster", DealerCode, "") == true)
{
return(false);
}
if (sysfun.IsExist("VehTypeCode", ColumnCode, "VehicleDeliveryMaster", DealerCode, "") == true)
{
return(false);
}
}
else if (table == "VehicleReceiptType")
{
if (sysfun.IsExist("VehRecCode", ColumnCode, "ProdRecMaster", DealerCode, "") == true)
{
return(false);
}
if (sysfun.IsExist("VehRecCode", ColumnCode, "vehicledeliverymaster", DealerCode, "") == true)
{
return(false);
}
}
else if (table == "VehicleLocation")
{
if (sysfun.IsExist("LocCode", ColumnCode, "VehicleStock", DealerCode, "") == true)
{
return(false);
}
}
else if (table == "ExpenseHead")
{
if (sysfun.IsExist("ExpFor", ColumnCode, "DailyExpenseDetail", DealerCode, "") == true)
{
return(false);
}
}
else if (table == "DelChkList")
{
if (sysfun.IsExist("DelChkListCode", ColumnCode, "VehicleDelChkList", DealerCode, "") == true)
{
return(false);
}
}
else if (table == "VehExpHead")
{
if (sysfun.IsExist("VehExpCode", ColumnCode, "ReceiptDetail", DealerCode, "") == true)
{
return(false);
}
if (sysfun.IsExist("VehExpCode", ColumnCode, "ExpenditureDetail", DealerCode, "") == true)
{
return(false);
}
}
if (sysfun.ExecuteQuery_NonQuery("Delete from " + table + " where DealerCode in ('" + DealerCode + "','COMON') and " + Column + " = '" + ColumnCode + "'"))
{
IsSaved = true;
}
else
{
IsSaved = false;
}
}
catch (Exception)
{
throw;
}
return(IsSaved);
}
protected void gv_TaxType_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
try
{
DataTable dt_update = new DataTable();
Label lblTaxID = (Label)gv_TaxType.Rows[e.RowIndex].FindControl("lblTaxID");
TextBox txtTaaxHead = (TextBox)gv_TaxType.Rows[e.RowIndex].FindControl("txtTaaxHead"); // GridView TextBox Field
Label lblTaxType = (Label)gv_TaxType.Rows[e.RowIndex].FindControl("lblTaxType");
DropDownList ddlEditType = (DropDownList)gv_TaxType.Rows[e.RowIndex].FindControl("ddlEditType");
Label lblTaxApplicable = (Label)gv_TaxType.Rows[e.RowIndex].FindControl("lblTaxApplicable");
DropDownList ddlEditTaxApplicable = (DropDownList)gv_TaxType.Rows[e.RowIndex].FindControl("ddlEditTaxApplicable");
Label lblTaxPercent = (Label)gv_TaxType.Rows[e.RowIndex].FindControl("lblTaxPercent");
TextBox txtEditPer = (TextBox)gv_TaxType.Rows[e.RowIndex].FindControl("txtEditPer");
Label lblAccountCode = (Label)gv_TaxType.Rows[e.RowIndex].FindControl("lblAccountCode");
DropDownList ddlAccCode = (DropDownList)gv_TaxType.Rows[e.RowIndex].FindControl("ddlAccCode");
// Check value in GridView TextBOX
if (txtTaaxHead.Text.Trim() == string.Empty)
{
lblMessage.Visible = true;
lblMessage.Text = "Tax Head can not null or empty.";
return;
}
if (ddlEditType.Text.Trim() == string.Empty)
{
lblMessage.Visible = true;
lblMessage.Text = "Tax Type can not null or empty.";
return;
}
if (ddlEditTaxApplicable.Text.Trim() == string.Empty)
{
lblMessage.Visible = true;
lblMessage.Text = "Tax Applicable can not null or empty.";
return;
}
if (txtEditPer.Text.Trim() == string.Empty)
{
lblMessage.Visible = true;
lblMessage.Text = "Tax Percent can not null or empty.";
return;
}
dt_update = (DataTable)Session["TaxTypeDS"];
//Uzair
//DataRow dr = ds_update.Tables[0].Rows[0];
// Check in GridView
foreach (DataRow dr in dt_update.Rows)
{
if (dr["TaxID"].ToString() == lblTaxID.Text)
{
dr["TaxHead"] = txtTaaxHead.Text.Trim();
dr["Type"] = ddlEditType.Text.Trim();
dr["TaxApplicable"] = ddlEditTaxApplicable.Text.Trim();
dr["TaxPer"] = txtEditPer.Text.Trim();
dr["AccCode"] = ddlAccCode.SelectedValue;
}
}
gv_TaxType.EditIndex = -1;
gv_TaxType.DataSource = dt_update;
gv_TaxType.DataBind();
Session["TaxTypeDS"] = dt_update;
string sql = "update TaxType set TaxHead = '" + txtTaaxHead.Text + "',Type='" + ddlEditType.SelectedValue + "',TaxApplicable='" + ddlEditTaxApplicable.SelectedValue + "',TaxPer='" + txtEditPer.Text + "',AccCode='" + ddlAccCode.SelectedValue + "' WHERE TaxID='" + lblTaxID.Text + "' ";
if (sysFunc.ExecuteQuery_NonQuery(sql))
{
sysFunc.UserMsg(lblMessage, Color.Green, "Sucessfully Update");
}
}
catch (Exception ex)
{
lblMessage.Visible = true;
lblMessage.Text = ex.Message;
}
}
public static bool Insert_VRDetail(List <VehicleReturnDetailVM> model2)
{
int count = 0;
try
{
foreach (var item in model2)
{
if (count >= 1 || item.BrandCode != null)
{
SqlParameter[] param2 =
{
new SqlParameter("@DealerCode", item.DealerCode), //0
new SqlParameter("@ReturnCode", strAutoCode), //1
new SqlParameter("@Type", item.Type), //2
new SqlParameter("@BrandCode", item.BrandCode), //3
new SqlParameter("@ProdCode", item.ProdCode.Trim()), //4
new SqlParameter("@VersionCode", item.VersionCode), //5
new SqlParameter("@EngineNo", item.EngineNo.Trim()), //6
new SqlParameter("@ChasisNo", item.ChasisNo.Trim()), //7
new SqlParameter("@BookRefNo", item.BookRefNo), //8
new SqlParameter("@BookRefDate", item.BookRefDate == null ? DBNull.Value :sysfun.SaveDate(item.BookRefDate)), //9
new SqlParameter("@CusCode", item.CusCode), //10
new SqlParameter("@BookingNo", item.BookingNo), //10
new SqlParameter("@ColorCode", item.ColorCode), //12
};
if (sysfun.ExecuteSP_NonQuery("SP_Insert_VehicleReturnDetail", param2, Trans) == true)
{
string sql = "update VehicleStock set DeliveryFlag = 'Y' , InStockFlag = 'N' , OutDate = '" + General.CurrentDate + "' where" +
" BrandCode = '" + item.BrandCode + "' and ProdCode = '" + item.ProdCode + "' and VersionCode = '" + item.VersionCode + "' and EngineNo = '" + item.EngineNo + "'" +
" and ChasisNo = '" + item.ChasisNo + "' and DealerCode = '" + item.DealerCode + "'";
if (sysfun.ExecuteQuery_NonQuery(sql, Trans))
{
}
else
{
ObjTrans.RollBackTransaction(ref Trans);
return(false);
}
}
else
{
ObjTrans.RollBackTransaction(ref Trans);
return(false);
}
}
count++;
}
ObjTrans.CommittTransaction(ref Trans);
IsSaved = true;
}
catch (Exception)
{
ObjTrans.RollBackTransaction(ref Trans);
throw;
}
return(IsSaved);
}
public static bool Insert_Gvoucher(List <GVouMasterVM> model2, string type, string DealerCode, ref string msg, string leadId)
{
int count = 1;
try
{
//string sql = "Select VouchNo from VehicleSaleMaster where DealerCode='" + DealerCode + "' and Vouchewr='" +ReceiptNo + "'";
//dt = sysfun.GetData(sql, "BMS0517ConnectionString");
//if (dt.Rows.Count > 0|| dt.Rows[0]["VouchNo"].ToString()!="")
//{
string sql = "Delete from GVouMaster where CompCode='" + DealerCode + "' and VouchNo='" + ReceiptNo + "' and Post='N' and DelFlag='N'";
dt = sysfun.GetData(sql, "FAMSConnectionString");
//string strAutoCode = GetNewVoucherNo("GVouMaster", "VouchNo", 3);
SqlParameter[] param =
{
new SqlParameter("@CompCode", SqlDbType.Char, 5), //0
new SqlParameter("@Booktype", SqlDbType.VarChar, 2), //1
new SqlParameter("@Journalno", SqlDbType.VarChar, 4), //2
new SqlParameter("@VouchNo", SqlDbType.VarChar, 50), //3
new SqlParameter("@SeqNo", SqlDbType.Int), //4
new SqlParameter("@ContAccCode", SqlDbType.Char, 2), //5
new SqlParameter("@SubCode", SqlDbType.Char, 2), //6
new SqlParameter("@SubSubCode", SqlDbType.Char, 2), //7
new SqlParameter("@LocCode", SqlDbType.Char, 2), //8
new SqlParameter("@DetailCode", SqlDbType.Char, 4), //9
new SqlParameter("@VouchDate", SqlDbType.DateTime), //10
new SqlParameter("@RecPay", SqlDbType.VarChar, 50), //11
new SqlParameter("@Narration01", SqlDbType.VarChar, 200), //12
new SqlParameter("@Narration02", SqlDbType.VarChar, 200), //13
new SqlParameter("@ChqBillNo", SqlDbType.VarChar, 50), //14
new SqlParameter("@ChqBillDate", SqlDbType.DateTime), //15
new SqlParameter("@DebitAmt", SqlDbType.Float), //16
new SqlParameter("@CreditAmt", SqlDbType.Float), //17
new SqlParameter("@FYear", SqlDbType.DateTime), //18
new SqlParameter("@TYear", SqlDbType.DateTime), //19
new SqlParameter("@DelFlag", SqlDbType.Char, 1), //20
new SqlParameter("@BookNo", SqlDbType.Char, 2), //21
new SqlParameter("@AutoAcc", SqlDbType.VarChar, 500), //22
new SqlParameter("@Post", SqlDbType.Char, 1), //23
new SqlParameter("@Source", SqlDbType.VarChar, 50), //24
new SqlParameter("@AddUser", SqlDbType.Char, 50), //25
new SqlParameter("@AddDate", SqlDbType.DateTime), //26
new SqlParameter("@AddTime", SqlDbType.DateTime), //27
new SqlParameter("@AddTerm", SqlDbType.VarChar, 50), //28
new SqlParameter("@CSCode", SqlDbType.Char, 8), //29
};
foreach (var item in model2)
{
sql = "Select Post from GVouMaster where CompCode='" + item.CompCode + "' and VouchNo='" + item.VouchNo + "' and SeqNo='" + count + "' ";
dt = sysfun.GetData(sql, "FAMSConnectionString");
if (dt.Rows.Count > 0)
{
Postflag = dt.Rows[0]["Post"].ToString();
// Delflag = dt.Rows[0]["DelFalg"].ToString();
if (Postflag == "Y")
{
msg = "Voucher Can't Be Edit or Delete. . .! It is Already Posted.";
return(false);
}
}
string accountcode = item.AutoAcc;
string contAccCode = accountcode.Substring(0, 2);
string subCode = accountcode.Substring(3, 2);
string subSubCode = accountcode.Substring(6, 2);
string locCode = accountcode.Substring(9, 2);
string detailCode = accountcode.Substring(12, 4);
param[0].Value = item.CompCode;
param[1].Value = item.Booktype;
param[2].Value = item.Journalno;
param[3].Value = item.VouchNo;
param[4].Value = count++;
param[5].Value = contAccCode;
param[6].Value = subCode;
param[7].Value = subSubCode;
param[8].Value = locCode;
param[9].Value = detailCode;
param[10].Value = sysfun.SaveDate(item.VouchDate);
if (type == "ASC")
{
param[11].Value = "Account Service Charges";
}
else if (type == "DE")
{
param[11].Value = "Daily Expense";
}
else if (type == "VReceipt")
{
param[11].Value = "Journal Voucher";
}
else if (type == "CSI")
{
param[11].Value = "Cash Sale Invoice";
}
param[12].Value = item.Narration01;
param[13].Value = "";
param[14].Value = item.ChqBillNo;
param[15].Value = (item.ChqBillDate == null ? DBNull.Value : sysfun.SaveDate(item.ChqBillDate));
if (Convert.ToDouble(item.DebitAmt) != 0)
{
param[16].Value = Convert.ToDouble(item.DebitAmt);
}
else
{
param[16].Value = 0;
}
if (Convert.ToDouble(item.CreditAmt) != 0)
{
param[17].Value = Convert.ToDouble(item.CreditAmt);
}
else
{
param[17].Value = 0;
}
sql = "Select FYear,TYear from FiscalYear where FYear<='" + sysfun.SaveDate(item.VouchDate) + "' and TYear>='" + sysfun.SaveDate(item.VouchDate) + "'";
dt = sysfun.GetData(sql, "FAMSConnectionString");
if (dt.Rows.Count > 0)
{
param[18].Value = dt.Rows[0]["FYear"].ToString();
param[19].Value = dt.Rows[0]["TYear"].ToString();
}
else
{
msg = "Voucher Can't be Save! Please Check Fiscal Year Date ";
return(false);
}
param[20].Value = "N";
param[21].Value = GetBookNo(accountcode, item.CompCode);
param[22].Value = accountcode;
param[23].Value = "N";
param[24].Value = type;
param[25].Value = AuthBase.EmpCode;
param[26].Value = sysfun.SaveDate(DateTime.Now.ToString("dd-MM-yyyy"));
param[27].Value = DateTime.Now;
param[28].Value = GlobalVar.mUserIPAddress;
param[29].Value = "00/00000";
SqlHelper.ExecuteNonQuery(General.GetFAMConString(), CommandType.StoredProcedure, "sp_GVouMaster_Insert", param);
}
string IQuery = "";
if (type == "ASC")
{
IQuery = "Update ReceiptMaster set VoucherNo ='" + model2.FirstOrDefault().VouchNo + "' , VoucherFlag = 'Y' " +
"Where DealerCode='" + model2.FirstOrDefault().CompCode + "' and ReceiptNo ='" + leadId + "'";
}
else if (type == "DE")
{
IQuery = "Update DailyExpenseMaster set VoucherNo ='" + model2.FirstOrDefault().VouchNo + "' , VoucherFlag = 'Y' " +
"Where DealerCode='" + model2.FirstOrDefault().CompCode + "' and ExpInvNo ='" + leadId + "'";
}
else if (type == "VReceipt")
{
IQuery = "Update ProdRecMaster set VouchNo ='" + model2.FirstOrDefault().VouchNo + "' , VoucherFlag = 'Y' " +
"Where DealerCode='" + model2.FirstOrDefault().CompCode + "' and RecNo ='" + leadId + "'";
}
else if (type == "CSI")
{
IQuery = "Update VehicleSaleMaster set VoucherNo ='" + model2.FirstOrDefault().VouchNo + "' , VoucherFlag = 'Y' " +
"Where DealerCode='" + model2.FirstOrDefault().CompCode + "' and TransCode ='" + leadId + "'";
}
if (sysfun.ExecuteQuery_NonQuery(IQuery))
{
IsSaved = true;
}
}
catch (Exception ex)
{
IsSaved = false;
throw ex;
}
return(IsSaved);
}