public ActionResult AddVoucher(int?id)
{
if (Session["LOGGEDIN"] != null)
{
objvoucherVM = new LP_Voucher_ViewModel();
if (objvoucherVM.idx > 0)
{
}
else
{
objvoucherVM.date_created = DateTime.Now;
objvoucherVM.vouchertypelist = Helper.ConvertDataTable <LP_Transaction_Type_Property>(GetAllTransactionType());
objvoucherVM.voucher_amount = 0.00m;
objvoucherVM.description = "";
objvoucherVM.banklist = Helper.ConvertDataTable <Company_Bank_Property>(GetAllCompanyBanks());
objvoucherVM.vendorlist = Helper.ConvertDataTable <Vendors_Property>(GetAllVendors());
LP_GenerateTransNumber_Property objtransnumber = new LP_GenerateTransNumber_Property();
objtransnumber.TableName = "Voucher";
objtransnumber.Identityfieldname = "idx";
objtransnumber.userid = Session["UID"].ToString();
objVoucherBll = new LP_Voucher_BLL();
objvoucherVM.voucher_no = objVoucherBll.GenerateTransNo(objtransnumber);
}
return(View("_AddVoucher", objvoucherVM));
}
else
{
return(RedirectToAction("Login", "Account"));
}
}
public DataTable GetAllSIByDate(LP_Voucher_ViewModel objvchr)
{
if (Session["LOGGEDIN"] != null)
{
try
{
LP_SalesOrder_BLL objPIBLL = new LP_SalesOrder_BLL();
return(objPIBLL.SelectSIByDate(objvchr));
}
catch (Exception ex)
{
return(new DataTable());
}
}
else
{
return(new DataTable());
}
}
public JsonResult SearchPurchaseInvoice(LP_Voucher_ViewModel objsearchPI)
{
if (Session["LOGGEDIN"] != null)
{
try
{
//DataTable Data = GetAllPIByDate(objsearchPI);
var Data = Helper.ConvertDataTable <LP_P_Invoice_Property>(GetAllPIByDate(objsearchPI));//JsonConvert.SerializeObject(GetAllPIByDate(objsearchPI));
return(Json(new { data = Data, success = true, statuscode = 200 }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new { data = ex.Message, success = false, statuscode = 400, count = 0 }, JsonRequestBehavior.AllowGet));
}
}
else
{
return(Json(new { data = "Session Expired", success = false, statuscode = 400, count = 0 }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult AddVoucher(int?id)
{
if (Session["LOGGEDIN"] != null)
{
objvoucherVM = new LP_Voucher_ViewModel();
if (objvoucherVM.idx > 0)
{
}
else
{
LP_PInvoice_BLL objbll = new LP_PInvoice_BLL();
objvoucherVM.PInvoiceLST = Helper.ConvertDataTable <LP_P_Invoice_Property>(objbll.SelectAll()); //JsonConvert.SerializeObject(GetAllPIByDate(objsearchPI));
thirdTier_BLL subheadBLL = new thirdTier_BLL();
var allSubhead = subheadBLL.ViewAll();
objvoucherVM.date_created = DateTime.Now;
objvoucherVM.vouchertypelist = Helper.ConvertDataTable <thirdTier_Property>(subheadBLL.ViewAll());
objvoucherVM.voucher_amount = 0.00m;
objvoucherVM.description = "";
objvoucherVM.banklist = Helper.ConvertDataTable <Company_Bank_Property>(GetAllCompanyBanks());
objvoucherVM.vendorlist = Helper.ConvertDataTable <Vendors_Property>(GetAllVendors());
LP_GenerateTransNumber_Property objtransnumber = new LP_GenerateTransNumber_Property();
objtransnumber.TableName = "Voucher";
objtransnumber.Identityfieldname = "idx";
objtransnumber.userid = Session["UID"].ToString();
objVoucherBll = new LP_Voucher_BLL();
objvoucherVM.voucher_no = objVoucherBll.GenerateTransNo(objtransnumber);
}
return(View("_AddVoucher", objvoucherVM));
}
else
{
return(RedirectToAction("Login", "Account"));
}
}
public DataTable SelectPIByDate(LP_Voucher_ViewModel objvoucherinvoice)
{
objDAL = new LP_Purchase_Invoice_DAL();
return(objDAL.SelectPIBYDate(objvoucherinvoice));
}
public JsonResult AddUpdate(LP_Voucher_ViewModel objVoucher)
{
try
{
bool flag = false;
objvouchermaster = new LP_Voucher_Property();
objvouchermaster.idx = objVoucher.idx;
objvouchermaster.voucher_no = objVoucher.voucher_no;
objvouchermaster.vendor_id = objVoucher.vendor_id;
objvouchermaster.voucher_type = objVoucher.voucher_type;
objvouchermaster.date_created = objVoucher.date_created;
if (objVoucher.description != null)
{
objvouchermaster.description = objVoucher.description;
}
else
{
objvouchermaster.description = "";
}
// objMRNProperty.description = objMRN.description.Length>0? objMRN.description : "";
// objMRNProperty.paidDate = ;// objMRN.paidDate;
objvouchermaster.DetailData = Helper.ToDataTable <LP_Voucher_Details>(objVoucher.VoucherDetails);
if (objVoucher.idx > 0)
{
////objMRNProperty.creationDate = DateTime.Now;
////objMRNProperty.visible = 1;
////// objMRNProperty.status = "0";
////objMRNProperty.createdByUserIdx = Convert.ToInt16(Session["UID"].ToString());
//objvouchermaster.creationDate = DateTime.Now;
//objvouchermaster.lastModificationDate = DateTime.Now;
//objvouchermaster.lastModifiedByUserIdx = Convert.ToInt16(Session["UID"].ToString());
//// objMRNVM_Property.createdByUserIdx = DateTime.Now; ;
//objvouchermaster.TableName = "MRNDetails";
//objMRNBll = new LP_MRN_BLL(objvouchermaster);
//flag = objMRNBll.Insert();
//update
}
else
{
//add
objvouchermaster.status = 0;
objvouchermaster.account_cheque_no = objVoucher.account_cheque_no;
objvouchermaster.bank_id = objVoucher.bank_id;
objvouchermaster.payment_type = objVoucher.payment_type;
objvouchermaster.voucher_amount = objVoucher.voucher_amount;
objvouchermaster.u_id = Convert.ToInt16(Session["UID"].ToString());
objvouchermaster.TableName = "VoucherDetails";
objVoucherBll = new LP_Voucher_BLL(objvouchermaster);
flag = objVoucherBll.Insert();
}
return(Json(new { data = "", success = flag, msg = flag == true ? "Successfull" : "Failed", statuscode = flag == true ? 200 : 401 }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new { data = ex.Message, success = false, statuscode = 400, count = 0 }, JsonRequestBehavior.AllowGet));
}
}
//public string GeneratePO()
//{
// SqlCommand cmdToExecute = new SqlCommand();
// cmdToExecute.CommandText = "dbo.[sp_GeneratePONumber]";
// cmdToExecute.CommandType = CommandType.StoredProcedure;
// // Use base class' connection object
// cmdToExecute.Connection = _mainConnection;
// try
// {
// //cmdToExecute.Parameters.Add(new SqlParameter("@tablename", SqlDbType.VarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, ObjDepartmentProperty.TableName));
// //cmdToExecute.Parameters.Add(new SqlParameter("@coulmn", SqlDbType.VarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed,"'"+ ObjDepartmentProperty.ColumnName+"'"));
// cmdToExecute.Parameters.Add(new SqlParameter("@userid", SqlDbType.Int, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, _objPOMasterProperty.createdByUserIdx));
// // cmdToExecute.Parameters.Add(new SqlParameter("@PoNumber", SqlDbType.NVarChar, 32, ParameterDirection.Output, true, 10, 0, "", DataRowVersion.Proposed, _objPOMasterProperty.poNumber));
// if (_mainConnectionIsCreatedLocal)
// {
// // Open connection.
// _mainConnection.Open();
// }
// else
// {
// if (_mainConnectionProvider.IsTransactionPending)
// {
// cmdToExecute.Transaction = _mainConnectionProvider.CurrentTransaction;
// }
// }
// // Execute query.
// // _errorCode = (Int32)cmdToExecute.Parameters["@iErrorCode"].Value;
// //if (_errorCode != (int)LLBLError.AllOk)
// //{
// // // Throw error.
// // throw new Exception("Stored Procedure 'pr_PRODUCT_SETUP_SelectAll' reported the ErrorCode: " + _errorCode);
// //}
// //_rowsAffected = Convert.ToInt32(cmdToExecute.ExecuteScalar());
// return cmdToExecute.Parameters["@PoNumber"].Value.ToString(); //_rowsAffected;
// }
// catch (Exception ex)
// {
// // some error occured. Bubble it to caller and encapsulate Exception object
// throw new Exception("PRODUCT_SETUP::SelectAll::Error occured.", ex);
// }
// finally
// {
// if (_mainConnectionIsCreatedLocal)
// {
// // Close connection.
// _mainConnection.Close();
// }
// cmdToExecute.Dispose();
// }
//}
public DataTable SelectPIBYDate(LP_Voucher_ViewModel objVCHR)
{
SqlCommand cmdToExecute = new SqlCommand();
cmdToExecute.CommandText = "dbo.[sp_SelctPIbyDate]";
cmdToExecute.CommandType = CommandType.StoredProcedure;
DataTable toReturn = new DataTable("Bank Setup");
SqlDataAdapter adapter = new SqlDataAdapter(cmdToExecute);
// Use base class' connection object
cmdToExecute.Connection = _mainConnection;
try
{
cmdToExecute.Parameters.Add(new SqlParameter("@vendorid", SqlDbType.Int, 40, ParameterDirection.Input, false, 10, 0, "", DataRowVersion.Proposed, objVCHR.vendor_id));
cmdToExecute.Parameters.Add(new SqlParameter("@datefrom", SqlDbType.DateTime, 40, ParameterDirection.Input, false, 10, 0, "", DataRowVersion.Proposed, objVCHR.From_Date));
cmdToExecute.Parameters.Add(new SqlParameter("@dateto", SqlDbType.DateTime, 40, ParameterDirection.Input, false, 10, 0, "", DataRowVersion.Proposed, objVCHR.To_Date));
if (_mainConnectionIsCreatedLocal)
{
// Open connection.
_mainConnection.Open();
}
else
{
if (_mainConnectionProvider.IsTransactionPending)
{
cmdToExecute.Transaction = _mainConnectionProvider.CurrentTransaction;
}
}
// Execute query.
adapter.Fill(toReturn);
if (toReturn.Rows.Count > 0)
{
//ObjDepartmentProperty.Department_Id = (Int32)toReturn.Rows[0]["ID"];
//ObjDepartmentProperty.DepartmentName = (string)toReturn.Rows[0]["DepartmentName"];
//objBankProperty.idx = Convert.ToInt32(toReturn.Rows[0]["idx"]);// == System.DBNull.Value ? SqlInt32.Null : (Int32)toReturn.Rows[0]["idx"]);
//objBankProperty.bankName = (toReturn.Rows[0]["bankName"].ToString());// == System.DBNull.Value ? SqlString.Null : (string)toReturn.Rows[0]["bankName"]).ToString();
//objBankProperty.creationDate = Convert.ToDateTime((toReturn.Rows[0]["creationDate"]));// == System.DBNull.Value ? SqlString.Null : (string)toReturn.Rows[0]["creationDate"]));
//objBankProperty.visible = (int)toReturn.Rows[0]["visible"];
//objBankProperty.createdByUserIdx = (int)toReturn.Rows[0]["createdByUserIdx"];
// ObjDepartmentProperty.ISActive = (bool)toReturn.Rows[0]["IsActive"];
// //toReturn.Rows[0]["Product_Form_ID"] == System.DBNull.Value ? SqlInt32.Null : (Int32)toReturn.Rows[0]["Product_Form_ID"];
// ObjDepartmentProperty.UserId = (int)toReturn.Rows[0]["UserID"];
//string a= (toReturn.Rows[0]["bankName"] == System.DBNull.Value ? SqlString.Null : (string)toReturn.Rows[0]["bankName"]).ToString();
// ObjDepartmentProperty.CreatedDate = (DateTime)toReturn.Rows[0]["DateCreated"];
// ObjDepartmentProperty.CustomerAddress = (string)toReturn.Rows[0]["Address"];
// toReturn.Rows[0]["Product_Parent_Code"] == System.DBNull.Value ? SqlInt32.Null : (Int32)toReturn.Rows[0]["Product_Parent_Code"];
}
return(toReturn);
}
catch (Exception ex)
{
// some error occured. Bubble it to caller and encapsulate Exception object
throw new Exception("PRODUCT_SETUP::SelectOne::Error occured.", ex);
}
finally
{
if (_mainConnectionIsCreatedLocal)
{
// Close connection.
_mainConnection.Close();
}
cmdToExecute.Dispose();
adapter.Dispose();
}
}
public DataTable SelectSIByDate(LP_Voucher_ViewModel objvoucherinvoice)
{
_objPurchaseDAL = new LP_SalesOrder_DAL();
return(_objPurchaseDAL.SelectSIBYDate(objvoucherinvoice));
}
