public ActionResult AddNewMRN(int?id)
{
if (Session["LOGGEDIN"] != null)
{
objMRNVM_Property = new MRNVM_Property();
Vendors_Property vendor = new Vendors_Property();
Product_Property product = new Product_Property();
Vendors_BLL objvendorbll = new Vendors_BLL();
Product_BLL objProductbll = new Product_BLL();
//objMRNVM_Property.VendorLST = Helper.ConvertDataTable<Vendors_Property>(objvendorbll.ViewAll());
objMRNVM_Property.ProductList = Helper.ConvertDataTable <Product_Property>(objProductbll.ViewAll());
objMRNVM_Property.WareHouseList = Helper.ConvertDataTable <WareHouse_Property>(ViewWareHouses());
objMRNVM_Property.mrnDate = DateTime.Now.ToString("yyyy-MM-dd");
if (id > 0)
{
//update
LP_MRN_Detail_Property objmrndetail;
objMRNProperty = new LP_MRN_Master_Property();
objMRNProperty.idx = Convert.ToInt16(id);
objMRNBll = new LP_MRN_BLL(objMRNProperty);
DataTable dt = objMRNBll.SelectById();
objMRNVM_Property.idx = Convert.ToInt16(dt.Rows[0]["mrnIdx"].ToString());
objMRNVM_Property.description = dt.Rows[0]["description"].ToString();
objMRNVM_Property.WarerHouseID = Convert.ToInt32(dt.Rows[0]["WarerHouseID"].ToString());
objMRNVM_Property.mrNumber = dt.Rows[0]["mrNumber"].ToString();
objMRNVM_Property.mrnDate = DateTime.Parse(dt.Rows[0]["mrnDate"].ToString()).ToString("yyyy-MM-dd");
//foreach(DataRow dr in dt.Rows)
//{
// objmrndetail
//}
ViewBag.DetailData = Helper.ConvertDataTable <MRNVM_Property>(dt);
return(View("AddNewMRN", objMRNVM_Property));
}
else
{
objMRNBll = new LP_MRN_BLL();
LP_GenerateTransNumber_Property objtrans = new LP_GenerateTransNumber_Property();
objtrans.TableName = "MRN";
objtrans.Identityfieldname = "idx";
objtrans.userid = Session["UID"].ToString();
objMRNVM_Property.mrNumber = objMRNBll.GenerateMRNNo(objtrans);
return(View("AddNewMRN", objMRNVM_Property));
}
}
else
{
return(RedirectToAction("Login", "Account"));
}
}
public JsonResult SelectMRById(int id)
{
if (Session["LOGGEDIN"] != null)
{
try
{
var objPurchaseProperty = new LP_MRN_Master_Property();
objPurchaseProperty.idx = id;
var objpurchaseBll = new LP_MRN_BLL(objPurchaseProperty);
var Data = JsonConvert.SerializeObject(objpurchaseBll.SelectById());
return(Json(new { data = Data, success = true, statuscode = 200, count = Data.Length }, 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));
}
}