public static string Select_SalesPersonPerformanceWithDatesRange(string dealerCode, string FromDate, string ToDate)
{
List <SalesPersonPerformanceVM> lst = new List <SalesPersonPerformanceVM>();
DataTable dt = new DataTable();
string FDate = sysfun.SaveDate(FromDate).ToString();
string TDate = sysfun.SaveDate(ToDate).ToString();
string json = "";
var Serializer = new JavaScriptSerializer();
try
{
string sql = "exec SP_SalesPersonPerformanceWithDateRange '" + AuthBase.EmpCode + "' ,'" + dealerCode + "','" + FDate + "','" + TDate + "'";
dt = sysfun.GetData(sql);
if (dt.Rows.Count > 0)
{
lst = EnumerableExtension.ToList <SalesPersonPerformanceVM>(dt);
}
json = Serializer.Serialize(lst);
}
catch (Exception ex)
{
throw;
}
return(json);
}
public static bool Insert_Buying(BuyingCusVehicleVM model, string dealerCode)
{
try
{
if (string.IsNullOrEmpty(model.BuyingCode))
{
if (sysfun.IsExist("RegNo", model.RegNo, "UCS_Buying", dealerCode))
{
return(IsSaved);
}
strAutoCode = sysfun.AutoGen("UCS_Buying", "BuyingCode", DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("dd/MM/yyyy"), dealerCode);
//strAutoCode = sysfun.GetNewMaxID("UCS_Buying", "BuyingCode", 8, dealerCode);
}
else
{
strAutoCode = model.BuyingCode;
}
SqlParameter[] param =
{
new SqlParameter("@DealerCode ", dealerCode), //0
new SqlParameter("@BuyingCode ", strAutoCode), //1
new SqlParameter("@BuyingDate ", sysfun.SaveDate(model.BuyingDate)), //3
new SqlParameter("@RegNo ", model.RegNo), //5
new SqlParameter("@KM ", model.KM), //6
new SqlParameter("@RoadTaxPaid ", model.RoadTaxPaid), //7
new SqlParameter("@RoadTaxValidUpTo ", sysfun.SaveDate(model.RoadTaxValidUpTo)), //8
new SqlParameter("@IsInsured ", model.IsInsured), //9
new SqlParameter("@InsuranceValidUpTo ", sysfun.SaveDate(model.InsuranceValidUpTo)), //10
new SqlParameter("@BuyingPrice ", Convert.ToDecimal(model.BuyingPrice)), //11
new SqlParameter("@EvaluationCode ", model.EvaluationCode), //12
new SqlParameter("@EvaluationDate ", sysfun.SaveDate(model.EvaluationDate)), //13
new SqlParameter("@Pic01 ", model.Pic01), //19
new SqlParameter("@Pic02 ", model.Pic02), //20
new SqlParameter("@Pic03 ", model.Pic03), //21
new SqlParameter("@Pic04 ", model.Pic04), //22
new SqlParameter("@Pic05 ", model.Pic05), //23
new SqlParameter("@UpdUser ", AuthBase.UserId), //24
new SqlParameter("@UpdTerm ", General.CurrentIP), //27
new SqlParameter("@LocationCode ", model.LocationCode),
new SqlParameter("@BuyingMode ", model.BuyingMode)
};
if (ObjTrans.BeginTransaction(ref Trans) == true)
{
sysfun.ExecuteSP_NonQuery("Insert_Buying", param, Trans);
IsSaved = true;
}
}
catch (Exception)
{
throw;
}
return(IsSaved);
}
public static bool Insert_ProdMaster(ProdReceiptVM model, string dealerCode, ref string msg)
{
try
{
if (model.RecNo == "0" || model.RecNo == "" || model.RecNo == null)
{
strAutoCode = sysfun.AutoGen("ProdRecMaster", "RecNo", DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("dd/MM/yyyy"), model.DealerCode);
//strAutoCode = sysfun.GetNewMaxID("ProdRecMaster", "RecNo", 8, "00166");
//recDate = DateTime.Parse( model.RecDate);
}
else
{
strAutoCode = model.RecNo;
//string rec = model.RecDate;
//recDate = DateTime.Parse(rec);
}
SqlParameter[] param =
{
new SqlParameter("@DealerCode", model.DealerCode), //0
new SqlParameter("@RecNo", strAutoCode), //1
new SqlParameter("@RecDate", sysfun.SaveDate(model.RecDate)), //2
new SqlParameter("@DocumentNo", model.DocumentNo), //3
new SqlParameter("@UpdUser", AuthBase.UserId), //4
new SqlParameter("@UpdTerm", General.CurrentIP), //5
new SqlParameter("@VehTypeCode", model.VehTypeCode), //6
new SqlParameter("@VehRecCode", model.VehRecCode), //7
new SqlParameter("@Segment", model.Segment.Trim()), //8
new SqlParameter("@Category", model.Category.Trim()), //9
new SqlParameter("@Usage", model.Usage.Trim()), //10
new SqlParameter("@VendorCode", model.VendorCode.Trim()), //11
new SqlParameter("@Remarks", model.Remarks), //12
new SqlParameter("@OEMAnnounceDate", sysfun.SaveDate(model.OEMAnnounceDate)), //12
new SqlParameter("@TransportID", model.TransportID), //12
new SqlParameter("@TotalVehicleAmount", model.TotalVehicleAmount) //12
};
if (ObjTrans.BeginTransaction(ref Trans) == true)
{
sysfun.ExecuteSP_NonQuery("SP_ProdRecMaster_Insert", param, Trans);
IsSaved = true;
}
}
catch (Exception ex)
{
msg = ex.Message;
return(false);
}
return(IsSaved);
}
public void GetData()
{
string FromDate = sysfunc.SaveDate(txtFromDate.Text).ToString();
string ToDate = sysfunc.SaveDate(txtToDate.Text).ToString();
var Form = ddlForm.SelectedValue;
string sqlquery = "SP_VoucherStatus_Pending '" + Session["DealerCode"].ToString() + "','" + sysfunc.SaveDate(txtFromDate.Text) + "','" + sysfunc.SaveDate(txtToDate.Text) + "','" + Form + "'";
dt = sysfunc.GetData(sqlquery);
if (dt.Rows.Count > 0)
{
gvPendingVoucher.DataSource = dt;
gvPendingVoucher.DataBind();
}
}
protected void btnPrint_Click(object sender, EventArgs e)
{
if (!sec.UserRight("2576", "006"))
{
Response.Redirect("~/Test.aspx");
}
if (txtFromDate.Text == "" || txtToDate.Text == "")
{
lblMessage.Text = "Please select date range";
return;
}
if (!chkSelect.Checked)
{
string fitm = txtFromItemCode.Text;
string titm = txtToItemCode.Text;
if (fitm == "" || titm == "")
{
lblMessage.Text = "Please select item range";
return;
}
}
string ReportID = ReportID = "PartsSalesAndReturnDet";
//string FromDate = dpFromDate.Text.Substring(6, 4) + "/" + dpFromDate.Text.Substring(3, 2) + "/" + dpFromDate.Text.Substring(0, 2);
//string ToDate = dpToDate.Text.Substring(6, 4) + "/" + dpToDate.Text.Substring(3, 2) + "/" + dpToDate.Text.Substring(0, 2);
//string FromDate = txtFromDate.Date.ToString("yyyy/MM/dd");
//string ToDate = txtToDate.Date.ToString("yyyy/MM/dd");
string FromDate = sysFun.SaveDate(txtFromDate.Text).ToString();
string ToDate = sysFun.SaveDate(txtToDate.Text).ToString();
//string FromItem = ddlFromCode.SelectedValue;
//string ToItem = ddlToCode.SelectedValue;
string FromItem = txtFromItemCode.Text;
string ToItem = txtToItemCode.Text;
string PDFFileName = MakeReport(ReportID, FromDate, ToDate, FromItem, ToItem, Server.MapPath("../"), Server.MapPath("~/Download/"));
URL = "../../../../Download/rptViewerService.aspx?FileName=" + PDFFileName;
//URL = FilePath + "OpenPdf.aspx?FileName=" + FileName;
//txtPartItemDesc.Text = URL;
string fullsysURL = "window.open('" + URL + "', '_blank', 'height=800,width=1000,status=no,toolbar=no,menubar=no,location=no,scrollbars=yes,resizable=yes,titlebar=no');";
ScriptManager.RegisterStartupScript(this, typeof(string), "OPEN_WINDOW", fullsysURL, true);
}
public static bool Insert_SQMaster(SaleQuotMasterVM model)
{
DateTime recDate;
try
{
if (model.SaleQuotCode == "" || model.SaleQuotCode == null)
{
strAutoCode = sysfun.AutoGen("SaleQuotMaster", "SaleQuotCode", DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("dd/MM/yyyy"), model.DealerCode);
//strAutoCode = sysfun.GetNewMaxID("ProdRecMaster", "RecNo", 8, "00166");
//recDate = DateTime.Parse( model.RecDate);
}
else
{
strAutoCode = model.SaleQuotCode;
//string rec = sysfun.SaveDate( ).ToString();
//recDate = sysfun.SaveDate(model.BookRefDate);
//recDate = DateTime.Parse(rec);
}
SqlParameter[] param =
{
new SqlParameter("@DealerCode", model.DealerCode), //0
new SqlParameter("@SaleQuotCode", strAutoCode), //1
new SqlParameter("@SaleQuotDate", sysfun.SaveDate(model.SaleQuotDate)), //2
new SqlParameter("@RefLetterNo", model.RefLetterNo), //3
new SqlParameter("@ValidDays", model.ValidDays), //4
new SqlParameter("@CustomerCode", model.CustomerCode), //5
new SqlParameter("@Subject", model.Subject), //6
new SqlParameter("@UpdUser", AuthBase.UserId), //7
new SqlParameter("@UpdTerm", General.CurrentIP), //8
new SqlParameter("@PaymentTerms", model.PaymentTerms), //9
new SqlParameter("@Exemption", model.Exemption), //10
new SqlParameter("@ForceJajeure", model.ForceJajeure), //11
new SqlParameter("@Warranty", model.Warranty), //12
new SqlParameter("@DocGST", model.DocGST), //13
new SqlParameter("@DocNTN", model.DocNTN), //14
new SqlParameter("@DocBrocher", model.DocBrocher), //15
};
if (ObjTrans.BeginTransaction(ref Trans) == true)
{
sysfun.ExecuteSP_NonQuery("SP_Insert_SaleQuotMaster", param, Trans);
IsSaved = true;
}
}
catch (Exception)
{
if (ObjTrans.BeginTransaction(ref Trans) == true)
{
ObjTrans.RollBackTransaction(ref Trans);
}
throw;
}
return(IsSaved);
}
protected void gv_PSF_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
try
{
DataSet ds_update = new DataSet();
TextBox txtComplain = (TextBox)grdPostServiceFollowup.Rows[e.RowIndex].FindControl("txtComplain");
TextBox txtRemakrs = (TextBox)grdPostServiceFollowup.Rows[e.RowIndex].FindControl("txtRemarks");
DropDownList ddlSatisfied = (DropDownList)grdPostServiceFollowup.Rows[e.RowIndex].FindControl("ddl_Satisfied");
Label JobCode = (Label)grdPostServiceFollowup.Rows[e.RowIndex].FindControl("lblJobCode");
Label TransType = (Label)grdPostServiceFollowup.Rows[e.RowIndex].FindControl("lblTransType");
Label TransCode = (Label)grdPostServiceFollowup.Rows[e.RowIndex].FindControl("lblTransCode");
ds_update = (DataSet)Session["PostServiceFollowUp"];
//Uzair
foreach (DataRow dr in ds_update.Tables[0].Rows)
{
if (dr["JobCardCode"].ToString().Trim() == JobCode.Text.Trim())
{
dr["Complain"] = txtComplain.Text;
dr["Remarks"] = txtRemakrs.Text;
dr["Satisfied"] = ddlSatisfied.SelectedValue;
dr["FollowUpDate"] = sysFunc.SaveDate(DateTime.Now.ToString("dd-MM-yyyy"));
}
}
grdPostServiceFollowup.EditIndex = -1;
grdPostServiceFollowup.DataSource = ds_update;
grdPostServiceFollowup.DataBind();
if (ObjTrans.BeginTransaction(ref Trans) == true)
{
if (TransType.Text == "JobCard")
{
string sql = "update CRM_Post_PostServiceFollowup set Satisfied = '" + ddlSatisfied.SelectedValue.ToString() + "', Remarks = '" + txtRemakrs.Text + "' , FollowUpDate ='" + sysFunc.SaveDate(DateTime.Now.ToString("dd-MM-yyyy")) + "'" +
", Complain = '" + txtComplain.Text + "' where DealerCode = '" + Session["DealerCode"].ToString() + "' and TransCode = '" + TransCode.Text + "' ";
myFunc.ExecuteQuery(sql, Trans);
}
else if (TransType.Text == "Invoice")
{
string sql = "update CRM_Post_PostServiceFollowup set Satisfied = '" + ddlSatisfied.SelectedValue.ToString() + "', Remarks = '" + txtRemakrs.Text + "' , FollowUpDate ='" + sysFunc.SaveDate(DateTime.Now.ToString("dd-MM-yyyy")) + "'" +
", Complain = '" + txtComplain.Text + "' where DealerCode = '" + Session["DealerCode"].ToString() + "' and JobCardCode = '" + JobCode.Text + "' ";
myFunc.ExecuteQuery(sql, Trans);
}
}
Session["PostServiceFollowUp"] = ds_update;
ObjTrans.CommittTransaction(ref Trans);
}
catch (Exception ex)
{
//ObjTrans.CommittTransaction(ref Trans);
ObjTrans.RollBackTransaction(ref Trans);
lblMessage.Visible = true;
lblMessage.Text = ex.Message;
}
}
public static bool Insert_MonthlyCommisionMaster(MonthlyCommisionVM model, ref string msg)
{
try
{
if (string.IsNullOrEmpty(model.TransCode))
{
if (sysfun.IsExist("CommMonth", model.CommMonth, "MonthlyCommision", model.DealerCode, " And Service = '" + model.Service + "'"))
{
msg = "Monthly Commision for the Month " + model.CommMonth + " for the selected Service is already exists ";
//return false;
strAutoCode = sysfun.GetNewMaxID("MonthlyCommision", "TransCode", 8, model.DealerCode);
}
else
{
strAutoCode = sysfun.GetNewMaxID("MonthlyCommision", "TransCode", 8, model.DealerCode);
}
}
else
{
strAutoCode = model.TransCode;
}
SqlParameter[] param =
{
new SqlParameter("@DealerCode", model.DealerCode), //0
new SqlParameter("@TransCode", strAutoCode), //1
new SqlParameter("@TransDate", sysfun.SaveDate(model.TransDate)), //1
new SqlParameter("@CommMonth", model.CommMonth), //2
new SqlParameter("@UpdUser", AuthBase.UserId), //6
new SqlParameter("@UpdDate", DateTime.Now), //8
new SqlParameter("@UpdTerm", General.CurrentIP), //7
new SqlParameter("@Remarks", model.Remarks), //11
new SqlParameter("@Service", model.Service) //12
};
if (ObjTrans.BeginTransaction(ref Trans) == true)
{
if (sysfun.ExecuteSP_NonQuery("SP_Insert_MonthlyCommision", param, Trans))
{
IsSaved = true;
}
else
{
return(IsSaved);
}
}
}
catch (Exception ex)
{
msg = ex.Message;
}
return(IsSaved);
}
public static bool Insert_Reversal(ReversalVM model, ref string msg)
{
try
{
if (model.ReversalID == null || model.ReversalID == "")
{
strAutoCode = sysfun.AutoGen("Reversal", "ReversalID", DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("dd/MM/yyyy"), model.DealerCode);
}
else
{
strAutoCode = model.ReversalID;
}
SqlParameter[] param =
{
new SqlParameter("@DealerCode", model.DealerCode), //0
new SqlParameter("@ReversalID", strAutoCode), //1
new SqlParameter("@ReversalDate", sysfun.SaveDate(model.ReversalDate)), //2
new SqlParameter("@TransactionNo", model.TransactionNo), //3
new SqlParameter("@TrType", model.TrType), //4
new SqlParameter("@TransactionAmount", model.TransactionAmount), //5
new SqlParameter("@Remarks", model.Remarks), //6
new SqlParameter("@UpdUser", AuthBase.UserId), //7
new SqlParameter("@UpdDate", DateTime.Parse(DateTime.Now.ToShortDateString())), //7
new SqlParameter("@UpdTime", DateTime.Now), //7
new SqlParameter("@UpdTerminal", General.CurrentIP) //8
};
if (ObjTrans.BeginTransaction(ref Trans) == true)
{
if (sysfun.ExecuteSP_NonQuery("SP_Insert_Reversal", param, Trans))
{
IsSaved = true;
}
}
}
catch (Exception ex)
{
msg = ex.Message;
}
return(IsSaved);
}
public static bool Insert_DOMaster(VehicleDeliveryMasterVM model, string dealerCode)
{
try
{
if (model.DeliveryNo == "" || model.DeliveryNo == null)
{
strAutoCode = sysfun.AutoGen("VehicleDeliveryMaster", "DeliveryNo", DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("dd/MM/yyyy"), dealerCode);
}
else
{
strAutoCode = model.DeliveryNo;
}
SqlParameter[] param =
{
new SqlParameter("@DealerCode", dealerCode), //0
new SqlParameter("@DeliveryNo", strAutoCode), //1
new SqlParameter("@DeliveryDate", sysfun.SaveDate(model.DeliveryDate)), //2
new SqlParameter("@BookRefNo", model.BookRefNo), //3
new SqlParameter("@UpdUser", AuthBase.UserId), //4
new SqlParameter("@UpdTerm", General.CurrentIP), //5
new SqlParameter("@Type", model.Type), //6
new SqlParameter("@ReceiverCode", model.ReceiverCode), //7
new SqlParameter("@Remarks", model.Remarks), //8
new SqlParameter("@Segment", model.Segment), //9
new SqlParameter("@Usage", model.Usage), //10
new SqlParameter("@CusCode", model.CusCode), //11
new SqlParameter("@VehTypeCode", model.VehTypeCode), //12
new SqlParameter("@CusContNo", model.CusContNo), //13
new SqlParameter("@EmpCode", model.EmpCode)
};
if (ObjTrans.BeginTransaction(ref Trans) == true)
{
sysfun.ExecuteSP_NonQuery("SP_VehicleDeliveryMaster_Insert", param, Trans);
IsSaved = true;
}
//if (sysfun.ExecuteSP_NonQuery("SP_VehicleDeliveryMaster_Insert", param))
//{
// IsSaved = true;
//}
}
catch (Exception)
{
//ObjTrans.RollBackTransaction(ref Trans);
throw;
}
return(IsSaved);
}
protected void OnClick_btnCheck(object sender, EventArgs e)
{
string FDate = sysfun.SaveDate(txtFromDate.Text).ToString();
string TDate = sysfun.SaveDate(txtToDate.Text).ToString();
String sql = "exec sp_VTB_VehicleTrackingBoard'" + Session["DealerCode"].ToString() + "' , '" + FDate + "', '" + TDate + "'";
SysFunction sysFunc = new SysFunction();
DataTable dt = new DataTable();
dt = sysFunc.GetData(sql);
if (dt != null)
{
gvVehicleTrack.DataSource = dt;
gvVehicleTrack.DataBind();
}
}
public static bool Insert_Exchange(VehicleExchangeVM model, string dealerCode)
{
try
{
if (string.IsNullOrEmpty(model.ExchangeCode))
{
strAutoCode = sysfun.AutoGen("UCS_ExchangeVehicle", "ExchangeCode", DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("dd/MM/yyyy"), dealerCode);
}
else
{
strAutoCode = model.ExchangeCode;
}
SqlParameter[] param =
{
new SqlParameter("@DealerCode ", dealerCode), //0
new SqlParameter("@ExchangeCode ", strAutoCode), //1
new SqlParameter("@ExchangeDate ", sysfun.SaveDate(model.ExchangeDate)), //3
new SqlParameter("@LocationCode ", model.LocationCode),
new SqlParameter("@TypeOfBuying ", model.BuyingMode),
new SqlParameter("@BuyingCode ", model.BuyingCode), //5
new SqlParameter("@BrandCode ", model.BrandCode), //6
new SqlParameter("@ColorCode ", model.ColorCode), //7
new SqlParameter("@ProdCode ", model.ProdCode), //9
new SqlParameter("@VersionCode ", model.VersionCode), //10
new SqlParameter("@ChassisNo ", model.ChassisNo), //12
new SqlParameter("@EngineNo ", model.EngineNo), //13
new SqlParameter("@SalesPerson ", model.SalesPerson), //19
new SqlParameter("@UpdUser ", AuthBase.UserId), //24
new SqlParameter("@UpdTerm ", General.CurrentIP), //27
new SqlParameter("@NewVehicleType ", model.NewVehicleType), //9
new SqlParameter("@ExchangeRemarks ", model.ExchangeRemarks)
};
sysfun.ExecuteSP_NonQuery("Insert_ExchangeVehicle", param);
IsSaved = true;
}
catch (Exception)
{
throw;
}
return(IsSaved);
}
public static bool Insert_Commision(CommisionVM model, ref string msg)
{
try
{
if (string.IsNullOrEmpty(model.CommisionCode))
{
strAutoCode = sysfun.GetNewMaxID("CommisionMaster", "CommisionCode", 5, model.DealerCode);
}
else
{
strAutoCode = model.CommisionCode;
}
SqlParameter[] param =
{
new SqlParameter("@DealerCode", model.DealerCode), //0
new SqlParameter("@CommisionCode", strAutoCode), //1
new SqlParameter("@CommisionDate", sysfun.SaveDate(model.CommisionDate)), //1
new SqlParameter("@EmpCode", model.EmpCode), //2
new SqlParameter("@ProdCode", model.ProdCode == null ? (object)DBNull.Value : model.ProdCode.ToUpper()), //3
new SqlParameter("@CommPerc", model.CommPerc == null ? "0" : model.CommPerc), //4
new SqlParameter("@CommAmount", model.CommAmount == null ? "0" : model.CommAmount), //5
new SqlParameter("@UpdUser", AuthBase.UserId), //6
new SqlParameter("@UpdDate", DateTime.Now), //8
new SqlParameter("@UpdTerm", General.CurrentIP), //7
new SqlParameter("@DelFlag", "N"), //9
new SqlParameter("@BrandCode", model.BrandCode), //10
new SqlParameter("@VersionCode", model.VersionCode), //11
new SqlParameter("@ColorCode", model.ColorCode), //12
new SqlParameter("@Service", model.Service) //12
};
if (sysfun.ExecuteSP_NonQuery("SP_Insert_CommisionMaster", param))
{
IsSaved = true;
}
}
catch (Exception ex)
{
msg = ex.Message;
}
return(IsSaved);
}
public static bool Insert_VehicleReturnMaster(VehicleReturnMasterVM model)
{
try
{
if (model.ReturnCode == "" || model.ReturnCode == null)
{
strAutoCode = sysfun.AutoGen("VehicleReturnMaster", "ReturnCode", DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("dd/MM/yyyy"), model.DealerCode);
}
else
{
strAutoCode = model.ReturnCode;
}
SqlParameter[] param =
{
new SqlParameter("@DealerCode", model.DealerCode), //0
new SqlParameter("@VendorCode", model.VendorCode), //1
new SqlParameter("@ReturnCode", strAutoCode), //2
new SqlParameter("@ReturnDate", sysfun.SaveDate(model.ReturnDate)), //3
new SqlParameter("@Remarks", model.Remarks), //4
new SqlParameter("@GatePass", model.GatePass), //5
new SqlParameter("@DelFlag", 'N'), //6
new SqlParameter("@UpdUser", AuthBase.UserId), //7
new SqlParameter("@UpdDate", DateTime.Now), //8
new SqlParameter("@UpdTime", DateTime.Now), //9
new SqlParameter("@UpdTerm", General.CurrentIP), //10
new SqlParameter("@DealerCustomer", model.DealerCustomer), //11
new SqlParameter("@ReturnType", model.ReturnType), //12
new SqlParameter("@DocumentNo", model.DocumentNo), //13
};
if (ObjTrans.BeginTransaction(ref Trans) == true)
{
sysfun.ExecuteSP_NonQuery("SP_Inser_VehicleReturnMaster", param, Trans);
IsSaved = true;
}
}
catch (Exception)
{
ObjTrans.RollBackTransaction(ref Trans);
throw;
}
return(IsSaved);
}
public static bool Insert_VehLocTransMaster(VehicleLocTransVM model, string dealerCode, ref string msg)
{
try
{
if (model.TransNo == "" || model.TransNo == null)
{
strAutoCode = sysfun.AutoGen("VehicleLocTransMaster", "TransNo", DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("dd/MM/yyyy"), dealerCode);
}
else
{
strAutoCode = model.TransNo;
}
SqlParameter[] param =
{
new SqlParameter("@DealerCode", dealerCode), //0
new SqlParameter("@TransNo", strAutoCode), //1
new SqlParameter("@TransDate", sysfun.SaveDate(model.TransDate)), //2
new SqlParameter("@FromLocCode", model.FromLocCode), //3
new SqlParameter("@ToLocCode", model.ToLocCode), //4
new SqlParameter("@UpdUser", AuthBase.UserId), //5
new SqlParameter("@UpdDate", DateTime.Now.ToShortDateString()), //6
new SqlParameter("@UpdTime", DateTime.Now.ToShortTimeString()), //7
new SqlParameter("@UpdTerm", General.CurrentIP), //8
new SqlParameter("@Remarks", model.Remarks) //9
};
if (ObjTrans.BeginTransaction(ref Trans) == true)
{
sysfun.ExecuteSP_NonQuery("SP_Insert_VehicleLocTransMaster", param, Trans);
IsSaved = true;
}
}
catch (Exception ex)
{
msg = ex.Message;
}
return(IsSaved);
}
public static bool Insert_PriceOfferNegociation(UCS_EvaluationVM model, string dealerCode)
{
try
{
if (string.IsNullOrEmpty(model.EvaluationCode))
{
if (sysfun.IsExist("RegNo", model.RegNo, "UCS_EvaluationMaster", dealerCode))
{
return(IsSaved);
}
strAutoCode = sysfun.AutoGen("UCS_EvaluationMaster", "EvaluationCode", DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("dd/MM/yyyy"), dealerCode);
//strAutoCode = sysfun.GetNewMaxID("UCS_EvaluationMaster", "EvaluationCode", 8, dealerCode);
}
else
{
strAutoCode = model.EvaluationCode;
}
SqlParameter[] param =
{
new SqlParameter("@DealerCode ", dealerCode), //0
new SqlParameter("@EvaluationCode ", strAutoCode), //1
new SqlParameter("@EvaluationDate ", sysfun.SaveDate(model.EvaluationDate)), //2
new SqlParameter("@UCSourceCode ", model.UCSourceCode), //3
new SqlParameter("@RegNo ", model.RegNo), //4
new SqlParameter("@RegDate ", sysfun.SaveDate(model.RegDate)), //5
new SqlParameter("@DateOfInspection ", sysfun.SaveDate(model.DateOfInspection)), //6
new SqlParameter("@EngineNo ", model.EngineNo), //7
new SqlParameter("@ChassisNo ", model.ChassisNo), //8
new SqlParameter("@BrandCode ", model.BrandCode), //9
new SqlParameter("@ProdCode ", model.ProdCode), //10
new SqlParameter("@VersionCode ", model.VersionCode), //11
new SqlParameter("@ColorCode", model.ColorCode), //12
new SqlParameter("@CusCode ", model.CusCode), //13
new SqlParameter("@TransmissionType ", model.TransmissionType), //14
new SqlParameter("@UserName ", model.UserName), //15
new SqlParameter("@OfferCategory ", model.OfferCategory), //16
new SqlParameter("@CurrentMilage ", model.CurrentMilage), //17
new SqlParameter("@CustomerExpectedPrice", model.CustomerExpectedPrice), //18
new SqlParameter("@ExpectationCustomer ", model.ExpectationCustomer), //19
new SqlParameter("@BuyingPriceOffer ", model.BuyingPriceOffer), //20
new SqlParameter("@ReCondition ", model.ReCondition), //21
new SqlParameter("@UCSourceRemarks ", model.UCSourceRemarks), //22
new SqlParameter("@UpdUser", AuthBase.UserId), //23
new SqlParameter("@UpdTerm", General.CurrentIP), //24
new SqlParameter("@IsVerificationFromCPLC ", model.IsVerificationFromCPLC), //25
new SqlParameter("@RegistrationBook", model.RegistrationBook), //26
new SqlParameter("@SaleInvoice", model.SaleInvoice), //27
new SqlParameter("@ExchangeType", (model.OfferCategory == "Exchange" ? 'Y' : 'N')), //27
new SqlParameter("@CellNo ", model.CellNo), //21
};
if (ObjTrans.BeginTransaction(ref Trans) == true)
{
sysfun.ExecuteSP_NonQuery("Insert_PriceOfferNegociation", param, Trans);
IsSaved = true;
}
//if (sysfun.ExecuteSP_NonQuery("Insert_PriceOfferNegociation", param))
//{
// IsSaved = true;
//}
}
catch (Exception)
{
throw;
}
return(IsSaved);
}
protected void btnPrint_Click(object sender, EventArgs e)
{
SysFunction sysFunc = new SysFunction();
Data.DSReports data = new Data.DSReports();
ReportDocument RD = new ReportDocument();
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char), //0
new SqlParameter("@FromDate", SqlDbType.DateTime), //1
new SqlParameter("@ToDate", SqlDbType.DateTime), //2
};
param[0].Value = Session["DealerCode"].ToString();
param[1].Value = sysFunc.SaveDate(txtfromdate.Text);
param[2].Value = sysFunc.SaveDate(txtToDate.Text);
SqlDataReader rder = null;
// Store Procedure check and load
if (sysFunc.ExecuteSP("sp_2W_Service_PSTCollection", param, ref rder)) //Database SP
{
data.EnforceConstraints = false;
data.sp_2W_Service_PSTCollection.Load(rder); // DataSet SP
}
// Load in crystal report
//RD.Load(Server.MapPath("../PurchaseSaleReturnReport.rpt"));
RD.Load(Server.MapPath("/Reports/rptInputType.rpt"));
RD.DataDefinition.FormulaFields["DealerName"].Text = "'" + Session["DealerDesc"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerAdress"].Text = "'" + Session["DealerAddress"].ToString() + "'";
//RD.DataDefinition.FormulaFields["DealerPhone"].Text = "'" + Session["DealerPhone"].ToString() + "'";
// RD.DataDefinition.FormulaFields["DealerEmail"].Text = "'" + Session["DealerEmail"].ToString() + "'";
RD.DataDefinition.FormulaFields["ReportTitle"].Text = "'Services Tax Details'";
RD.DataDefinition.FormulaFields["Terminal"].Text = "'" + Request.ServerVariables["REMOTE_ADDR"].ToString() + "'";
RD.DataDefinition.FormulaFields["UserId"].Text = "'" + Session["UserName"].ToString() + "'";
RD.DataDefinition.FormulaFields["NTN"].Text = "'N.T.N # " + Session["DealerNTN"].ToString() + "'";
// RD.DataDefinition.FormulaFields["SalesTaxNo"].Text = "'Sales Tax No. " + Session["DealerSaleTaxNo"].ToString() + " '";
//rpt.DataDefinition.FormulaFields["UserCell"].Text = "'" + GetStringValuesAgainstCodes("CusCode", , "CellNo", "Customer") + "'";
RD.DataDefinition.FormulaFields["CompanyName"].Text = "'" + Session["DealerDesc"].ToString() + "'";
//RD.DataDefinition.FormulaFields["Pic"].Text = "'C:\\Users\\u_ahm\\OneDrive\\Documents\\Visual Studio 2010\\Projects\\WebApplication1\\WebApplication1\\" + Session["Logo"] + "'";
RD.DataDefinition.FormulaFields["Pic"].Text = "'" + Server.MapPath("~") + Session["Logo"] + "'";
// RD.DataDefinition.FormulaFields["ComplaintTypeCode"] = "'"+txtTicketNo.Text+"'";
// mention paper size
//RD.PrintOptions.PaperSize = PaperSize.PaperA4;
RD.Database.Tables[0].SetDataSource(data);
string FilePath = Server.MapPath("~/Download/");
string FileName = "CounterSalesDetail" + Session["DealerCode"].ToString() + DateTime.Now.ToString("ddMMyyyy") + ".pdf";
string File = FilePath + FileName;
//crReportDocument.SetDatabaseLogon("SDMS", "sdms161", "192.168.1.47", "SDMS");
RD.Database.Tables[0].SetDataSource(data);
Session["RD"] = RD;
//RD.ExportToDisk(ExportFormatType.PortableDocFormat, File);
string URL;
URL = "../../../Download/rptViewerService.aspx?FileName=" + FileName;
string fullURL = "window.open('" + URL + "', '_blank', 'height=800,width=1000,status=no,toolbar=no,menubar=no,location=no,scrollbars=yes,resizable=yes,titlebar=no');";
ScriptManager.RegisterStartupScript(this, typeof(string), "OPEN_WINDOW", fullURL, true);
}
public static bool Insert_TaskMaster(TaskVM model)
{
//DateTime DueDate = Convert.ToDateTime(model.DueDate);
//DateTime StartDate = Convert.ToDateTime(model.StartDate);
//DateTime EndDate = Convert.ToDateTime(model.EndDate);
try
{
if (model.TaskID == "0")
{
strAutoCode = sysfun.AutoGen("CRM_TaskMaster", "TaskID", DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("dd/MM/yyyy"), model.DealerCode);
}
else
{
strAutoCode = model.TaskID;
}
//DateTime EndTime = Convert.ToDateTime(model.EndTime);
// DateTime StartTime = Convert.ToDateTime(model.StartTime);
SqlParameter[] param =
{
new SqlParameter("@DealerCode", model.DealerCode), //0
new SqlParameter("@TaskID", strAutoCode), //1
new SqlParameter("@AssignTo", model.AssignTo), //2
new SqlParameter("@Prospect_ID", model.Prospect_ID), //5
new SqlParameter("@DueDate", (model.DueDate == null ? (object)DBNull.Value : sysfun.SaveDate(model.DueDate))), //6
new SqlParameter("@LeadSourceID", model.LeadSourceID), //7
new SqlParameter("@Contact", model.Contact), //8
new SqlParameter("@Email", model.Email), //9
new SqlParameter("@Lead_ID", model.Lead_ID), //12
new SqlParameter("@Comments", model.Comments), //13
new SqlParameter("@Frequency", model.Frequency), //14
new SqlParameter("@FreqTrun", model.FreqTrun), //15
new SqlParameter("@StartDate", sysfun.SaveDate(model.StartDate)), //16
new SqlParameter("@StartTime", sysfun.SaveTime(model.StartTime)), //17
new SqlParameter("@EndDate", (model.EndDate == null ? (object)DBNull.Value : sysfun.SaveDate(model.EndDate))), //18
new SqlParameter("@EndTime", (model.EndTime == null ? (object)DBNull.Value : Convert.ToDateTime(model.EndTime))), //19
new SqlParameter("@Ongoing", model.Ongoing), //20
new SqlParameter("@Reminder", model.Reminder), //21
new SqlParameter("@ReminderTime", (model.ReminderTime == null ? (object)DBNull.Value : Convert.ToDateTime(model.ReminderTime))), //22
new SqlParameter("@StatusTypeId", model.StatusTypeId), //24
new SqlParameter("@StatusId", model.StatusId), //25
new SqlParameter("@SubjectId", model.SubjectId), //26
new SqlParameter("@TaskTypeId", model.TaskTypeId), //27
};
if (sysfun.ExecuteSP_NonQuery("SP_Insert_TaskMaster", param))
{
IsSaved = true;
}
}
catch (Exception)
{
throw;
}
return(IsSaved);
}
protected void btnShowReport_Click(object sender, EventArgs e)
{
if (!sec.UserRight("2564", "006"))
{
Response.Redirect("~/Test.aspx");
}
if (dtFrom.Text == "" || dtTo.Text == "")
{
lblMSG.Text = "Please select dates";
return;
}
SqlDataReader rder;
ReportDocument RD = new ReportDocument();
DateTime FromDate;
DateTime ToDate;
string FDate = myFunc.SaveDate(dtFrom.Text).ToString();
string TDate = myFunc.SaveDate(dtTo.Text).ToString();
FromDate = Convert.ToDateTime(FDate);
ToDate = Convert.ToDateTime(TDate);
//ReportDocument RD = new ReportDocument();
//DataSet dsRpt = new DataSet();
DXBMS.Data.DataSet1 objDsReports = new Data.DataSet1();
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char, 5), //0
new SqlParameter("@FromDate", SqlDbType.DateTime), //0
new SqlParameter("@ToDate", SqlDbType.DateTime), //0
new SqlParameter("@Status", SqlDbType.VarChar, 10), //0
new SqlParameter("@EmpCode", SqlDbType.Char, 06) //0
};
param[0].Value = Session["DealerCode"].ToString();
param[1].Value = FromDate.ToString("yyyy-MM-dd");
param[2].Value = ToDate.ToString("yyyy-MM-dd");
param[3].Value = rbStatus.SelectedItem.Value.ToString();
param[4].Value = ddlAdvisorCode.SelectedValue;
DataTable dt = new DataTable();
string sql = "exec sp_JobCardDetailReport '" + Session["DealerCode"].ToString() + "','" + FromDate.ToString("yyyy-MM-dd") + "','" + ToDate.ToString("yyyy-MM-dd") + "','" + rbStatus.SelectedItem.Value.ToString() + "','" + ddlAdvisorCode.SelectedValue + "'";
dt = myFunc.GetData(sql);
RD.Load(Server.MapPath("../rptJobCardDateWise.rpt"));
RD.OpenSubreport(Server.MapPath("../JobCardSummary.rpt"));
RD.DataDefinition.FormulaFields["DealerDesc"].Text = "'" + Session["DealerDesc"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerAddress"].Text = "'" + Session["DealerAddress"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerPhone"].Text = "'" + Session["DealerPhone"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerEmail"].Text = "'" + Session["DealerEmail"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerFax"].Text = "'" + Session["DealerFax"].ToString() + "'";
RD.DataDefinition.FormulaFields["NTN"].Text = "'N.T.N # " + Session["DealerNTN"].ToString() + "'";
RD.DataDefinition.FormulaFields["SalesTaxNo"].Text = "'Sales Tax No. " + Session["DealerSaleTaxNo"].ToString() + " '";
RD.DataDefinition.FormulaFields["CompanyName"].Text = "'" + Session["DealerDesc"].ToString() + "'";
RD.DataDefinition.FormulaFields["UserID"].Text = "'" + Session["UserID"].ToString() + "'";
RD.DataDefinition.FormulaFields["FromCode"].Text = "'" + FDate + "'";
RD.DataDefinition.FormulaFields["ToCode"].Text = "'" + TDate + "'";
RD.DataDefinition.FormulaFields["Terminal"].Text = "'" + Environment.MachineName + "'";
RD.DataDefinition.FormulaFields["ReportTitle"].Text = "\"" + "Jobcard Detail Report" + "\"";
RD.DataDefinition.FormulaFields["CompanyName"].Text = "'" + Session["DealerDesc"].ToString() + "'";
//RD.DataDefinition.FormulaFields["DealershipName"].Text = "'Authorised " + Session["ParentDesc"].ToString() + " Dealership'";
//RD.Database.Tables[0].SetDataSource(objDsReports);
//RD.DataDefinition.FormulaFields["Pic"].Text = "'C:\\Users\\u_ahm\\OneDrive\\Documents\\Visual Studio 2010\\Projects\\WebApplication1\\WebApplication1\\" + Session["Logo"] + "'";
RD.DataDefinition.FormulaFields["Pic"].Text = "'" + Server.MapPath("~") + Session["Logo"] + "'";
RD.SetDataSource(dt);
string FilePath = Server.MapPath("~") + "\\Download\\";
string FileName = "Report.pdf";
string File = FilePath + FileName;
PdfDocument outputDocument = new PdfDocument();
Stream stream = RD.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
stream.Seek(0, SeekOrigin.Begin);
DirectoryInfo info = new DirectoryInfo(FilePath);
if (!info.Exists)
{
info.Create();
}
string path = Path.Combine(FilePath, FileName);
using (FileStream outputFileStream = new FileStream(path, FileMode.Create))
{
stream.CopyTo(outputFileStream);
}
stream.Dispose(); stream.Close();
string URL = "../../../../Download/PrintReport.aspx";
string fullURL = "window.open('" + URL + "', '_blank', 'height=800,width=1000,status=no,toolbar=no,menubar=no,location=no,scrollbars=yes,resizable=yes,titlebar=no');";
ScriptManager.RegisterStartupScript(this, typeof(string), "OPEN_WINDOW", fullURL, true);
//string FilePath = Server.MapPath("~") + "\\Download\\";
//string FileName = "JobCardDetail" + this.Session["DealerCode"].ToString() + DateTime.Now.ToString("ddMMyyyy") + ".pdf";
//string File = FilePath + FileName;
//Session["RD"] = RD;
//string URL = "../../../../Download/rptViewerService.aspx?ReportID="+ FileName;
//string fullURL = "window.open('" + URL + "', '_blank', 'height=800,width=1500,status=no,toolbar=no,menubar=no,location=no,scrollbars=yes,resizable=yes,titlebar=no');";
//ScriptManager.RegisterStartupScript(this, typeof(string), "OPEN_WINDOW", fullURL, true);
}
public static bool Insert_BOMaster(BookOrdMasterVM model, ref string msg)
{
IsSaved = false;
try
{
if (model.BookRefNo == null || model.BookRefNo == "" || model.BookRefNo == "0")
{
strAutoCode = sysfun.AutoGen("BookOrdMaster", "BookRefNo", DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("dd/MM/yyyy"), model.DealerCode);
}
else
{
strAutoCode = model.BookRefNo;
}
SqlParameter[] param =
{
new SqlParameter("@DealerCode", model.DealerCode), //0
new SqlParameter("@BookRefNo", strAutoCode), //1
new SqlParameter("@BookRefDate", sysfun.SaveDate(model.BookRefDate)), //2
new SqlParameter("@InvTypeCode", model.InvTypeCode), //3
new SqlParameter("@InvSubTypeCode", model.InvSubTypeCode), //4
new SqlParameter("@PriceTypeCode", model.PriceTypeCode), //5
new SqlParameter("@CusCode", model.CusCode), //6
new SqlParameter("@UpdUser", AuthBase.UserId), //7
new SqlParameter("@UpdTerm", General.CurrentIP), //8
new SqlParameter("@FHName", model.FHName), //9
new SqlParameter("@Address1", model.Address1), //10
new SqlParameter("@NIC", model.NIC), //11
new SqlParameter("@NTN", model.NTN), //12
new SqlParameter("@CellNo", model.CellNo), //13
new SqlParameter("@Email", model.Email), //14
new SqlParameter("@PhoneNo", model.PhoneNo), //15
new SqlParameter("@SalesPerson", model.SalesPerson), //16
new SqlParameter("@BookMode", model.BookMode), //17
new SqlParameter("@Segment", model.Segment), //18
new SqlParameter("@TaxType", model.TaxType), //19
new SqlParameter("@CusTypeCode", model.CusTypeCode), //20
new SqlParameter("@StockType", model.StockType), //21
new SqlParameter("@DeliveryLocation", model.DeliveryLocation), //22
new SqlParameter("@PaymentTerms", model.PaymentTerms), //23
new SqlParameter("@AccountOf", model.AccountOf), //24
new SqlParameter("@VehicleTotal", model.VehicleTotal), //25
new SqlParameter("@City", model.City), //26
new SqlParameter("@State", model.State), //27
new SqlParameter("@Country", model.Country), //28
new SqlParameter("@VehicleQty", model.VehicleQty), //28
new SqlParameter("@EnquiryNo", model.EnquiryNo), //28
new SqlParameter("@RemainingTotal", model.RemainingTotal), //15
};
if (ObjTrans.BeginTransaction(ref Trans) == true)
{
if (sysfun.ExecuteSP_NonQuery("SP_Insert_BookOrdMaster", param, Trans))
{
IsSaved = true;
}
else
{
return(IsSaved);
}
}
//if (sysfun.ExecuteSP_NonQuery("SP_VehicleDeliveryMaster_Insert", param))
//{
// IsSaved = true;
//}
}
catch (Exception ex)
{
//ObjTrans.RollBackTransaction(ref Trans);
msg = ex.Message;
}
return(IsSaved);
}
public static bool Insert_IRMaster(ReceiptMasterVM model)
{
DateTime recDate;
ChasisNo = model.ChasisNo;
EngineNo = model.EngineNo;
try
{
if (model.ReceiptNo == "" || model.ReceiptNo == null)
{
strAutoCode = sysfun.AutoGen("ReceiptMaster", "ReceiptNo", DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("dd/MM/yyyy"), model.DealerCode);
}
else
{
strAutoCode = model.ReceiptNo;
}
SqlParameter[] param =
{
new SqlParameter("@DealerCode", model.DealerCode), //0
new SqlParameter("@ReceiptNo", strAutoCode), //1
new SqlParameter("@ReceiptDate", sysfun.SaveDate(model.ReceiptDate)), //2
new SqlParameter("@CusCode", model.CusCode), //3
new SqlParameter("@Remarks", model.Remarks), //4
new SqlParameter("@ISFullAndFinal", 'N'), //5
new SqlParameter("@FullAndFinalReceiveable", 0.0), //6
new SqlParameter("@FullAndFinalPenalty", 0.0), //7
new SqlParameter("@FullAndFinalTotalReceiveable", 0.0), //8
new SqlParameter("@FullAndFinalDiscount", 0.0), //9
new SqlParameter("@CreateDate", sysfun.SaveDate(DateTime.Now.ToString("dd-MM-yyyy"))), //10
new SqlParameter("@CreateTime", sysfun.SaveDate(DateTime.Now.ToString("dd-MM-yyyy"))), //11
new SqlParameter("@CreatedBy", AuthBase.UserId), //12
new SqlParameter("@CreateTerm", General.CurrentIP), //13
new SqlParameter("@DelFlag", 'N'), //14
new SqlParameter("@PostFlag", 'Y'), //15
new SqlParameter("@PostDate", sysfun.SaveDate(DateTime.Now.ToString("dd-MM-yyyy"))), //16
new SqlParameter("@TransferStatus", 'C'), //17
new SqlParameter("@TransferDate", sysfun.SaveDate(DateTime.Now.ToString("dd-MM-yyyy"))), //18
new SqlParameter("@SoftwareVersion", DBNull.Value), //19
new SqlParameter("@CommunicationVersion", DBNull.Value), //20
new SqlParameter("@EmpCode", model.EmpCode), //21
new SqlParameter("@EmpDesc", model.EmpDesc), //22
new SqlParameter("@ProdDesc", model.ProdDesc), //23
new SqlParameter("@EngineNo", model.EngineNo), //24
new SqlParameter("@ChasisNo", model.ChasisNo), //25
new SqlParameter("@Type", model.Type), //26
new SqlParameter("@OldReceiptNo", DBNull.Value), //27
new SqlParameter("@InvoiceDate", sysfun.SaveDate(model.InvoiceDate)), //28
new SqlParameter("@BalanceWithoutPenalty", 0), //28
new SqlParameter("@BalancePenalty", 0), //28
new SqlParameter("@TotalBalance", 0), //24
new SqlParameter("@LastActualTransDate", sysfun.SaveDate(model.ReceiptDate)), //25
new SqlParameter("@LastPenaltyTransDate", sysfun.SaveDate(model.ReceiptDate)), //26
new SqlParameter("@PrintCounter", DBNull.Value), //27
new SqlParameter("@InvoiceNo", model.InvoiceNo), //28
new SqlParameter("@PRBNo", model.PRBNo), //28
new SqlParameter("@SONo", model.SONo), //28
new SqlParameter("@FormName", model.FormName), //28
new SqlParameter("@TransType", model.TransType), //28
};
if (ObjTrans.BeginTransaction(ref Trans) == true)
{
sysfun.ExecuteSP_NonQuery("SP_Insert_ReceiptMaster", param, Trans);
IsSaved = true;
}
}
catch (Exception)
{
ObjTrans.RollBackTransaction(ref Trans);
throw;
}
return(IsSaved);
}
public static bool Insert_Event(EventVM model)
{
try
{
if (model.Event_ID.Trim() == "0" || model.Event_ID.Trim() == "")
{
string getNextEventID = "declare @lastval varchar(14),@id int " +
"set @id = (select count(*) from Event) " +
"set @id=@id+1 " +
"if len(@id) = 1 " +
"set @lastval= '0000' " +
"if len(@id) = 2 " +
"set @lastval='000' " +
"if len(@id) = 3 " +
"set @lastval='00' " +
"if len(@id) >= 4 " +
"set @lastval='0' " +
"declare @i varchar(14) " +
"set @i = CAST(@id as varchar(14)) " +
"set @lastval = @lastval+@i " +
"select @lastval as eventID";
dt = DataAccess.getDataTableByQuery(getNextEventID, nullSqlParam, General.GetBMSConString());
strAutoCode = dt.Rows[0]["eventID"].ToString();
}
else
{
strAutoCode = model.Event_ID;
}
SqlParameter[] param =
{
new SqlParameter("@DealerCode", model.DealerCode), //0
new SqlParameter("@EventID", strAutoCode), //1
new SqlParameter("@EventDate", General.CurrentDate), //2
new SqlParameter("@EventDesc", model.EventDesc.Trim()), //3
new SqlParameter("@AssignID", model.AssignID), //4
new SqlParameter("@StartDate", sysfun.SaveDate(model.StartDate)), //5
new SqlParameter("@EndDate", sysfun.SaveDate(model.EndDate)), //6
new SqlParameter("@UpdUser", AuthBase.UserId), //7
new SqlParameter("@UpdTerm", General.CurrentIP), //8
new SqlParameter("@ExpBudget", model.ExpBudget), //9
new SqlParameter("@ActBudget", model.ActBudget), //10
new SqlParameter("@Status", model.Status), //11
new SqlParameter("@Feedback", model.Feedback), //12
new SqlParameter("@EventType", model.EventType), //13
new SqlParameter("@ProdCode", model.ProdCode), //14
new SqlParameter("@VersionCode", model.VersionCode), //15
new SqlParameter("@ColorCode", model.ColorCode == "0" ? (object)DBNull.Value : model.ColorCode), //16
new SqlParameter("@BrandCode", model.BrandCode == "0" ? (object)DBNull.Value : model.BrandCode), //17
};
dt = DataAccess.getDataTable("Sp_Insert_Event", param, General.GetBMSConString());
if (dt.Rows.Count > 0)
{
}
IsSaved = true;
}
catch (Exception)
{
throw;
}
return(IsSaved);
}
///Insert Button
protected void btnInsert_Click(object sender, EventArgs e)
{
if (txtunitdec.Text == "")
{
sysFuncs.UserMsg(lblMessage, Color.Red, "Please Enter Unit Description", txtunitdec);
return;
}
else
{
lblMessage.Text = string.Empty;
}
DataTable dt = (DataTable)Session["UnitCategoryDS"];
// Check value in GridView TextBOX
foreach (DataRow dr in dt.Rows)
{
if (dr["UnitDesc"].ToString().ToUpper() == txtunitdec.Text.ToUpper())
{
sysFunc.UserMsg(lblMessage, Color.Red, "Alredy Exist");
return;
}
}
try
{
string max = sysFuncs.GetNewMaxID("Unit", "UnitCode", 4, Session["DealerCode"].ToString());
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char, 5), //0
new SqlParameter("@UnitCode", SqlDbType.Char, 4), //1
new SqlParameter("@UnitDesc", SqlDbType.VarChar, 50), //2
new SqlParameter("@UpdUser", SqlDbType.VarChar, 50), //3
new SqlParameter("@UpdDate", SqlDbType.DateTime), //4
new SqlParameter("@UpdTime", SqlDbType.DateTime), //5
new SqlParameter("@UpdTerm", SqlDbType.VarChar, 50), //6
};
param[0].Value = Session["DealerCode"].ToString();
param[1].Value = max;
param[2].Value = txtunitdec.Text.ToUpper().Trim();
param[3].Value = Session["UserName"].ToString();
param[4].Value = sysFunc.SaveDate(DateTime.Now.ToString("dd-MM-yyyy"));
param[5].Value = DateTime.Now;
param[6].Value = "1";
sysFunc.ExecuteSP_NonQuery("SP_Insert_Unit", param);
sysFunc.ClearTextBoxes(Page);
createGrid();
sysFuncs.UserMsg(lblMessage, Color.Green, "Data Inserted", txtunitdec);
//lblMessage.Text = "New Unit Category Inserted.";
}
catch (Exception ex)
{
sysFunc.UserMsg(lblMessage, System.Drawing.Color.Red, ex.Message);
}
}
protected void btnShowReport_Click(object sender, EventArgs e)
{
if (!sec.UserRight("2585", "006"))
{
Response.Redirect("~/Test.aspx");
}
SqlDataReader rder;
ReportDocument RD = new ReportDocument();
DataTable dt = new DataTable();
DateTime FromDate;
DateTime ToDate;
if (dtFrom.Text == "" || dtTo.Text == "")
{
lblMSG.Text = "Please select dates";
return;
}
string FDate = myFunc.SaveDate(dtFrom.Text).ToString();
string TDate = myFunc.SaveDate(dtTo.Text).ToString();
FromDate = Convert.ToDateTime(FDate);
ToDate = Convert.ToDateTime(TDate);
DXBMS.Data.DataSet1 objDsReports = new Data.DataSet1();
if (rbStatus.SelectedItem.Text == "GST")
{
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char, 5), //0
new SqlParameter("@FromDate", SqlDbType.DateTime), //0
new SqlParameter("@ToDate", SqlDbType.DateTime), //0
};
param[0].Value = Session["DealerCode"].ToString();
param[1].Value = FromDate.ToString("yyyy-MM-dd");
param[2].Value = ToDate.ToString("yyyy-MM-dd");
string sql = "exec SP__Get_rptGSTDetailReport '" + Session["DealerCode"].ToString() + "','" + FromDate.ToString("yyyy-MM-dd") + "','" + ToDate.ToString("yyyy-MM-dd") + "'";
dt = myFunc.GetData(sql);
RD.PrintOptions.PaperSize = PaperSize.PaperA4;
RD.Load(Server.MapPath("../GSTDetailReport.rpt"));
}
else if (rbStatus.SelectedItem.Text == "Combine")
{
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char, 5), //0
new SqlParameter("@FromDate", SqlDbType.DateTime), //0
new SqlParameter("@ToDate", SqlDbType.DateTime), //0
};
param[0].Value = Session["DealerCode"].ToString();
param[1].Value = FromDate.ToString("yyyy-MM-dd");
param[2].Value = ToDate.ToString("yyyy-MM-dd");
string sql = "exec SP__Get_rptComDetailReport '" + Session["DealerCode"].ToString() + "','" + FromDate.ToString("yyyy-MM-dd") + "','" + ToDate.ToString("yyyy-MM-dd") + "'";
dt = myFunc.GetData(sql);
RD.PrintOptions.PaperSize = PaperSize.PaperA4;
RD.Load(Server.MapPath("../ConbineTaxDetail.rpt"));
}
else
{
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char, 5), //0
new SqlParameter("@FromDate", SqlDbType.DateTime), //0
new SqlParameter("@ToDate", SqlDbType.DateTime), //0
};
param[0].Value = Session["DealerCode"].ToString();
param[1].Value = FromDate.ToString("yyyy-MM-dd");
param[2].Value = ToDate.ToString("yyyy-MM-dd");
string sql = "exec SP__Get_rptPSTDetailReport '" + Session["DealerCode"].ToString() + "','" + FromDate.ToString("yyyy-MM-dd") + "','" + ToDate.ToString("yyyy-MM-dd") + "'";
dt = myFunc.GetData(sql);
RD.PrintOptions.PaperSize = PaperSize.PaperA4;
RD.Load(Server.MapPath("../PSTDetailReport.rpt"));
}
RD.DataDefinition.FormulaFields["DealerDesc"].Text = "'" + Session["DealerDesc"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerAddress"].Text = "'" + Session["DealerAddress"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerPhone"].Text = "'" + Session["DealerPhone"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerEmail"].Text = "'" + Session["DealerEmail"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerFax"].Text = "'" + Session["DealerFax"].ToString() + "'";
RD.DataDefinition.FormulaFields["NTN"].Text = "'N.T.N # " + Session["DealerNTN"].ToString() + "'";
RD.DataDefinition.FormulaFields["SalesTaxNo"].Text = "'Sales Tax No. " + Session["DealerSaleTaxNo"].ToString() + " '";
RD.DataDefinition.FormulaFields["CompanyName"].Text = "'" + Session["DealerDesc"].ToString() + "'";
RD.DataDefinition.FormulaFields["UserID"].Text = "'" + Session["UserID"].ToString() + "'";
RD.DataDefinition.FormulaFields["FromCode"].Text = "'" + FDate + "'";
RD.DataDefinition.FormulaFields["ToCode"].Text = "'" + TDate + "'";
RD.DataDefinition.FormulaFields["Terminal"].Text = "'" + Environment.MachineName + "'";
if (rbStatus.SelectedItem.Text == "PST")
{
RD.DataDefinition.FormulaFields["ReportTitle"].Text = "\"" + "PST Collection" + "\"";
}
else if (rbStatus.SelectedItem.Text == "Combine")
{
RD.DataDefinition.FormulaFields["ReportTitle"].Text = "\"" + "Combine Tax Collection" + "\"";
}
else
{
RD.DataDefinition.FormulaFields["ReportTitle"].Text = "\"" + "GST Collection" + "\"";
}
RD.DataDefinition.FormulaFields["CompanyName"].Text = "'" + Session["DealerDesc"].ToString() + "'";
RD.DataDefinition.FormulaFields["Pic"].Text = "'" + Server.MapPath("~") + Session["Logo"] + "'";
RD.SetDataSource(dt);
// Session["RD"]=RD;
//// convert and show
string FilePath = Server.MapPath("~") + "\\Download\\";
string FileName = "Report.pdf";
string File = FilePath + FileName;
Session["RD"] = RD;
string URL;
URL = "../../../../Download/OpenPdf.aspx?ReportID=" + FileName;
string fullURL = "window.open('" + URL + "', '_blank', 'height=800,width=1000,status=no,toolbar=no,menubar=no,location=no,scrollbars=yes,resizable=yes,titlebar=no');";
ScriptManager.RegisterStartupScript(this, typeof(string), "OPEN_WINDOW", fullURL, true);
//string FilePath = Server.MapPath("~") + "\\Download\\";
//string FileName = "Report.pdf";
//string File = FilePath + FileName;
//PdfDocument outputDocument = new PdfDocument();
//Stream stream = RD.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
//stream.Seek(0, SeekOrigin.Begin);
//DirectoryInfo info = new DirectoryInfo(FilePath);
//if (!info.Exists)
//{
// info.Create();
//}
//string path = Path.Combine(FilePath, FileName);
//using (FileStream outputFileStream = new FileStream(path, FileMode.Create))
//{
// stream.CopyTo(outputFileStream);
//}
//stream.Dispose(); stream.Close();
//string URL = "../../../../Download/PrintReport.aspx";
//string fullURL = "window.open('" + URL + "', '_blank', 'height=800,width=1000,status=no,toolbar=no,menubar=no,location=no,scrollbars=yes,resizable=yes,titlebar=no');";
//ScriptManager.RegisterStartupScript(this, typeof(string), "OPEN_WINDOW", fullURL, true);
}
protected void btnPrint_Click(object sender, EventArgs e)
{
SysFunction SysFunc = new SysFunction();
string FDate = SysFunc.SaveDate(txtFromDate.Text).ToString();
string TDate = SysFunc.SaveDate(txtToDate.Text).ToString();
PdfDocument outputDocument = new PdfDocument();
string desktopPath = Environment.GetFolderPath(Environment.SpecialFolder.Desktop);
string extension = "FileName.pdf";
desktopPath += @"\" + extension;
SqlDataReader rder;
ReportDocument RD = new ReportDocument();
DataTable dt = new DataTable();
string sql;
DataSet dsRpt = new DataSet();
DXBMS.Data.DSReports objDsReports = new Data.DSReports();
if (ViewState["SparePart"].ToString() == "PTV")
{
if (!sec.UserRight("2568", "006"))
{
Response.Redirect("~/Test.aspx");
}
sql = "exec SP_PaymenttoVendor_Select '" + Session["DealerCode"].ToString() + "','" + FDate + "','" + TDate + "'";
RD.Load(Server.MapPath("~/Modules/SpareParts/SpareReports/PaymentToVendorDetailReport.rpt"));
RD.DataDefinition.FormulaFields["ReportTitle"].Text = "\"" + "PAYMENT TO VENDOR DETAIL" + "\"";
}
else if (ViewState["SparePart"].ToString() == "SA")
{
if (!sec.UserRight("2569", "006"))
{
Response.Redirect("~/Test.aspx");
}
sql = "exec SP_StockAdjustment_DetailReport '" + Session["DealerCode"].ToString() + "','" + FDate + "','" + TDate + "'";
RD.Load(Server.MapPath("~/Modules/SpareParts/SpareReports/crtStockAdjustment.rpt"));
RD.DataDefinition.FormulaFields["ReportTitle"].Text = "\"" + "Stock Adjustment Detail Report" + "\"";
}
else if (ViewState["SparePart"].ToString() == "IL")
{
if (!sec.UserRight("2571", "006"))
{
Response.Redirect("~/Test.aspx");
}
sql = "exec sp2W_Spare_InvoiceDetail '" + Session["DealerCode"].ToString() + "','" + FDate + "','" + TDate + "'";
RD.Load(Server.MapPath("../rptInvoices.rpt"));
RD.DataDefinition.FormulaFields["ReportTitle"].Text = "\"" + "Invoices Detail Report" + "\"";
}
else if (ViewState["SparePart"].ToString() == "IR")
{
if (!sec.UserRight("2590", "006"))
{
Response.Redirect("~/Test.aspx");
}
sql = "exec sp2W_Revenue_InvoiceDetail '" + Session["DealerCode"].ToString() + "','" + FDate + "','" + TDate + "'";
RD.Load(Server.MapPath("../rptInvoiceRevenue.rpt"));
RD.DataDefinition.FormulaFields["ReportTitle"].Text = "\"" + "Invoices Revenue Detail Report" + "\"";
}
else if (ViewState["SparePart"].ToString() == "DS")
{
if (!sec.UserRight("2572", "006"))
{
Response.Redirect("~/Test.aspx");
}
string cond = "";
sql = "Sp_2W_CounterSaleDetail_rpt '" + Session["DealerCode"].ToString() + "','" + FDate + "','" + TDate + "'" + cond;
RD.Load(Server.MapPath("../rptCounterSaleDetail.rpt"));
RD.DataDefinition.FormulaFields["FromCode"].Text = "\"" + Convert.ToDateTime(FDate.ToString()).ToString("dd/MM/yyyy") + "\"";
RD.DataDefinition.FormulaFields["ToCode"].Text = "\"" + Convert.ToDateTime(TDate.ToString()).ToString("dd/MM/yyyy") + "\"";
RD.DataDefinition.FormulaFields["ReportTitle"].Text = "\"" + "Direct Sale Detail Report" + "\"";
}
else if (ViewState["SparePart"].ToString() == "GRN")
{
if (!sec.UserRight("2573", "006"))
{
Response.Redirect("~/Test.aspx");
}
sql = "exec sp_GRNDetailList '" + Session["DealerCode"].ToString() + "','" + FDate + "','" + TDate + "'";
RD.Load(Server.MapPath("../rptPartsReceivedDetail.rpt"));
RD.DataDefinition.FormulaFields["ReportTitle"].Text = "\"" + "GRN DETAIL REPORT" + "\"";
RD.DataDefinition.FormulaFields["FromCode"].Text = "'" + FDate + "'";
RD.DataDefinition.FormulaFields["ToCode"].Text = "'" + TDate + "'";
}
else
{
if (!sec.UserRight("2570", "006"))
{
Response.Redirect("~/Test.aspx");
}
sql = "exec sp_2W_Spares_Aging'" + Session["DealerCode"].ToString() + "','" + FDate + "','" + TDate + "' ,'" + txtCustomer.Text + "'";
RD.Load(Server.MapPath("../rptCustomerWiseOutstandingSummary.rpt"));
RD.DataDefinition.FormulaFields["ReportTitle"].Text = "\"" + "Customer Wise OutStanding Summary Report" + "\"";
}
dt = SysFunc.GetData(sql);
RD.PrintOptions.PaperSize = PaperSize.PaperA4;
RD.DataDefinition.FormulaFields["DealerPhone"].Text = "'" + Session["DealerPhone"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerEmail"].Text = "'" + Session["DealerEmail"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerDesc"].Text = "'" + Session["DealerDesc"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerAddress"].Text = "'" + Session["DealerAddress"].ToString() + "'";
RD.DataDefinition.FormulaFields["UserID"].Text = "'" + Session["UserID"].ToString() + "'";
//RD.DataDefinition.FormulaFields["FromCode"].Text = "'" + FDate + "'";
//RD.DataDefinition.FormulaFields["ToCode"].Text = "'" + TDate + "'";
RD.DataDefinition.FormulaFields["Terminal"].Text = "'" + Environment.MachineName + "'";
RD.DataDefinition.FormulaFields["CompanyName"].Text = "'" + Session["DealerDesc"].ToString() + "'";
//RD.DataDefinition.FormulaFields["Pic"].Text = "'C:\\Users\\u_ahm\\OneDrive\\Documents\\Visual Studio 2010\\Projects\\WebApplication1\\WebApplication1\\" + Session["Logo"] + "'";
RD.DataDefinition.FormulaFields["Pic"].Text = "'" + Server.MapPath("~") + Session["Logo"] + "'";
//RD.DataDefinition.FormulaFields["DealershipName"].Text = "'Authorised " + Session["ParentDesc"].ToString() + " Dealership'";
RD.Database.Tables[0].SetDataSource(dt);
string FilePath = Server.MapPath("~") + "\\Download\\";
string FileName = "Report.pdf";
string File = FilePath + FileName;
Stream stream = RD.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
stream.Seek(0, SeekOrigin.Begin);
DirectoryInfo info = new DirectoryInfo(FilePath);
if (!info.Exists)
{
info.Create();
}
string path = Path.Combine(FilePath, FileName);
using (FileStream outputFileStream = new FileStream(path, FileMode.Create))
{
stream.CopyTo(outputFileStream);
}
stream.Dispose(); stream.Close();
string URL = "../../../../Download/PrintReport.aspx";
string fullURL = "window.open('" + URL + "', '_blank', 'height=800,width=1000,status=no,toolbar=no,menubar=no,location=no,scrollbars=yes,resizable=yes,titlebar=no');";
ScriptManager.RegisterStartupScript(this, typeof(string), "OPEN_WINDOW", fullURL, true);
//RD.ExportToDisk(ExportFormatType.PortableDocFormat, File);
//string URL;
//URL = Page.ResolveUrl("~/Download/rptViewerService.aspx?FileName=") + FileName;
//string fullURL = "window.open('" + URL + "', '_blank', 'height=800,width=1000,status=no,toolbar=no,menubar=no,location=no,scrollbars=yes,resizable=yes,titlebar=no');";
//ScriptManager.RegisterStartupScript(this, typeof(string), "OPEN_WINDOW", fullURL, true);
//string URL = "../Criteria/POView.aspx?CusWise=" + "&ReportID=" + RptName.ToString() + "&fromDate=" + FromDate + "&ToDate=" + ToDate;
//string fullURL = "window.open('" + URL + "', '_blank', 'height=800,width=1000,status=no,toolbar=no,menubar=no,location=no,scrollbars=yes,resizable=yes,titlebar=no');";
//ScriptManager.RegisterStartupScript(this, typeof(string), "OPEN_WINDOW", fullURL, true);
}
protected void btn_save_Click(object sender, EventArgs e)
{
string strAutoCode = string.Empty;
string active = "N";
string leavedate = txtleaving_date.Text;
if (txtEmpID.BorderColor == Color.Red)
{
success_add_item.Visible = true;
success_add_item.Text = "This Employee No. is already in use";
return;
}
if (cbActive.Checked == true)
{
active = "Y";
}
if (cbActive.Checked == false)
{
active = "N";
}
if (active == "Y" && txtleaving_date.Text.Trim() != string.Empty)
{
success_add_item.Visible = true;
success_add_item.Text = "Remove Leaving Date If you are still Employee";
return;
}
if (active == "N" && txtleaving_date.Text == "")
{
success_add_item.Visible = true;
success_add_item.Text = "Enter Leaving Date";
return;
}
//if(ddldep_code.SelectedValue == "001" && ddldesig_code.SelectedValue == "001")
//{
// if(txtEmail.Text == "")
// {
// RegularExpressionValidator4.IsValid = false;
// RegularExpressionValidator4.Visible = true;
// RegularExpressionValidator4.ErrorMessage = "Email address is necessary";
// return;
// }else
// {
// RegularExpressionValidator4.Visible = false;
// RegularExpressionValidator4.ErrorMessage = "";
// }
//}
try
{
//join_date = Convert.ToDateTime(txtjoining_date.Text).Date;
join_date = DateTime.ParseExact(txtjoining_date.Text, "dd-MM-yyyy", null);
//dob_date = Convert.ToDateTime(txtdob.Text).Date;
dob_date = DateTime.ParseExact(txtdob.Text, "dd-MM-yyyy", null);
if (txtleaving_date.Text.Trim() != string.Empty)
{
leav_date = DateTime.ParseExact(txtleaving_date.Text, "dd-MM-yyyy", null);
}
if (ddlEmployee.SelectedIndex == 0)
{
strAutoCode = SysFunc.GetNewMaxID("DealerEmp", "EmpCode", 3, Session["DealerCode"].ToString());
}
else
{
strAutoCode = ddlEmployee.SelectedItem.Value;
}
if (SysFunc.ValidateDate(txtdob.Text) == true)
{
success_add_item.Visible = true;
success_add_item.Text = "Enter Valid DOB, not greater than current Date";
return;
}
if (SysFunc.ValidateDate(txtjoining_date.Text) == true)
{
success_add_item.Visible = true;
success_add_item.Text = "Enter Valid Joining Date, not greater than current Date";
return;
}
if (SysFunc.ValidateDate(txtleaving_date.Text) == true && txtleaving_date.Text != string.Empty)
{
success_add_item.Visible = true;
success_add_item.Text = "Enter Valid Leaving, not greater than current Date";
return;
}
if (dob_date >= join_date)
{
success_add_item.Visible = true;
success_add_item.Text = "Enter Valid DOB, not greater than or equal to Joining Date";
return;
}
if (join_date >= leav_date && txtleaving_date.Text != string.Empty)
{
success_add_item.Visible = true;
success_add_item.Text = "Joining Date not greater than or equal to Leaving Date";
return;
}
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char), //0
new SqlParameter("@EmpCode", SqlDbType.Char), //1
new SqlParameter("@EmpID", SqlDbType.Char), //2
new SqlParameter("@EmpName", SqlDbType.VarChar), //3
new SqlParameter("@JoiningDate", SqlDbType.DateTime), //4
new SqlParameter("@ContactNo", SqlDbType.VarChar), //5
new SqlParameter("@DOB", SqlDbType.DateTime), //6
new SqlParameter("@Experience", SqlDbType.TinyInt), //7
new SqlParameter("@LeavingDate", SqlDbType.DateTime), //8
new SqlParameter("@DesigCode", SqlDbType.Char), //9
new SqlParameter("@DeptCode", SqlDbType.Char), //10
new SqlParameter("@Remarks", SqlDbType.VarChar), //11
new SqlParameter("@PrimaryTechCode", SqlDbType.Char), //12
new SqlParameter("@UserName", SqlDbType.VarChar), //13
new SqlParameter("@Password", SqlDbType.VarChar), //14
new SqlParameter("@Role", SqlDbType.VarChar), //15
new SqlParameter("@Active", SqlDbType.Char), //16
new SqlParameter("@SecurityUserID", SqlDbType.Char), //17
new SqlParameter("@CNIC", SqlDbType.Char), //18
new SqlParameter("@Picture", SqlDbType.VarChar), //19
new SqlParameter("@Email", SqlDbType.VarChar) //20
};
param[0].Value = Session["DealerCode"].ToString();
param[1].Value = strAutoCode;
param[2].Value = txtEmpID.Text;
param[3].Value = txtEmp_name.Text;
param[4].Value = join_date;
param[5].Value = txtcontact_no.Text;
param[6].Value = dob_date;
param[7].Value = txtexp.Text;
param[8].Value = SysFunc.SaveDate(txtleaving_date.Text);
param[9].Value = ddldesig_code.SelectedItem.Value;
param[10].Value = ddldep_code.SelectedItem.Value;
param[11].Value = txtremarks.Text;
param[12].Value = "";
param[13].Value = "";
param[14].Value = "";
param[15].Value = "";
param[16].Value = active;
param[17].Value = string.Empty;
param[18].Value = txtnic_no.Text.Trim();
param[19].Value = Session["EmployeeImagePath"].ToString();
param[20].Value = txtEmail.Text;
SysFunc.ExecuteSP_NonQuery("Sp_Insert_DealerEmp", param);
cleardata();
LoadDDL_EmpCode();
success_add_item.Visible = true;
success_add_item.ForeColor = Color.Green;
if (btn_save.Text == "Save")
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "Savealert()", true);
}
if (btn_save.Text == "Update")
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "Updatealert()", true);
}
}
catch (Exception ex)
{
success_add_item.Visible = true;
success_add_item.Text = ex.Message;
}
}
protected void btnShow_Click(object sender, EventArgs e)
{
if (!sec.UserRight("2567", "006"))
{
Response.Redirect("~/Test.aspx");
}
try
{
if (txtFromDate.Text == "")
{
sysFuncs.UserMsg(lblMessage, Color.Red, "Please Select From Date");
return;
}
else if (txtToDate.Text == "")
{
sysFuncs.UserMsg(lblMessage, Color.Red, "Please Select To Date");
return;
}
if (ddlUtilityAudit.SelectedIndex == 0)
{
sysFuncs.UserMsg(lblMessage, Color.Red, "Please Select Utility Audit Option");
return;
}
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char), //0
new SqlParameter("@FromDate", SqlDbType.VarChar), //1
new SqlParameter("@ToDate", SqlDbType.VarChar) //2
};
param[0].Value = Session["DealerCode"].ToString();
param[1].Value = sysFunc.SaveDate(txtFromDate.Text);
param[2].Value = sysFunc.SaveDate(txtToDate.Text);
SqlDataReader rder = null;
if (ddlUtilityAudit.SelectedValue == "Estimate")
{
if (sysFunc.ExecuteSP("SP_EstimateReport_pSelect", param, ref rder)) //Database SP
{
data.EnforceConstraints = false;
data.SP_JobCardMaster.Load(rder); // DataSet SP
}
}
if (ddlUtilityAudit.SelectedValue == "JobCard")
{
if (sysFunc.ExecuteSP("SP_JobCardReport_pSelect", param, ref rder)) //Database SP
{
data.EnforceConstraints = false;
data.SP_JobCardMaster.Load(rder); // DataSet SP
}
}
else if (ddlUtilityAudit.SelectedValue == "CounterSale")
{
if (sysFunc.ExecuteSP("SP_CounterSaleMaster_pSelect", param, ref rder)) //Database SP
{
data.SP_JobCardMaster.Load(rder); // DataSet SP
}
}
else if (ddlUtilityAudit.SelectedValue == "CustomerInvoice")
{
if (sysFunc.ExecuteSP("SP_CustomerInvoice_pSelect", param, ref rder)) //Database SP
{
data.SP_JobCardMaster.Load(rder); // DataSet SP
}
}
else if (ddlUtilityAudit.SelectedValue == "PayRec")
{
if (sysFunc.ExecuteSP("SP_CustomerInvoice_pSelect", param, ref rder)) //Database SP
{
data.SP_JobCardMaster.Load(rder); // DataSet SP
}
}
else if (ddlUtilityAudit.SelectedValue == "GRN")
{
if (sysFunc.ExecuteSP("SP_GRNMaster_pSelect", param, ref rder)) //Database SP
{
data.SP_JobCardMaster.Load(rder); // DataSet SP
}
}
else if (ddlUtilityAudit.SelectedValue == "ChargeOut")
{
if (sysFunc.ExecuteSP("SP_ChargeOutMaster_pSelect", param, ref rder)) //Database SP
{
data.SP_JobCardMaster.Load(rder); // DataSet SP
}
}
RD.Load(Server.MapPath("../crpUtilityAuditReport.rpt"));
// mention paper size
RD.PrintOptions.PaperSize = PaperSize.PaperA4;
RD.DataDefinition.FormulaFields["DealerDesc"].Text = "'" + Session["DealerDesc"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerAddress"].Text = "'" + Session["DealerAddress"].ToString() + "'";
RD.DataDefinition.FormulaFields["SalesTaxNo"].Text = "'" + Session["DealerSaleTaxNo"].ToString() + "'";
RD.DataDefinition.FormulaFields["NTN"].Text = "'" + Session["DealerNTN"].ToString() + "'";
//RD.DataDefinition.FormulaFields["UserID"].Text = "'" + Session["UserID"].ToString() + "'";
//RD.DataDefinition.FormulaFields["FromCode"].Text = "'" + FDate + "'";
//RD.DataDefinition.FormulaFields["ToCode"].Text = "'" + TDate + "'";
RD.DataDefinition.FormulaFields["Terminal"].Text = "'" + Environment.MachineName + "'";
if (ddlUtilityAudit.SelectedValue == "Estimate")
{
RD.DataDefinition.FormulaFields["ReportTitle"].Text = "\"" + "Customer Estimate Report" + "\"";
}
if (ddlUtilityAudit.SelectedValue == "JobCard")
{
RD.DataDefinition.FormulaFields["ReportTitle"].Text = "\"" + "Job Card Report" + "\"";
}
else if (ddlUtilityAudit.SelectedValue == "CounterSale")
{
RD.DataDefinition.FormulaFields["ReportTitle"].Text = "\"" + "Counter Sale Report" + "\"";
}
else if (ddlUtilityAudit.SelectedValue == "CustomerInvoice")
{
RD.DataDefinition.FormulaFields["ReportTitle"].Text = "\"" + "Customer Invoice Report" + "\"";
}
else if (ddlUtilityAudit.SelectedValue == "PayRec")
{
RD.DataDefinition.FormulaFields["ReportTitle"].Text = "\"" + "Payment Receipt Report" + "\"";
}
else if (ddlUtilityAudit.SelectedValue == "GRN")
{
RD.DataDefinition.FormulaFields["ReportTitle"].Text = "\"" + "GRN Report" + "\"";
}
else if (ddlUtilityAudit.SelectedValue == "ChargeOut")
{
RD.DataDefinition.FormulaFields["ReportTitle"].Text = "\"" + "Stock Adjustment Report" + "\"";
}
//RD.DataDefinition.FormulaFields["CompanyName"].Text = "'" + Session["DealerDesc"].ToString() + "'";
//RD.DataDefinition.FormulaFields["DealershipName"].Text = "'Authorised " + Session["ParentDesc"].ToString() + " Dealership'";
// RD.DataDefinition.FormulaFields["Pic"].Text = "'C:\\Users\\u_ahm\\OneDrive\\Documents\\Visual Studio 2010\\Projects\\WebApplication1\\WebApplication1\\" + Session["Logo"] + "'";
RD.Database.Tables[0].SetDataSource(data);
string FilePath = Server.MapPath("~") + "\\Download\\";
string FileName = "Report.pdf";
string File = FilePath + FileName;
PdfDocument outputDocument = new PdfDocument();
Stream stream = RD.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
stream.Seek(0, SeekOrigin.Begin);
DirectoryInfo info = new DirectoryInfo(FilePath);
if (!info.Exists)
{
info.Create();
}
string path = Path.Combine(FilePath, FileName);
using (FileStream outputFileStream = new FileStream(path, FileMode.Create))
{
stream.CopyTo(outputFileStream);
}
stream.Dispose(); stream.Close();
string URL = "../../../../Download/PrintReport.aspx";
string fullURL = "window.open('" + URL + "', '_blank', 'height=800,width=1000,status=no,toolbar=no,menubar=no,location=no,scrollbars=yes,resizable=yes,titlebar=no');";
ScriptManager.RegisterStartupScript(this, typeof(string), "OPEN_WINDOW", fullURL, true);
//// convert and show
//string FilePath = Server.MapPath("~") + "\\Download\\";
//string FileName = "UtilityAuditReport" + this.Session["DealerCode"].ToString() + DateTime.Now.ToString("ddMMyyyy") + ".pdf";
//string File = FilePath + FileName;
//Session["RD"] = RD;
//string URL;
//URL = "../../../../Download/rptViewerService.aspx?ReportID=" + FileName;
//string fullURL = "window.open('" + URL + "', '_blank', 'height=800,width=1000,status=no,toolbar=no,menubar=no,location=no,scrollbars=yes,resizable=yes,titlebar=no');";
//ScriptManager.RegisterStartupScript(this, typeof(string), "OPEN_WINDOW", fullURL, true);
}
catch (Exception ex)
{
sysFunc.UserMsg(lblMessage, System.Drawing.Color.Red, ex.Message);
}
}
protected void btnShow_Click(object sender, EventArgs e)
{
if (!sec.UserRight("2580", "006"))
{
Response.Redirect("~/Test.aspx");
}
try
{
if (txtFromDate.Text == "")
{
sysFuncs.UserMsg(lblMessage, Color.Red, "Please Select From Date");
return;
}
else if (txtToDate.Text == "")
{
sysFuncs.UserMsg(lblMessage, Color.Red, "Please Select To Date");
return;
}
//if (ddlVendorCode.SelectedIndex == 0)
//{
// sysFuncs.UserMsg(lblMessage, Color.Red, "Please Select Vendor Option");
// return;
//}
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char), //0
new SqlParameter("@FromDate", SqlDbType.VarChar), //1
new SqlParameter("@ToDate", SqlDbType.VarChar), //2
new SqlParameter("@VendorCode", SqlDbType.VarChar) //3
};
param[0].Value = Session["DealerCode"].ToString();
param[1].Value = sysFunc.SaveDate(txtFromDate.Text);
param[2].Value = sysFunc.SaveDate(txtToDate.Text);
param[3].Value = ddlVendorCode.SelectedValue.ToString().Trim();
SqlDataReader rder = null;
//SP_VendorLedger_Report
// Store Procedure check and load
if (sysFunc.ExecuteSP("SP_VendorLedger_Report", param, ref rder)) //Database SP
{
data.SP_VendorLedger_Report.Load(rder); // DataSet SP
}
// Load in crystal report
//RD.Load(Server.MapPath("../PurchaseSaleReturnReport.rpt"));
RD.Load(Server.MapPath("../crptVendorLedgerReport.rpt"));
// mention paper size
RD.PrintOptions.PaperSize = PaperSize.PaperA4;
//RD.Load(Server.MapPath("../../SpareReports/rptInvoices.rpt"));
// RD.Load(Server.MapPath("../rptJobHistory.rpt"));
//RD.DataDefinition.FormulaFields["DealerPhone"].Text = "'" + sysFunc.GetStringValuesAgainstCodes("DealerCode", Session["DealerCode"].ToString(), "Phone1", "Dealer") + "'";
// RD.DataDefinition.FormulaFields["DealerEmail"].Text = "'" + sysFunc.GetStringValuesAgainstCodes("DealerCode", Session["DealerCode"].ToString(), "Email", "Dealer") + "'";
RD.DataDefinition.FormulaFields["DealerPhone"].Text = "'" + Session["DealerPhone"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerEmail"].Text = "'" + Session["DealerEmail"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerName"].Text = "'" + Session["DealerDesc"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerAddress"].Text = "'" + Session["DealerAddress"].ToString() + "'";
RD.DataDefinition.FormulaFields["SalesTaxNo"].Text = "'" + Session["DealerSaleTaxNo"].ToString() + "'";
RD.DataDefinition.FormulaFields["NTN"].Text = "'" + Session["DealerNTN"].ToString() + "'";
RD.DataDefinition.FormulaFields["UserID"].Text = "'" + Session["UserID"].ToString() + "'";
//RD.DataDefinition.FormulaFields["FromCode"].Text = "'" + FDate + "'";
//RD.DataDefinition.FormulaFields["ToCode"].Text = "'" + TDate + "'";
RD.DataDefinition.FormulaFields["Terminal"].Text = "'" + Environment.MachineName + "'";
RD.DataDefinition.FormulaFields["ReportTitle"].Text = "\"" + "Vendor Ledger Report" + "\"";
RD.DataDefinition.FormulaFields["CompanyName"].Text = "'" + Session["DealerDesc"].ToString() + "'";
//RD.DataDefinition.FormulaFields["DealershipName"].Text = "'Authorised " + Session["ParentDesc"].ToString() + " Dealership'";
//RD.DataDefinition.FormulaFields["Pic"].Text = "'C:\\Users\\u_ahm\\OneDrive\\Documents\\Visual Studio 2010\\Projects\\WebApplication1\\WebApplication1\\" + Session["Logo"] + "'";
RD.DataDefinition.FormulaFields["Pic"].Text = "'" + Server.MapPath("~") + Session["Logo"] + "'";
RD.Database.Tables[0].SetDataSource(data);
string FilePath = Server.MapPath("~") + "\\Download\\";
string FileName = "Report.pdf";
string File = FilePath + FileName;
PdfDocument outputDocument = new PdfDocument();
Stream stream = RD.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
stream.Seek(0, SeekOrigin.Begin);
DirectoryInfo info = new DirectoryInfo(FilePath);
if (!info.Exists)
{
info.Create();
}
string path = Path.Combine(FilePath, FileName);
using (FileStream outputFileStream = new FileStream(path, FileMode.Create))
{
stream.CopyTo(outputFileStream);
}
stream.Dispose(); stream.Close();
string URL = "../../../../Download/PrintReport.aspx";
string fullURL = "window.open('" + URL + "', '_blank', 'height=800,width=1000,status=no,toolbar=no,menubar=no,location=no,scrollbars=yes,resizable=yes,titlebar=no');";
ScriptManager.RegisterStartupScript(this, typeof(string), "OPEN_WINDOW", fullURL, true);
//// convert and show
//string FilePath = Server.MapPath("~") + "\\Download\\";
//string FileName = "VendorLedgerReport" + this.Session["DealerCode"].ToString() + DateTime.Now.ToString("ddMMyyyy") + ".pdf";
//string File = FilePath + FileName;
//Session["RD"] = RD;
////RD.ExportToDisk(ExportFormatType.PortableDocFormat, File);
//string URL;
//URL = "../../../../Download/rptViewerService.aspx?FileName=" + FileName;
//string fullURL = "window.open('" + URL + "', '_blank', 'height=800,width=1000,status=no,toolbar=no,menubar=no,location=no,scrollbars=yes,resizable=yes,titlebar=no');";
//ScriptManager.RegisterStartupScript(this, typeof(string), "OPEN_WINDOW", fullURL, true);
}
catch (Exception ex)
{
sysFunc.UserMsg(lblMessage, System.Drawing.Color.Red, ex.Message);
}
}
public static bool Insert_InvDetail(List <VehicleStockVM> model2, ref string msg)
{
int count = 0;
try
{
foreach (var item in model2)
{
if (count >= 1 || item.InvoiceNo != null)
{
SqlParameter[] param2 =
{
new SqlParameter("@DealerCode", item.DealerCode), //0
new SqlParameter("@ChassisNo", strAutoCode), //1
new SqlParameter("@InvoiceNo", item.InvoiceNo), //2
new SqlParameter("@InvoiceDate", item.InvoiceDate == null ?(object)DBNull.Value : sysfun.SaveDate(item.InvoiceDate)), //22
new SqlParameter("@Type", item.Type), //4
new SqlParameter("@DeliveredTOCustomer", item.DeliveredTOCustomer.Trim()), //5
new SqlParameter("@ReceiveFromOEM", item.ReceiveFromOEM.Trim()), //6
};
if (sysfun.ExecuteSP_NonQuery("SP_VehicleInvoiceDetail_Insert", param2, Trans) == true)
{
IsSaved = true;
}
else
{
ObjTrans.RollBackTransaction(ref Trans);
IsSaved = false;
}
}
count++;
}
ObjTrans.CommittTransaction(ref Trans);
IsSaved = true;
}
catch (Exception ex)
{
ObjTrans.RollBackTransaction(ref Trans);
msg = ex.Message;
IsSaved = false;
}
return(IsSaved);
}
protected void btnInsert_Click(object sender, EventArgs e)
{
if (txtTaxHead.Text == "")
{
sysFuncs.UserMsg(lblMessage, Color.Red, "Tax Head should not left blank", txtTaxHead);
return;
}
//if (txt.Text == "")
//{
// sysFuncs.UserMsg(lblMessage, Color.Red, "Customer should not left blank", txtreg);
// return;
//}
//if (txtRemarks.Text == "")
//{
// sysFuncs.UserMsg(lblMessage, Color.Red, "Remarks should not left blank", txtreg);
// return;
//}
DataTable dt = (DataTable)Session["TaxTypeDS"];
try
{
string max = sysFuncs.GetNewMaxID("TaxType", "TaxID", 2, "COMON");
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char, 5), //0
new SqlParameter("@TaxID", SqlDbType.Char, 2), //1
new SqlParameter("@TaxHead", SqlDbType.VarChar, 50), //2
new SqlParameter("@TaxPer", SqlDbType.Decimal), //3
new SqlParameter("@Active", SqlDbType.Char, 1), //4
new SqlParameter("@Type", SqlDbType.VarChar, 50), //5
new SqlParameter("@TaxApplicable", SqlDbType.VarChar, 20), //6
new SqlParameter("@AccCode", SqlDbType.Char, 16), //7
new SqlParameter("@UpdUser", SqlDbType.VarChar, 50), //8
new SqlParameter("@UpdDate", SqlDbType.DateTime), //9
new SqlParameter("@UpdTime", SqlDbType.DateTime), //10
new SqlParameter("@UpdTerm", SqlDbType.VarChar, 50), // 11
};
string activeCheck = "";
if (CheckId.Checked)
{
activeCheck = "Y";
}
else
{
activeCheck = "N";
}
// txtAccCode.Text = textAccCode;
param[0].Value = "COMON";
param[1].Value = max;
param[2].Value = txtTaxHead.Text;
param[3].Value = SysFunctions.CustomCDBL(txtTaxPercent.Text);
param[4].Value = activeCheck;
param[5].Value = ddlType.Text;
param[6].Value = ddlTaxApplicable.Text;
param[7].Value = txtAccCode.Text;
param[8].Value = Session["UserName"].ToString();
param[9].Value = sysFunc.SaveDate(DateTime.Now.ToString("dd-MM-yyyy"));
param[10].Value = DateTime.Now;
param[11].Value = "1";
if (sysFunc.ExecuteSP_NonQuery("SP_Insert_TaxType", param))
{
sysFunc.ClearTextBoxes(Page);
createGrid();
sysFuncs.UserMsg(lblMessage, Color.Green, "Record " + max + " Insert Sucessfully", txtTaxId);
}
else
{
sysFuncs.UserMsg(lblMessage, Color.Green, "Data Not Inserted", txtTaxId);
}
}
catch (Exception ex)
{
sysFunc.UserMsg(lblMessage, System.Drawing.Color.Red, ex.Message);
}
}