public JObject ListFeedBack()
{
var ObjInfo = Request.Cookies["UserInfo"];
int OrgId = int.Parse(ObjInfo["OrgId"]);
HG_OrganizationDetails orgobj = new HG_OrganizationDetails().GetOne(OrgId);
int OrgType = orgobj.OrgTypes != null?int.Parse(orgobj.OrgTypes) : 1;
List <HG_Floor_or_ScreenMaster> floorOrScreens = new HG_Floor_or_ScreenMaster().GetAll(OrgType);
List <HG_Tables_or_Sheat> tableOrSheatlist = new HG_Tables_or_Sheat().GetAll(OrgType);
JObject FeedBackObj = new JObject();
var feedbklist = FeedbkForm.GetAll(OrgId);
JArray jArrayfdbk = new JArray();
foreach (var feedback in feedbklist)
{
JObject jObject = JObject.FromObject(feedback);
jObject.Add("Create", feedback.CreateDate.ToString("dd/MM/yyyy HH:mm"));
jArrayfdbk.Add(jObject);
}
FeedBackObj.Add("FormList", jArrayfdbk);
JArray jArray = new JArray();
foreach (HG_Floor_or_ScreenMaster Floors in floorOrScreens)
{
JObject jObject = JObject.FromObject(Floors);
jObject.Add("TableSheatList", JArray.FromObject(tableOrSheatlist.FindAll(x => x.Floor_or_ScreenId == Floors.Floor_or_ScreenID)));
jArray.Add(jObject);
}
FeedBackObj.Add("FloorList", jArray);
return(FeedBackObj);
}
// GET: HG_OrganizationDetails
public ActionResult Index()
{
HG_OrganizationDetails Objitem = new HG_OrganizationDetails();
List <HG_OrganizationDetails> Listitem = Objitem.GetAll();
return(View(Listitem));
}
public JObject SeatingList(int CBID, int Orgid = 0)
{
if (Orgid == 0)
{
Orgid = OrderType.CurrOrgId();
}
HG_OrganizationDetails orgobj = new HG_OrganizationDetails().GetOne(Orgid);
int OrgType = orgobj.OrgTypes != null?int.Parse(orgobj.OrgTypes) : 1;
Cashback cashback = Cashback.Getone(CBID);
List <HG_Floor_or_ScreenMaster> floorOrScreens = new HG_Floor_or_ScreenMaster().GetAll(OrgType);
List <HG_Tables_or_Sheat> tableOrSheatlist = new HG_Tables_or_Sheat().GetAll(OrgType);
JObject OrderMenus = new JObject();
List <int> Seatings = new List <int>();
List <int> RedSeatings = new List <int>();
RedSeatings = Cashback.GetRedSeatings(cashback);
if (cashback.SeatingIds != "")
{
Seatings = cashback.SeatingIds.Split(',').Select(int.Parse).ToList();
}
JArray jArray = new JArray();
foreach (HG_Floor_or_ScreenMaster Floors in floorOrScreens)
{
JObject jObject = JObject.FromObject(Floors);
jObject.Add("TableSheatList", JArray.FromObject(tableOrSheatlist.FindAll(x => x.Floor_or_ScreenId == Floors.Floor_or_ScreenID)));
jArray.Add(jObject);
}
OrderMenus.Add("FloorList", jArray);
OrderMenus.Add("ExistingSeatings", JArray.FromObject(Seatings));
OrderMenus.Add("RedSeatings", JArray.FromObject(RedSeatings));
return(OrderMenus);
}
public ActionResult DeleteCity(int ID)
{
List <HG_OrganizationDetails> ListOrg = new HG_OrganizationDetails().GetAll();
City ObjCity = new City().GetOne(ID);
if (ObjCity.CityId > 0)
{
List <District> districtList = new District().GetAllByStsCity(ObjCity.StateId, ObjCity.CityId);
if (districtList.Count > 0)
{
return(Json(new { msg = "Data already used" }, JsonRequestBehavior.AllowGet));
}
}
var CityContains = ListOrg.FindAll(x => x.City == ObjCity.CityId.ToString());
if (CityContains.Count > 0)
{
return(Json(new { msg = "Data already used" }, JsonRequestBehavior.AllowGet));
}
else
{
int i = City.Dell(ID);
}
return(Json(new { data = "1" }, JsonRequestBehavior.AllowGet));
}
public ActionResult Delete(int ID)
{
HG_OrganizationDetails ObjCon = new HG_OrganizationDetails();
int d = ObjCon.Dell(ID);
if (d > 0)
{
return(RedirectToAction("Index"));
}
return(RedirectToAction("Error"));
}
public ActionResult CreateEdit(int ID)
{
HG_OrganizationDetails Objitem = new HG_OrganizationDetails();
if (ID > 0)
{
Objitem = Objitem.GetOne(ID);
}
return(View(Objitem));
}
public ActionResult PrintSetup(int Id)
{
//var OrgId =int.Parse(Request.Cookies["UserInfo"]["OrgId"]);
HG_OrganizationDetails Objitem = new HG_OrganizationDetails();
if (Id > 0)
{
Objitem = Objitem.GetOne(Id);
}
return(View(Objitem));
}
public JObject VideoList()
{
List <VideoCategory> videoCategories = VideoCategory.GetAll();
videoCategories = videoCategories.OrderBy(x => x.OrderNo).ToList();
JObject response = new JObject();
var UserInfo = Request.Cookies["UserInfo"];
int CID = int.Parse(UserInfo["UserCode"]);
int OrgId = int.Parse(UserInfo["OrgId"]);
HG_OrganizationDetails ObjOrg = new HG_OrganizationDetails().GetOne(OrgId);
List <VideoMark> videomarks = VideoMark.GetAll(CID);
JArray jArray = new JArray();
foreach (var category in videoCategories)
{
JObject jObject = new JObject();
List <Video> videolist = Video.GetAll(category.Id);
if (ObjOrg != null && ObjOrg.OrgID > 0)
{
// 1)=========for outlet type
if (ObjOrg.OrgTypes == "1")
{
videolist = videolist.FindAll(x => x.Restaurant);
}
else if (ObjOrg.OrgTypes == "2")
{
videolist = videolist.FindAll(x => x.Theater);
}
//========payment mode
if (ObjOrg.PaymentType == 1)
{
videolist = videolist.FindAll(x => x.Prepaid);
}
else if (ObjOrg.PaymentType == 2)
{
videolist = videolist.FindAll(x => x.Postpaid);
}
}
videolist = videolist.OrderBy(x => x.SerialNumber).ToList();
jObject.Add("CatName", category.Name);
jObject.Add("CatId", category.Id);
jObject.Add("Videos", JArray.FromObject(videolist));
jArray.Add(jObject);
}
response.Add("CategoryList", jArray);
response.Add("videomarks", JArray.FromObject(videomarks));
return(response);
}
public ActionResult DeleteTehsil(int ID)
{
List <HG_OrganizationDetails> ListOrg = new HG_OrganizationDetails().GetAll();
var CityContains = ListOrg.FindAll(x => x.DistrictId == ID);
if (CityContains.Count > 0)
{
return(Json(new { msg = "Data already used" }, JsonRequestBehavior.AllowGet));
}
else
{
int i = District.Dell(ID);
}
return(Json(new { data = "1" }, JsonRequestBehavior.AllowGet));
}
public JObject OrgSettng()
{
var UserInfo = Request.Cookies["UserInfo"];
int Orgid = int.Parse(UserInfo["OrgId"]);
HG_OrganizationDetails ObjOrg = new HG_OrganizationDetails().GetOne(Orgid);
OrgSetting setting = OrgSetting.Getone(Orgid);
JObject result = new JObject();
double taxableAmt = (setting.ParcelAmt * setting.ParcelTax) / 100;
double ParcelPrice = setting.ParcelAmt + taxableAmt;
result.Add("InvoicePrint", ObjOrg.InvoicePrintting);
result.Add("InvoiceNoOfCopy", ObjOrg.NuOfCopy);
result.Add("OrdDisaply", ObjOrg.OrderDisplay);
result.Add("KotPrint", ObjOrg.PrinttingType);
result.Add("NoOfCopy", ObjOrg.Copy);
result.Add("ParcelAmt", ParcelPrice);
return(result);
}
public JsonResult SetOrderStatus(bool OrderStatus)
{
var ObjOrg = Request.Cookies["UserInfo"];
int OrgId = int.Parse(ObjOrg["OrgId"]);
HG_OrganizationDetails OrgObj = new HG_OrganizationDetails().GetOne(OrgId);
if (OrgObj.OrgID > 0)
{
OrgObj.CustomerOrdering = OrderStatus;
OrgObj.Save();
return(Json(new { msg = "1" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { msg = "0" }, JsonRequestBehavior.AllowGet));
}
}
public JObject getOrgType(int orgId)
{
HG_OrganizationDetails objOrg = new HG_OrganizationDetails().GetOne(orgId);
if (objOrg != null && objOrg.OrgID > 0)
{
JObject result = new JObject();
result.Add("Status", 200);
result.Add("OrgType", objOrg.OrgTypes);
result.Add("Stateid", objOrg.State);
return(result);
}
else
{
JObject result = new JObject();
result.Add("Status", 400);
return(result);
}
}
public int ActiveForm([System.Web.Http.FromBody] ActiveMenu activeMenu)
{
//var Jobj = { };
//Jobj.OMID = MenuId;
//Jobj.TorSIDs = TableList;
//Jobj.OrgId = OrgId;
int status = 0;
int FID = activeMenu.OMID;
int OrgId = activeMenu.OrgId;
HG_OrganizationDetails hG_OrganizationDetails = new HG_OrganizationDetails().GetOne(OrgId);
string OrgType = hG_OrganizationDetails.OrgTypes != null ? hG_OrganizationDetails.OrgTypes : "1";
List <FeedbkForm> FeedBackList = FeedbkForm.GetAll(OrgId);
FeedbkForm FeedBkObj = FeedBackList.Find(x => x.Id == FID);
FeedBkObj.Status = true;
FeedBkObj.Save();
List <HG_Tables_or_Sheat> TorSlist = new HG_Tables_or_Sheat().GetAll(int.Parse(OrgType));
var AlreadySelectedList = TorSlist.FindAll(x => x.FDBKId == FID);
Int64[] items = activeMenu.TorSIDs;
HashSet <Int64> hashKeys = new HashSet <Int64>();
if (items != null && items.Length > 0)
{
hashKeys = new HashSet <Int64>(items);
}
var RemovedTorSList = AlreadySelectedList.FindAll(x => !hashKeys.Contains(x.Table_or_RowID));
List <HG_Tables_or_Sheat> OnlyApplytoTorS = TorSlist.FindAll(x => hashKeys.Contains(x.Table_or_RowID));
foreach (var TorSobj in OnlyApplytoTorS)
{
TorSobj.FDBKId = FID;
TorSobj.save();
}
foreach (var TorSobj in RemovedTorSList)
{
TorSobj.FDBKId = 0;
TorSobj.save();
}
return(status);
}
public ActionResult OrgSettingEdit(int OrgId)
{
HG_OrganizationDetails ObjOrg = new HG_OrganizationDetails().GetOne(OrgId);
OrgSetting OrgSeting = OrgSetting.Getone(OrgId);
if (OrgSeting.OrgId == 0)
{
OrgSeting = new OrgSetting();
OrgSeting.OrgId = OrgId;
if (ObjOrg.OrgTypes == "1" && OrgSeting.ByCash == 0) //restruant
{
OrgSeting.ByCash = 1; //yes
OrgSeting.ByOnline = 1; //NO
}
else if (ObjOrg.OrgTypes == "2" && OrgSeting.ByOnline == 0)
{
OrgSeting.ByOnline = 1; //yes
OrgSeting.ByCash = 1; //NO
}
}
return(View(OrgSeting));
}
public static int ChargeCamp(Int64 OID, int CBID, int OrgId)
{
if (CBID > 0)
{
HG_OrganizationDetails ObjOrg = new HG_OrganizationDetails().GetOne(OrgId);
var chargeAmt = new Settings().GetOne("CBCHARGE");
ChampeignCharge champeignCharge = new ChampeignCharge();
champeignCharge.ChargeAmt = double.Parse(chargeAmt.KeyValue);
champeignCharge.CashBkId = CBID;
champeignCharge.OID = OID;
champeignCharge.OrgId = OrgId;
champeignCharge.CreateDate = DateTime.Now;
double AvailableAmt = ObjOrg.WalletAmt - champeignCharge.ChargeAmt;
champeignCharge.BalanceAmt = AvailableAmt;
champeignCharge.Save();
ObjOrg.WalletAmt = AvailableAmt;
ObjOrg.Save();
return(champeignCharge.ChargeId);
}
return(0);
}
// GET: AdminApi
public JObject GetSeating(int OrgId = 0)
{
List <HG_Items> ListItems = new List <HG_Items>();
List <HG_Category> MenuList = new List <HG_Category>();
if (OrgId <= 0)
{
OrgId = OrderType.CurrOrgId();
}
if (OrgId > 0)
{
ListItems = new HG_Items().GetAll(OrgId);
ListItems = ListItems.FindAll(x => x.ItemAvaibility == 0);// only available items
MenuList = new HG_Category().GetAll(OrgId: OrgId);
}
JObject ProcedureParm = new JObject();
var CurrDate = DateTime.Now;
var Todate = new DateTime(CurrDate.Year, CurrDate.Month, CurrDate.Day, 23, 59, 00);
ProcedureParm.Add("FromDate", CurrDate.ToString("MM/dd/yyyy"));
ProcedureParm.Add("Todate", Todate.ToString("MM/dd/yyyy HH:mm:ss"));
ProcedureParm.Add("Orgid", OrgId);
List <TblData> RunningOrds = TblData.GetAll("GetRunningOrder", ProcedureParm);
HG_OrganizationDetails ObjOrg = new HG_OrganizationDetails().GetOne(OrgId);
List <Seating> Listseating = Seating.GetSeating(OrgId);
JObject JobjResonse = new JObject();
JArray SeatingArray = new JArray();
JArray TakeAwayItem = new JArray();
List <HG_Floor_or_ScreenMaster> FlrScr = new HG_Floor_or_ScreenMaster().GetAll(int.Parse(ObjOrg.OrgTypes), OrgId);
foreach (var ObjSeating in Listseating)
{
JObject jObject = new JObject();
jObject.Add("Table_or_SheetName", ObjSeating.Seatting);
jObject.Add("Table_or_RowID", ObjSeating.SeatId);
jObject.Add("Otp", ObjSeating.Otp);
jObject.Add("SeatName", ObjSeating.SeatName);
jObject.Add("ScrnFlr", ObjSeating.FSName);
jObject.Add("RowSide", ObjSeating.RowSideName);
jObject.Add("Floor_or_ScreenId", ObjSeating.FSIS);
JArray MenuJarray = new JArray();
var order = RunningOrds.Find(x => x.getVal <Int64>("Table_or_SheatId") == ObjSeating.SeatId && x.getVal <int>("TableOtp") == ObjSeating.Otp);
if (order != null && order.getVal <Int64>("OID") > 0)
{
jObject.Add("CurrOID", order.getVal <Int64>("OID"));
jObject.Add("Status", 3);//table is booked
}
else
{
jObject.Add("CurrOID", 0);
jObject.Add("Status", 1);//table is free;
}
double CurrentTableAmt = 0.00;
string Cmobile = "";
string Cname = "";
int ContactId = 0;
if (order != null)
{
if (order.getVal <int>("ContactId") > 0)
{
LocalContacts localContacts = LocalContacts.GetOne(order.getVal <int>("ContactId"));
Cmobile = localContacts.MobileNo;
Cname = localContacts.Cust_Name;
ContactId = localContacts.ContctID;
}
else
{
vw_HG_UsersDetails ObjUser = new vw_HG_UsersDetails().GetSingleByUserId((int)order.getVal <Int64>("CID"));
if (ObjUser != null && ObjUser.UserCode > 0 && ObjUser.UserType == "CUST")
{
Cmobile = ObjUser.UserId;
Cname = ObjUser.UserName;
ContactId = -1;// minus show dont edit this. Order Palced By Customer
}
}
if (order.getVal <int>("PaymentStatus") == 0)
{
CurrentTableAmt += order.getVal <double>("OrdAmt");
}
}
if (ObjSeating.FSIS > 0) // not takeaway
{
jObject.Add("Type", 1); //Seat and table;
List <OrderMenuCategory> ListCategry = OrderMenuCategory.GetAll(ObjSeating.OMID);
List <OrdMenuCtgItems> ListMenuItems = OrdMenuCtgItems.GetAll(ObjSeating.OMID);
ListCategry = ListCategry.FindAll(x => x.Status == true);
ListCategry = ListCategry.OrderBy(x => x.OrderNo).ToList();
ListMenuItems = ListMenuItems.FindAll(x => x.Status == true);
HashSet <int> ItemIdHash = new HashSet <int>(ListItems.Select(x => x.ItemID).ToArray());
ListMenuItems = ListMenuItems.FindAll(x => ItemIdHash.Contains((int)x.ItemId));
int count = 0;
foreach (var OrderMenuObj in ListCategry)
{
double MenuItemPrice = 0.00;
var OrderMenuItems = ListMenuItems.FindAll(x => x.OrdMenuCatId == OrderMenuObj.id);
if (OrderMenuItems.Count > 0)
{
JObject JobjMenu = new JObject();
JArray jarrayItem = new JArray();
JobjMenu.Add("MenuId", OrderMenuObj.CategoryId);
JobjMenu.Add("Name", OrderMenuObj.DisplayName);
JobjMenu.Add("MenuIndex", count++);
int ItemiIndex = 0;
OrderMenuItems = OrderMenuItems.OrderBy(x => x.OrderNo).ToList();
foreach (var MenuItmObj in OrderMenuItems)
{
var Items = ListItems.Find(x => x.ItemID == MenuItmObj.ItemId);
int CurrCount = 0;
JObject objItem = new JObject();
objItem.Add("IID", Items.ItemID);
objItem.Add("ItemName", Items.Items);
objItem.Add("ItemPrice", Items.Price);
objItem.Add("ItemQuntity", Items.Qty);
objItem.Add("ItemImage", Items.Image);
objItem.Add("ItemCartValue", CurrCount);
objItem.Add("MenuId", Items.CategoryID);
objItem.Add("ItemIndex", ItemiIndex++);
objItem.Add("ItemMode", Items.ItemMode);
objItem.Add("CostPrice", Items.CostPrice);// without gst
objItem.Add("Tax", Items.Tax);
objItem.Add("Info", Items.ItemDiscription);
//check addon or Serving Size or Both apply in current item
List <AddOnn> Addons = AddOns.GetAddonsAndMultiSSize(Items);
if (Addons.Count > 0)
{
objItem.Add("Addons", JArray.FromObject(Addons));
}
jarrayItem.Add(objItem);
MenuItemPrice += Items.Price * CurrCount;
}
JobjMenu.Add("MenuItemCount", OrderMenuItems.Count);
JobjMenu.Add("MenuItems", jarrayItem);
// JobjMenu.Add("MenuItmPrice", MenuItemPrice);
//JobjMenu.Add("TableAmt", CurrentTableAmt);
JobjMenu.Add("ContactId", ContactId);
JobjMenu.Add("Mobile", Cmobile);
JobjMenu.Add("CName", Cname);
MenuJarray.Add(JobjMenu);
}
}
}
else
{
jObject.Add("Type", 3);//take away
if (TakeAwayItem.Count == 0)
{
int count = 0;
foreach (HG_Category menu in MenuList)
{
double MenuItemPrice = 0.00;
List <HG_Items> ItemListByMenu = ListItems.FindAll(x => x.CategoryID == menu.CategoryID);
if (ItemListByMenu.Count > 0)
{
JObject JobjMenu = new JObject();
JArray jarrayItem = new JArray();
JobjMenu.Add("MenuId", menu.CategoryID);
JobjMenu.Add("Name", menu.Category);
JobjMenu.Add("MenuIndex", count++);
int ItemiIndex = 0;
foreach (var Items in ItemListByMenu)
{
int CurrCount = 0;
JObject objItem = new JObject();
objItem.Add("IID", Items.ItemID);
objItem.Add("ItemName", Items.Items);
objItem.Add("ItemPrice", Items.Price);
objItem.Add("ItemQuntity", Items.Qty);
objItem.Add("ItemImage", Items.Image);
objItem.Add("ItemCartValue", CurrCount);
objItem.Add("MenuId", Items.CategoryID);
objItem.Add("ItemIndex", ItemiIndex++);
objItem.Add("CostPrice", Items.CostPrice);// without gst
objItem.Add("Tax", Items.Tax);
objItem.Add("ItemMode", Items.ItemMode);
objItem.Add("Info", Items.ItemDiscription);
//check addon or Serving Size or Both apply in current item
List <AddOnn> Addons = AddOns.GetAddonsAndMultiSSize(Items);
if (Addons.Count > 0)
{
objItem.Add("Addons", JArray.FromObject(Addons));
}
jarrayItem.Add(objItem);
MenuItemPrice += Items.Price * CurrCount;
}
JobjMenu.Add("MenuItemCount", ItemListByMenu.Count);
JobjMenu.Add("MenuItems", jarrayItem);
//JobjMenu.Add("MenuItmPrice", MenuItemPrice);
//JobjMenu.Add("TableAmt", CurrentTableAmt);
JobjMenu.Add("ContactId", ContactId);
JobjMenu.Add("Mobile", Cmobile);
JobjMenu.Add("CName", Cname);
TakeAwayItem.Add(JobjMenu);
}
}
}
MenuJarray = TakeAwayItem;
}
jObject.Add("MenuItems", MenuJarray);
jObject.Add("SeatingAmt", CurrentTableAmt);
SeatingArray.Add(jObject);
}
JobjResonse.Add("Seating", SeatingArray);
JobjResonse.Add("FlrScrList", JArray.FromObject(FlrScr));
JobjResonse.Add("UserCode", OrderType.UserCode());
JobjResonse.Add("OrgType", ObjOrg.OrgTypes);// restuarant / theataer
JobjResonse.Add("OrgId", OrgId);
return(JobjResonse);
}
public JsonResult Upload(int OrgID, System.Web.HttpPostedFileBase UplXl)
{
string Msg = "Uploaded Successfully";
if (OrgID <= 0)
{
return(Json(new { msg = "Select Organization First" }));
}
if (UplXl == null)
{
return(Json(new { msg = "Upload Excel File First" }));
}
try
{
var userInfo = Request.Cookies["UserInfo"];
var EntryBy = int.Parse(userInfo["UserCode"]);
UplXl.SaveAs(System.IO.Path.Combine(Server.MapPath("~/Image/"), UplXl.FileName));
var DT = ReadExl.ReadExcelFileDT("~/Image/" + UplXl.FileName);
if (DT.Rows.Count > 0)
{
HG_OrganizationDetails ObjOrg = new HG_OrganizationDetails().GetOne(OrgID);
List <HG_Category> ListCategory = new HG_Category().GetAll(ObjOrg.OrgID);
List <HG_Items> ListItem = new HG_Items().GetAll(ObjOrg.OrgID);
for (int i = 1; i < DT.Rows.Count; i++)
{
string CategoryName = (DT.Rows[i][0] == null ? "" : DT.Rows[i][0].ToString());
string ItmName = (DT.Rows[i][1] == null ? "" : DT.Rows[i][1].ToString().Trim());
string ItmMode = (DT.Rows[i][2] == null ? "1" : DT.Rows[i][2].ToString().Replace(" ", ""));
string Discriptn = (DT.Rows[i][3] == null ? "" : DT.Rows[i][3].ToString());
string CostPriceStr = (DT.Rows[i][4] == null ? "0.0" : DT.Rows[i][4].ToString().Replace(" ", ""));
string Taxstr = (DT.Rows[i][5] == null ? "0.0" : DT.Rows[i][5].ToString().Replace(" ", ""));
double CostPrice = double.Parse(CostPriceStr);
double Tax = double.Parse(Taxstr);
double TaxAmt = (CostPrice * Tax) / 100;
double price = CostPrice + TaxAmt;
if (ItmMode.ToUpper() == "VEG")
{
ItmMode = "1";
}
else if (ItmMode.ToUpper() == "NON-VEG")
{
ItmMode = "2";
}
HG_Category ObjCategory = ListCategory.Find(x => x.Category.ToUpper() == CategoryName.ToUpper());
if (ObjCategory == null && CategoryName.Replace(" ", "") != "")
{
ObjCategory = new HG_Category()
{
Category = CategoryName, OrgID = ObjOrg.OrgID, CategoryID = 0, CategoryType = 1, EntryBy = EntryBy
};
ObjCategory.Save();
ListCategory.Add(ObjCategory);
}
HG_Items ObjItem = ListItem.Find(x => x.Items.ToUpper() == ItmName.ToUpper());
if (ObjItem == null && ItmName.Replace(" ", "") != "" && ObjCategory != null)
{
ObjItem = new HG_Items()
{
ItemID = 0, CategoryID = ObjCategory.CategoryID, Items = ItmName, ItemMode = ItmMode, ItemDiscription = Discriptn, CostPrice = CostPrice, Tax = Tax, Price = price, ApplyAddOn = 1, Image = ""
, EntryBy = EntryBy, OrgID = OrgID, Qty = "", Type = 1, Status = true
};
ObjItem.Save();
ListItem.Add(ObjItem);
}
else if (ObjItem != null && ItmName.Replace(" ", "") != "" && ObjCategory != null)
{
ObjItem.Items = ItmName;
ObjItem.ItemMode = ItmMode;
if ((ObjItem.CostPrice != CostPrice) || (ObjItem.Tax != Tax))
{
ObjItem.CostPrice = CostPrice;
ObjItem.Tax = Tax;
ObjItem.Price = price;
}
ObjItem.ItemDiscription = Discriptn;
ObjItem.Save();
ListItem.Add(ObjItem);
}
else if (ItmName.Replace(" ", "") == "" || ObjCategory == null)
{
Msg = "Uploaded Successfully With Some Data Missing";
}
}
}
else
{
return(Json(new { msg = "No Any Row Founds" }));
}
}
catch (Exception e)
{
return(Json(new { msg = "Error " + e.Message }));
}
return(Json(new { msg = Msg }, JsonRequestBehavior.AllowGet));
}
public int Save()
{
int Row = 0;
DBCon con = new DBCon();
SqlCommand cmd = null;
string Quary = "";
try
{
if (this.ID == 0)
{
Quary = "Insert Into ACLedger Values (@Name,@ShortName,@MobileNo1,@MobileNo2,@DebtorType,@OrgId,@State,@MarginOnCash,@TaxOnAboveMargin,@MarginOnline,@TaxOnAboveMarginOnline,@PaymentFrequency,@PaymentDay,@CollectionFrequency,@CollectionDay,@CalculationStartFrom,@TDSApplicable,@Email,@Remarks,@LisenceRenewalDate,@ParentGroup,@AccountNumber,@IFSCCode,@BankName,@Branch,@ManualPaymentDays,@ManualCollectionDays,@YearlyRenewalCharges,@Tax,@ReceivePaymentFromPOS);SELECT SCOPE_IDENTITY();";
}
else
{
Quary = "Update ACLedger Set Name=@Name,ShortName=@ShortName,MobileNo1=@MobileNo1,MobileNo2=@MobileNo2,DebtorType=@DebtorType,OrgId=@OrgId,State=@State,MarginOnCash=@MarginOnCash,TaxOnAboveMargin=@TaxOnAboveMargin,MarginOnline=@MarginOnline,TaxOnAboveMarginOnline=@TaxOnAboveMarginOnline,PaymentFrequency=@PaymentFrequency,PaymentDay=@PaymentDay,CollectionFrequency=@CollectionFrequency,CollectionDay=@CollectionDay,CalculationStartFrom=@CalculationStartFrom,TDSApplicable=@TDSApplicable,Email=@Email,Remarks=@Remarks,LisenceRenewalDate=@LisenceRenewalDate,ParentGroup=@ParentGroup,AccountNumber=@AccountNumber,IFSCCode=@IFSCCode,BankName=@BankName,Branch=@Branch,ManualPaymentDays=@ManualPaymentDays," +
"ManualCollectionDays=@ManualCollectionDays,YearlyRenewalCharges=@YearlyRenewalCharges,Tax=@Tax,ReceivePaymentFromPOS=@ReceivePaymentFromPOS where ID=@ID";
}
cmd = new SqlCommand(Quary, con.Con);
cmd.Parameters.AddWithValue("@ID", this.ID);
cmd.Parameters.AddWithValue("@Name", this.Name);
cmd.Parameters.AddWithValue("@ShortName", this.ShortName);
cmd.Parameters.AddWithValue("@MobileNo1", this.MobileNo1);
cmd.Parameters.AddWithValue("@MobileNo2", this.MobileNo2);
cmd.Parameters.AddWithValue("@DebtorType", this.DebtorType);
cmd.Parameters.AddWithValue("@OrgId", this.OrgId);
cmd.Parameters.AddWithValue("@State", this.State);
cmd.Parameters.AddWithValue("@MarginOnCash", this.MarginOnCash);
cmd.Parameters.AddWithValue("@TaxOnAboveMargin", this.TaxOnAboveMargin);
cmd.Parameters.AddWithValue("@MarginOnline", this.MarginOnline);
cmd.Parameters.AddWithValue("@TaxOnAboveMarginOnline", this.TaxOnAboveMarginOnline);
cmd.Parameters.AddWithValue("@PaymentFrequency", this.PaymentFrequency);
cmd.Parameters.AddWithValue("@PaymentDay", this.PaymentDay);
cmd.Parameters.AddWithValue("@CollectionFrequency", this.CollectionFrequency);
cmd.Parameters.AddWithValue("@CollectionDay", this.CollectionDay);
cmd.Parameters.AddWithValue("@CalculationStartFrom", this.CalculationStartFrom);
cmd.Parameters.AddWithValue("@TDSApplicable", this.TDSApplicable);
cmd.Parameters.AddWithValue("@Email", this.Email);
cmd.Parameters.AddWithValue("@Remarks", this.Remarks);
cmd.Parameters.AddWithValue("@LisenceRenewalDate", this.LisenceRenewalDate);
cmd.Parameters.AddWithValue("@ParentGroup", this.ParentGroup);
cmd.Parameters.AddWithValue("@AccountNumber", this.AccountNumber);
cmd.Parameters.AddWithValue("@IFSCCode", this.IFSCCode);
cmd.Parameters.AddWithValue("@BankName", this.BankName);
cmd.Parameters.AddWithValue("@Branch", this.BankName);
cmd.Parameters.AddWithValue("@ManualPaymentDays", this.ManualPaymentDays);
cmd.Parameters.AddWithValue("@ManualCollectionDays", this.ManualCollectionDays);
cmd.Parameters.AddWithValue("@YearlyRenewalCharges", this.YearlyRenewalCharges);
cmd.Parameters.AddWithValue("@Tax", this.Tax);
cmd.Parameters.AddWithValue("@ReceivePaymentFromPOS", this.ReceivePaymentFromPOS);
if (this.ID == 0)
{
Row = Convert.ToInt32(cmd.ExecuteScalar());
this.ID = Row;
if (DebtorType == 1 && ParentGroup == 2)
{
HG_OrganizationDetails org = new HG_OrganizationDetails();
org = org.GetOne(OrgId);
if (org.OrgTypes == "2")
{
BalanceStatementController balanceStatement = new BalanceStatementController();
BalanceStatement BSObj = new BalanceStatement();
try
{
BSObj.Narration = "Opening Balance";
BSObj.Amount = 0.00;
BSObj.Date = CalculationStartFrom;
BSObj.OrgId = OrgId;
BSObj.Balance = 0.00;
BSObj.SaveOpeningValue();
balanceStatement.InsertIntoBalanceStementAfterRegistration(CalculationStartFrom, OrgId);
}
catch (Exception ex)
{
ex.ToString();
}
}
}
}
else
{
Row = cmd.ExecuteNonQuery();
//this.ID = Row;
}
}
catch (Exception e) { e.ToString(); }
finally { cmd.Dispose(); con.Con.Close(); }
return(Row);
}
public ActionResult CreateEdit(HG_OrganizationDetails Objitem)
{
if (Objitem.Email == null)
{
Objitem.Email = "";
}
if (Objitem.PANNO == null)
{
Objitem.PANNO = "";
}
if (Objitem.IvoiceHeading == null)
{
Objitem.IvoiceHeading = "";
}
if (Objitem.Address == null)
{
Objitem.Address = "";
}
if (Objitem.AddressLin2 == null)
{
Objitem.AddressLin2 = "";
}
if (Objitem.AddressLine3 == null)
{
Objitem.AddressLine3 = "";
}
if (Objitem.Licence2 == null)
{
Objitem.Licence2 = "";
}
if (Objitem.License3 == null)
{
Objitem.License3 = "";
}
if (Objitem.Logo == null)
{
Objitem.Logo = "";
}
if (Objitem.Cell == null)
{
Objitem.Cell = "";
}
if (Objitem.WebSite == null)
{
Objitem.WebSite = "";
}
if (Objitem.GSTNO == null)
{
Objitem.GSTNO = "";
}
if (Objitem.BankName == null)
{
Objitem.BankName = "";
}
if (Objitem.AcType == null)
{
Objitem.AcType = "";
}
if (Objitem.ACNO == null)
{
Objitem.ACNO = "";
}
if (Objitem.PrintRemark == null)
{
Objitem.PrintRemark = "";
}
if (Objitem.InvoiceTitle == null)
{
Objitem.InvoiceTitle = "";
}
if (Objitem.invoicePhone == null)
{
Objitem.invoicePhone = "";
}
if (Objitem.City == null || Objitem.City == "0" || Objitem.City == "")
{
return(Json(new { msg = "Please Select City" }));
}
if (Objitem.DistrictId == 0)
{
return(Json(new { msg = "Please Select Tehsil" }));
}
int i = Objitem.Save();
if (i > 0)
{
return(RedirectToAction("Index"));
}
return(RedirectToAction("Error"));
}
public ActionResult PostToAccount(int OrgId)
{
Accounts Obj = new Accounts();
Accounts AObj = new Accounts();
Accounts A0Obj = new Accounts();
Accounts A1Obj = new Accounts();
Accounts A2Obj = new Accounts();
Accounts A3Obj = new Accounts();
Accounts A4Obj = new Accounts();
int LastEntryNo = 0;
int JLastEntryNo = 0;
int RLastEntryNo = 0;
int PLastEntryNo = 0;
Ledger LedgerDetails = Ledger.GetAllList().Where(w => w.OrgId == OrgId).FirstOrDefault();
Receipt GetReceiptEntry = Receipt.GetAllList(OrgId, 0)
.Where(w => w.Date >= LedgerDetails.CalculationStartFrom).LastOrDefault();
double GetAmountSum = Receipt.GetAllList(OrgId, 0)
.Where(w => w.Date >= LedgerDetails.CalculationStartFrom).Select(s => s.Amount).Sum();
Accounts GetACBalance = Accounts.GetAllACDetails(OrgId)
.Where(w => w.AOrgId == OrgId).LastOrDefault();
Obj.Date = DateTime.Now;
Obj.Narration = "Online payments from customers";
Obj.DRAmount = GetAmountSum;
if (GetACBalance != null)
{
AObj.Balance = GetACBalance.Balance - AObj.DRAmount;
}
else
{
AObj.Balance = GetAmountSum;
}
Obj.AOrgId = OrgId;
Obj.ADRLedgerId = GetReceiptEntry.DRLedgerId;
Obj.ACRLedgerId = GetReceiptEntry.CRLedgerId;
Obj.DRGroupId = GetReceiptEntry.DRGroupId;
Obj.CRGroupId = 12;
Obj.EntryType = "Receipt";
Obj.ReceiptID = GetReceiptEntry.ID;
try
{
RLastEntryNo = Accounts.GetAllACDetails(OrgId).Where(w => w.EntryType == "Receipt").Select(s => s.EntryNo).Last();
}
catch (Exception ex)
{
ex.ToString();
}
if (RLastEntryNo > 0)
{
RLastEntryNo = RLastEntryNo + 1;
}
else
{
RLastEntryNo = 1;
}
Obj.EntryNo = RLastEntryNo;
Obj.SaveGeneral();
//=====================================================================================================
AObj.Date = DateTime.Now;
AObj.Narration = "Online payments from customers";
AObj.CRAmount = GetAmountSum;
if (GetACBalance != null)
{
AObj.Balance = GetACBalance.Balance + AObj.CRAmount;
}
else
{
AObj.Balance = GetAmountSum;
}
AObj.AOrgId = OrgId;
AObj.ADRLedgerId = GetReceiptEntry.CRLedgerId;
AObj.ACRLedgerId = LedgerDetails.ID;
AObj.DRGroupId = GetReceiptEntry.CRGroupId;
AObj.CRGroupId = 2;
AObj.EntryType = "Journal";
AObj.ReceiptID = GetReceiptEntry.ID;
try
{
JLastEntryNo = Accounts.GetAllACDetails(OrgId).Where(w => w.EntryType == "Journal").Select(s => s.EntryNo).Last();
}
catch (Exception ex)
{
ex.ToString();
}
if (JLastEntryNo > 0)
{
JLastEntryNo = JLastEntryNo + 1;
}
else
{
JLastEntryNo = 1;
}
AObj.EntryNo = JLastEntryNo;
AObj.SaveGeneral();
//=============================================================
if (AObj.Balance > 0)
{
Ledger Commission = Ledger.GetAllList().Where(w => w.Name == "Commission").FirstOrDefault();
A0Obj.Date = DateTime.Now;
A0Obj.Narration = "Commission Invoice";
double cAmount = (AObj.Balance * LedgerDetails.MarginOnline) / 100;
A0Obj.DRAmount = cAmount + (cAmount * LedgerDetails.TaxOnAboveMarginOnline) / 100;
A0Obj.Balance = AObj.Balance - A0Obj.DRAmount;
A0Obj.AOrgId = OrgId;
A0Obj.ADRLedgerId = LedgerDetails.ID;
A0Obj.ACRLedgerId = Commission.ID;
A0Obj.DRGroupId = 2;
A0Obj.CRGroupId = 9;
A0Obj.EntryType = "Sale";
A0Obj.ReceiptID = GetReceiptEntry.ID;
try
{
LastEntryNo = Accounts.GetAllACDetails(OrgId).Where(w => w.EntryType == "Sale").Select(s => s.EntryNo).Last();
}
catch (Exception ex)
{
ex.ToString();
}
if (LastEntryNo > 0)
{
LastEntryNo = LastEntryNo + 1;
}
else
{
LastEntryNo = 1;
}
A0Obj.EntryNo = LastEntryNo;
A0Obj.SaveGeneral();
//A0Obj.ACID = A0Obj.AID;
//A0Obj.ADSave();
//=============================================================
// Ledger Commission = Ledger.GetAllList().Where(w => w.Name == "Commission").FirstOrDefault();
A1Obj.Date = DateTime.Now;
A1Obj.Narration = "Theater Commission";
A1Obj.CRAmount = (AObj.Balance * LedgerDetails.MarginOnline) / 100;
A1Obj.Balance = A0Obj.Balance;
A1Obj.AOrgId = OrgId;
A1Obj.ADRLedgerId = LedgerDetails.ID;
A1Obj.ACRLedgerId = Commission.ID;
A1Obj.DRGroupId = 2;
A1Obj.CRGroupId = 9;
A1Obj.EntryType = "Sale";
A1Obj.ReceiptID = GetReceiptEntry.ID;
A1Obj.ACID = A0Obj.AID;
A1Obj.ADSave();
//=================================================================================
HG_OrganizationDetails Objitem = new HG_OrganizationDetails();
HG_OrganizationDetails State = Objitem.GetAll(OrgId).FirstOrDefault();
if (State.State == "17")
{
if (LedgerDetails.TaxOnAboveMarginOnline == 5)
{
Ledger CGST = Ledger.GetAllList().Where(w => w.Name == "CGST Local Sale 2.5%").FirstOrDefault();
Ledger SGST = Ledger.GetAllList().Where(w => w.Name == "SGST Local Sale 2.5%").FirstOrDefault();
A2Obj.Narration = "CGST Local Sale @2.5%";
A3Obj.Narration = "SGST Local Sale @2.5%";
A2Obj.ADRLedgerId = Commission.ID;
A2Obj.ACRLedgerId = CGST.ID;
A3Obj.ADRLedgerId = Commission.ID;
A3Obj.ACRLedgerId = SGST.ID;
}
if (LedgerDetails.TaxOnAboveMarginOnline == 12)
{
Ledger CGST = Ledger.GetAllList().Where(w => w.Name == "CGST Local Sale 6%").FirstOrDefault();
Ledger SGST = Ledger.GetAllList().Where(w => w.Name == "SGST Local Sale 6%").FirstOrDefault();
A2Obj.Narration = "CGST Local Sale @6%";
A3Obj.Narration = "SGST Local Sale @6%";
A2Obj.ADRLedgerId = Commission.ID;
A2Obj.ACRLedgerId = CGST.ID;
A3Obj.ADRLedgerId = Commission.ID;
A3Obj.ACRLedgerId = SGST.ID;
}
if (LedgerDetails.TaxOnAboveMarginOnline == 18)
{
Ledger CGST = Ledger.GetAllList().Where(w => w.Name == "CGST Local Sale 9%").FirstOrDefault();
Ledger SGST = Ledger.GetAllList().Where(w => w.Name == "SGST Local Sale 9%").FirstOrDefault();
A2Obj.Narration = "CGST Local Sale @9%";
A3Obj.Narration = "SGST Local Sale @9%";
A2Obj.ADRLedgerId = Commission.ID;
A2Obj.ACRLedgerId = CGST.ID;
A3Obj.ADRLedgerId = Commission.ID;
A3Obj.ACRLedgerId = SGST.ID;
}
if (LedgerDetails.TaxOnAboveMarginOnline == 28)
{
Ledger CGST = Ledger.GetAllList().Where(w => w.Name == "CGST Local Sale 14%").FirstOrDefault();
Ledger SGST = Ledger.GetAllList().Where(w => w.Name == "SGST Local Sale 14%").FirstOrDefault();
A2Obj.Narration = "CGST Local Sale @14%";
A3Obj.Narration = "SGST Local Sale @14%";
A2Obj.ADRLedgerId = Commission.ID;
A2Obj.ACRLedgerId = CGST.ID;
A3Obj.ADRLedgerId = Commission.ID;
A3Obj.ACRLedgerId = SGST.ID;
}
A2Obj.Date = DateTime.Now;
A3Obj.Date = DateTime.Now;
A2Obj.CRAmount = ((A1Obj.DRAmount * LedgerDetails.TaxOnAboveMarginOnline) / 100) / 2;
A3Obj.CRAmount = ((A1Obj.DRAmount * LedgerDetails.TaxOnAboveMarginOnline) / 100) / 2;
A2Obj.Balance = A1Obj.Balance;
A3Obj.Balance = A1Obj.Balance;
A2Obj.AOrgId = OrgId;
A3Obj.AOrgId = OrgId;
A2Obj.DRGroupId = 9;
A2Obj.CRGroupId = 3;
A3Obj.DRGroupId = 9;
A3Obj.CRGroupId = 3;
A2Obj.EntryType = "sale";
A2Obj.ReceiptID = GetReceiptEntry.ID;
A3Obj.EntryType = "sale";
A3Obj.ReceiptID = GetReceiptEntry.ID;
A2Obj.SaveGeneral();
A3Obj.SaveGeneral();
}
else
{
if (LedgerDetails.TaxOnAboveMarginOnline == 5)
{
Ledger IGST = Ledger.GetAllList().Where(w => w.Name == "IGST Central Sale 5%").FirstOrDefault();
A2Obj.Narration = "IGST Central Sale @5%";
A2Obj.ADRLedgerId = Commission.ID;
A2Obj.ACRLedgerId = IGST.ID;
}
if (LedgerDetails.TaxOnAboveMarginOnline == 12)
{
Ledger IGST = Ledger.GetAllList().Where(w => w.Name == "IGST Central Sale 12%").FirstOrDefault();
A2Obj.Narration = "IGST Central Sale @12%";
A2Obj.ADRLedgerId = Commission.ID;
A2Obj.ACRLedgerId = IGST.ID;
}
if (LedgerDetails.TaxOnAboveMarginOnline == 18)
{
Ledger IGST = Ledger.GetAllList().Where(w => w.Name == "IGST Central Sale 18%").FirstOrDefault();
A2Obj.Narration = "IGST Central Sale @18%";
A2Obj.ADRLedgerId = Commission.ID;
A2Obj.ACRLedgerId = IGST.ID;
}
if (LedgerDetails.TaxOnAboveMarginOnline == 28)
{
Ledger IGST = Ledger.GetAllList().Where(w => w.Name == "IGST Central Sale 28%").FirstOrDefault();
A2Obj.Narration = "IGST Central Sale @28%";
A2Obj.ADRLedgerId = Commission.ID;
A2Obj.ACRLedgerId = IGST.ID;
}
Ledger Tax = Ledger.GetAllList().Where(w => w.Name == "Commission").FirstOrDefault();
A2Obj.Date = DateTime.Now;
A2Obj.CRAmount = (A1Obj.CRAmount * LedgerDetails.TaxOnAboveMarginOnline) / 100;
A2Obj.Balance = A0Obj.Balance;
A2Obj.AOrgId = OrgId;
A2Obj.DRGroupId = 9;
A2Obj.CRGroupId = 3;
A2Obj.ACID = A0Obj.AID;
A2Obj.ADSave();
}
A4Obj.Date = DateTime.Now;
A4Obj.Narration = "Balance Amount Transfered";
A4Obj.DRAmount = A0Obj.Balance;
A4Obj.Balance = A0Obj.Balance - A4Obj.DRAmount;
A4Obj.AOrgId = OrgId;
A4Obj.ADRLedgerId = LedgerDetails.ID;
A4Obj.ACRLedgerId = 67;
A4Obj.DRGroupId = 2;
A4Obj.CRGroupId = 1;
A4Obj.EntryType = "Payment";
try
{
PLastEntryNo = Accounts.GetAllACDetails(OrgId).Where(w => w.EntryType == "Payment").Select(s => s.EntryNo).Last();
}
catch (Exception ex)
{
ex.ToString();
}
if (PLastEntryNo > 0)
{
PLastEntryNo = PLastEntryNo + 1;
}
else
{
PLastEntryNo = 1;
}
A4Obj.EntryNo = PLastEntryNo;
A4Obj.SaveGeneral();
}
return(Json(new { data = AObj }, JsonRequestBehavior.AllowGet));
}
public ActionResult EntryToAccount(int OrgId)
{
Accounts Obj = new Accounts();
Accounts AObj = new Accounts();
Accounts AObj1 = new Accounts();
Accounts ADObj = new Accounts();
List <Accounts> ADObjList = new List <Accounts>();
Commission AllCommissions = Commission.GetAllCommissions().Where(w => w.OrgId == OrgId).Last();
BalanceStatement LastRecords = BalanceStatement.GetAllForBalanceCalculation(OrgId).Last();
BalanceStatement FirstRecords = BalanceStatement.GetAllForBalanceCalculation(OrgId).Where(w => w.Narration == "Opening Balance").Last();
Sale AllSales = Sale.GetAllSales().Where(w => w.OrgId == OrgId).Last();
Accounts FirstAccountRecords = Accounts.GetAll().Where(w => w.Narration == "Opening Balance").FirstOrDefault();
if (FirstAccountRecords == null)
{
Obj.Date = FirstRecords.Date;
Obj.Narration = "Opening Balance";
Obj.AOrgId = OrgId;
if (AllSales == null)
{
Obj.DRAmount = 0.00;
}
else
{
Obj.DRAmount = LastRecords.Balance;
}
Obj.SaveGeneral();
}
AObj.DRAmount = AllSales.SaleAmount;
AObj.Narration = "Online Payment received Entry No." + AllSales.EntryNo;
AObj.Balance = AllSales.SaleAmount;
AObj.Date = DateTime.Now;
AObj.AOrgId = OrgId;
AObj.SaveGeneral();
//===============================================
HG_OrganizationDetails Objitem = new HG_OrganizationDetails();
HG_OrganizationDetails State = Objitem.GetAll(OrgId).FirstOrDefault();
Ledger LedgerDetails = Ledger.GetAllList().Where(x => x.DebtorType == 1 &&
x.OrgId == OrgId).FirstOrDefault();
AObj1.CRAmount = AllCommissions.CommissionAmount;
AObj1.Narration = "Commission Invoice No." + AllCommissions.EntryNo;
AObj1.Balance = AllSales.SaleAmount - AllCommissions.CommissionAmount;
AObj1.Date = DateTime.Now;
AObj1.AOrgId = OrgId;
// entry to Account Details
if (State.State == "17")
{
for (int i = 1; i <= 2; i++)
{
ADObj = new Accounts();
if (i == 1)
{
ADObj.ADDate = DateTime.Now;
ADObj.ADAmount = AllCommissions.CommissionAmount * (LedgerDetails.TaxOnAboveMargin / 2) / 100;
ADObj.CRLedgerId = 13;
ADObj.ADGroupId = 3;
ADObj.AOrgId = OrgId;
ADObjList.Add(ADObj);
}
else if (i == 2)
{
ADObj.ADDate = DateTime.Now;
ADObj.ADAmount = AllCommissions.CommissionAmount * (LedgerDetails.TaxOnAboveMargin / 2) / 100;
ADObj.CRLedgerId = 17;
ADObj.ADGroupId = 3;
ADObj.AOrgId = OrgId;
ADObjList.Add(ADObj);
}
}
}
else
{
ADObj.ADDate = DateTime.Now;
ADObj.ADAmount = (AllCommissions.CommissionAmount * LedgerDetails.TaxOnAboveMargin) / 100;
ADObj.CRLedgerId = 21;
ADObj.ADGroupId = 3;
ADObj.AOrgId = OrgId;
ADObjList.Add(ADObj);
}
//=============================
AObj1.Save(ADObjList);
return(Json(new { data = AllCommissions }, JsonRequestBehavior.AllowGet));
}
public JsonResult Upload(int OrgID, System.Web.HttpPostedFileBase UplXl)
{
string msg = "Uploaded Succesfully";
if (OrgID <= 0)
{
return(Json(new { msg = "Select Organization First" }));
}
if (UplXl == null)
{
return(Json(new { msg = "Upload Excel File First" }));
}
try
{
UplXl.SaveAs(System.IO.Path.Combine(Server.MapPath("~/Image/"), UplXl.FileName));
var DT = ReadExl.ReadExcelFileDT("~/Image/" + UplXl.FileName);
if (DT.Rows.Count > 0)
{
HG_OrganizationDetails ObjOrg = new HG_OrganizationDetails().GetOne(OrgID);
int OrgType = int.Parse(ObjOrg.OrgTypes);
List <HG_Tables_or_Sheat> ListTorS = new HG_Tables_or_Sheat().GetAll(OrgType, OrgID);
List <HG_Floor_or_ScreenMaster> ListFlrScr = new HG_Floor_or_ScreenMaster().GetAll(OrgType, OrgID);
List <HG_FloorSide_or_RowName> ListFsideorRowName = new HG_FloorSide_or_RowName().GetAll(OrgType, OrgID);
for (int i = 1; i < DT.Rows.Count; i++)
{
string TableorSheatName = (DT.Rows[i][0] == null ? "" : DT.Rows[i][0].ToString());
string FlrOrScrName = (DT.Rows[i][1] == null?"": DT.Rows[i][1].ToString());
string FlrSideOrRowName = (DT.Rows[i][2] == null ? "" : DT.Rows[i][2].ToString());
string QrCode = (DT.Rows[i][3] == null ? "" : DT.Rows[i][3].ToString().Replace(" ", ""));
string QrCodeOld = QrCode;
if (QrCode == "" || QrCode.Trim() == "" || QrCode == "0")
{
QrCode = "0";
}
else
{
HG_Tables_or_Sheat TorSAlreadyObj = new HG_Tables_or_Sheat().GetOne(QrOcde: QrCode);
if (TorSAlreadyObj != null && TorSAlreadyObj.QrCode != "0" && TorSAlreadyObj.QrCode != "" && TorSAlreadyObj.Table_or_RowID > 0)
{
QrCode = "0";
}
}
var ObjFlrScr = ListFlrScr.Find(x => x.Name.ToUpper() == FlrOrScrName.ToUpper());
var ObjFsideOrRoName = ListFsideorRowName.Find(x => x.FloorSide_or_RowName.ToUpper() == FlrSideOrRowName.ToUpper());
if (ObjFlrScr == null && FlrOrScrName.Replace(" ", "") != "")
{
ObjFlrScr = new HG_Floor_or_ScreenMaster();
ObjFlrScr.Name = FlrOrScrName;
ObjFlrScr.Type = ObjOrg.OrgTypes;
ObjFlrScr.OrgID = OrgID;
ObjFlrScr.save();
ListFlrScr.Add(ObjFlrScr);
}
if (ObjFsideOrRoName == null && FlrSideOrRowName.Replace(" ", "") != "")
{
ObjFsideOrRoName = new HG_FloorSide_or_RowName();
ObjFsideOrRoName.FloorSide_or_RowName = FlrSideOrRowName;
ObjFsideOrRoName.OrgID = OrgID;
ObjFsideOrRoName.Type = ObjOrg.OrgTypes;
ObjFsideOrRoName.save();
ListFsideorRowName.Add(ObjFsideOrRoName);
}
if (ObjFsideOrRoName != null && ObjFlrScr != null)
{
var ObjTblOrShtExit = ListTorS.Find(x => x.Table_or_SheetName.ToUpper() == TableorSheatName.ToUpper() && (x.Floor_or_ScreenId == ObjFlrScr.Floor_or_ScreenID) && (x.FloorSide_or_RowNoID == ObjFsideOrRoName.ID));
if (ObjTblOrShtExit == null && TableorSheatName.Replace(" ", "") != "")
{
HG_Tables_or_Sheat hG_Tables_Or_Sheat = new HG_Tables_or_Sheat();
hG_Tables_Or_Sheat.OrgId = OrgID;
hG_Tables_Or_Sheat.Type = ObjOrg.OrgTypes;
hG_Tables_Or_Sheat.Table_or_SheetName = TableorSheatName;
hG_Tables_Or_Sheat.QrCode = QrCode;
hG_Tables_Or_Sheat.Floor_or_ScreenId = ObjFlrScr.Floor_or_ScreenID;
hG_Tables_Or_Sheat.FloorSide_or_RowNoID = ObjFsideOrRoName.ID;
hG_Tables_Or_Sheat.save();
ListTorS.Add(hG_Tables_Or_Sheat);
}
else if (ObjTblOrShtExit != null && (ObjTblOrShtExit.QrCode != QrCodeOld) && (QrCode != ""))
{
ObjTblOrShtExit.QrCode = QrCode;
ObjTblOrShtExit.save();
}
}
else
{
msg = "Uploaded Succesfully. With Some Data Missing";
}
}
}
else
{
return(Json(new { msg = "No Any Row Founds" }));
}
}
catch (Exception e)
{
return(Json(new { msg = "Error " + e.Message }));
}
return(Json(new { msg = msg }, JsonRequestBehavior.AllowGet));
}
