public void Delete(int Id)
{
tbl_Location location = db.tbl_Location.Find(Id);
db.tbl_Location.Remove(location);
Save();
}
/// <summary>
/// Get Location details By ID -Srikanth
/// </summary>
/// <param name="locationID"></param>
/// <returns></returns>
public PartialViewResult GetLocationByID(string locationID)
{
LocationModel LM = new LocationModel();
LM = LocationBL.MLocationModel();
tbl_Location location;
LocationBL.EmailID = User.Identity.Name;
location = LocationBL.GetByID(locationID.Trim());
if (location == null)
{
location = new tbl_Location();
}
LM.LocationID = location.LocationID;
LM.LocationDesc = location.LocationDesc;
LM.Address1 = location.Address1;
LM.Address2 = location.Address2;
LM.Address3 = location.Address3;
LM.POBox = location.POBox;
LM.Contact = location.Contact;
LM.Phone = location.Phone;
LM.Fax = location.Fax;
LM.Email = location.Email;
LM.City = location.City;
LM.Region = location.Region;
LM.Country = location.Country;
LM.BusinessArea = location.BusinessArea;
LM.FieldArea = location.FieldArea;
LM.CashLoan = location.CashLoan;
return(PartialView("~/Views/Location/Partial/_LocationDetailsPartial.cshtml", LM));
}
/// <summary>
/// Delete location by location model
/// </summary>
/// <param name="location"></param>
/// <returns></returns>
public bool DeleteByLocationDetails(tbl_Location location)
{
try
{
Context.Location.Delete(location);
Context.Location.Save();
return(true);
}
catch (Exception ex)
{
//POS Log Exception to db table
return(false);
}
finally
{
// Context = null;
}
}
/// <summary>
/// Update location by location model
/// </summary>
/// <param name="location"></param>
/// <returns></returns>
public string Update(tbl_Location location)
{
try
{
Context.Location.Update(location);
Context.Location.Save();
return(location.LocationDesc + " Updated Successfully!!");
}
catch (Exception ex)
{
//POS Log Exception to db table
return("Error in saving details, Please try again!!");
}
finally
{
// Context = null;
}
}
public bool addLocationDetails(string lat, string lon, int id)
{
bool _isLocated = false;
try
{
tbl_Location locObj = new tbl_Location();
locObj.Latitude = lat;
locObj.Longitude = lon;
locObj.VendorID = id;
locObj.CustomerID = 0;
dbContext.tbl_Locations.InsertOnSubmit(locObj);
dbContext.SubmitChanges();
_isLocated = true;
}
catch (Exception ex)
{
}
return(_isLocated);
}
/// <summary>
/// Insert or Update in tbl_Location table -Srikanth
/// </summary>
/// <param name="location"></param>
/// <returns></returns>
public string InsertOrUpdate(LocationModel LM)
{
string result = string.Empty;
bool isExist = false;
tbl_Location location;
location = this.GetByID(LM.LocationID.Trim());
if (location != null)
{
isExist = true;
}
else
{
location = new tbl_Location();
}
location.LocationID = LM.LocationID;
location.LocationDesc = LM.LocationDesc;
location.Address1 = LM.Address1;
location.Address2 = LM.Address2;
location.Address3 = LM.Address3;
location.POBox = LM.POBox;
location.Contact = LM.Contact;
location.Phone = LM.Phone;
location.Fax = LM.Fax;
location.Email = LM.Email;
location.City = LM.City;
location.Region = LM.Region;
location.Country = LM.Country;
location.FieldArea = LM.FieldArea;
location.CashLoan = LM.CashLoan;
if (!isExist)
{
return(result = this.Insert(location));
}
else
{
return(result = this.Update(location));
}
}
public List <Vendor> getVendor(string lat, string lon, string ServiceType)
{
double custlat = Convert.ToDouble(lat);
double custlon = Convert.ToDouble(lon);
tbl_Location LocObj = new tbl_Location();
var query = from l in dbContext.tbl_Locations
orderby l.VendorID
select l;
foreach (var vendor in query)
{
Vendor ven = new Vendor();
//var v=vendor.Latitude;
double venlat = Convert.ToDouble(vendor.Latitude);
double venlon = Convert.ToDouble(vendor.Longitude);
double dist = distance(venlon, custlon, venlat, custlat);
var obj = (from r in vendorcontext.tbl_VendorLogins
where r.VendorID == vendor.VendorID
where r.MaxServiceDistance > dist
where r.VendorProfession.Equals(ServiceType)
select r).FirstOrDefault();
if (obj != null)
{
ven.VendorName = obj.VendorName;
ven.VendorProfesssion = obj.VendorProfession;
ven.VendorId = obj.VendorID;
ven.Basic = (int)obj.VisitingCharges;
vname.Add(ven);
}
}
return(vname);
}
public ActionResult Create(tbl_Location location)
{
try
{
if (ModelState.IsValid)
{
objBs.locationBs.Insert(location);
TempData["Msg"] = "created Succesfully";
return(RedirectToAction("Index"));
}
else
{
TempData["Msg"] = "create failed";
return(RedirectToAction("Index"));
}
}
catch (Exception e1)
{
TempData["Msg"] = "create failed: " + e1.Message;
return(Redirect("Index"));
}
}
public string InsertOrUpdateLocation(LocationModel LM)
{
string result = string.Empty;
tbl_Location location = new tbl_Location();
location.LocationID = LM.LocationID;
location.LocationDesc = LM.LocationDesc;
location.Address1 = LM.Address1;
location.Address2 = LM.Address2;
location.Address3 = LM.Address3;
location.POBox = LM.POBox;
location.Contact = LM.Contact;
location.Phone = LM.Phone;
location.Fax = LM.Fax;
location.Email = LM.Email;
location.City = LM.City;
location.Region = LM.Region;
location.Country = LM.Country;
location.FieldArea = LM.FieldArea;
location.CashLoan = LM.CashLoan;
result = LocationBL.InsertOrUpdate(LM);
return(result);
}
public void Insert(tbl_Location location)
{
objdb.Insert(location);
}
//public void ReturnToSupplierDetails(string LocationID, string VendorID, string StorageID, string DocID, decimal? Quantity, string MaterialID, string UOM)
//{
// try
// {
// int Increment = Convert.ToInt32(DocID) + 1;
// string DocumentID = LocationID + Increment;
// Context.Proc_InsertRetunToSupplier(DocumentID, LocationID, MaterialID, UOM, "VInod", StorageID, VendorID, Quantity ?? 0);
// }
// catch (Exception ex)
// {
// }
//}
public void UpdateDocId(tbl_Location Location)
{
Context.Location.Update(Location);
Context.Location.Save();
}
public void Update(tbl_Location location)
{
db.Entry(location).State = EntityState.Modified;
}
partial void Inserttbl_Location(tbl_Location instance);
public void Insert(tbl_Location location)
{
db.tbl_Location.Add(location);
Save();
}
public string InsertTempMaterProductionOrder(string MaterialID, string UOM, string Qty, string LocationID, string UserName, string StorageID)
{
tbl_Location Location = LocationBL.GetByID(LocationID.Trim());
int Docid = Convert.ToInt32(Location.Prod_Order);
int cnt = Docid + 1;
string DocumentID = (LocationID + cnt).ToString().Trim();
List <tbl_Company> Company = Context.Company.Get().ToList();
string CompanyID = Company.FirstOrDefault().CompanyID;
string TempMasterID = null;
try
{
tbl_TempMaster TempMasterHeader = new tbl_TempMaster();
TempMasterHeader = Context.TempMaster.Get(e => e.LocationID == LocationID && e.DocumentID == DocumentID).FirstOrDefault();
if (TempMasterHeader != null)
{
TempMasterID = TempMasterHeader.TempMasterID.ToString();
}
else
{
TempMasterHeader = new tbl_TempMaster();
}
if (TempMasterID == string.Empty || TempMasterID == null)
{
TempMasterHeader.DocumentID = DocumentID;
TempMasterHeader.PONumber = DocumentID;
TempMasterHeader.AddDate = DateTime.Now;
TempMasterHeader.CompanyID = CompanyID;
TempMasterHeader.DocumentDate = DateTime.Now;
TempMasterHeader.Filter = "";
TempMasterHeader.Filter_Id = "";
TempMasterHeader.LocationID = LocationID;
TempMasterHeader.PostingDate = DateTime.Now;
TempMasterHeader.StorageID = StorageID;
TempMasterHeader.Type = "PDO";
TempMasterHeader.UserID = UserName;
TempMasterHeader.DocDetail = "Production Order";
Context.TempMaster.Insert(TempMasterHeader);
Context.TempMaster.Save();
}
TempMasterHeader = Context.TempMaster.Get(e => e.LocationID == LocationID && e.DocumentID == DocumentID).FirstOrDefault();
if (TempMasterHeader != null)
{
TempMasterID = TempMasterHeader.TempMasterID.ToString();
StorageID = TempMasterHeader.StorageID.ToString();
}
tbl_TempDetail TempDetail = new tbl_TempDetail();
TempDetail.MaterialID = MaterialID;
TempDetail.UOM = UOM;
TempDetail.AddDate = DateTime.Now;
TempDetail.BaseQty = Convert.ToDecimal(Qty);
TempDetail.CategoryID = "";
TempDetail.CompanyID = CompanyID;
TempDetail.DocumentDate = DateTime.Now;
TempDetail.DocumentID = DocumentID;
TempDetail.LocationID = LocationID;
TempDetail.PostingDate = DateTime.Now;
if (StorageID == null)
{
}
else
{
TempDetail.StorageID = StorageID;
}
TempDetail.TranQty = Convert.ToDecimal(Qty);
TempDetail.UpdDate = DateTime.Now;
TempDetail.UserID = UserName;
TempDetail.TempMasterID = Convert.ToInt32(TempMasterID);
TempDetail.CreditQty = 0.00M;
TempDetail.Cost = 0.00M;
TempDetail.DiscountRate = 0.00M;
TempDetail.Amount = 0.00M;
TempDetail.CreditAmount = 0.00M;
TempDetail.OrderQty = 0.00M;
TempDetail.Type = "PDO";
List <tbl_TempDetail> CheckTempDetails = Context.TempDetail.Get(e => e.LocationID == LocationID && e.MaterialID == MaterialID && e.UOM == UOM).ToList();
if (CheckTempDetails.Count >= 1)
{
TempDetail = CheckTempDetails.FirstOrDefault();
TempDetail.TranQty = Convert.ToDecimal(Qty) + CheckTempDetails.FirstOrDefault().TranQty;
TempDetail.BaseQty = TempDetail.TranQty;
Context.TempDetail.Update(TempDetail);
Context.tempDetail.Save();
}
else
{
Context.TempDetail.Insert(TempDetail);
Context.TempDetail.Save();
}
}
catch (Exception ex)
{
}
return(TempMasterID);
}
public void Update(tbl_Location location)
{
objdb.Update(location);
}
/// <summary>
/// Get all location from POS database
/// </summary>
/// <returns></returns>
public List <tbl_Location> GetAll()
{
AuthenticationBL AuthenticationBL = new AuthenticationBL();
List <tbl_Location> Locations = new List <tbl_Location>();
try
{
EmailID = System.Web.HttpContext.Current.User.Identity.Name.ToString();
if (EmailID == "*****@*****.**")
{
if (Locations == null)
{
if (Locations.Count == 0)
{
Locations = Context.Location.Get().ToList();
}
}
else
{
Locations = new List <tbl_Location>();
Locations = Context.Location.Get().ToList();
}
}
else
{
if (UserAuthentication == "UserAuthentication")
{
List <Proc_AspNetManagerLocations_Result> Proc_AspNetManagerLocations_Result = new List <Entity.Entities.Proc_AspNetManagerLocations_Result>();
Proc_AspNetManagerLocations_Result = AuthenticationBL.AspNetManagerLocationAuthentication(EmailID);
foreach (Proc_AspNetManagerLocations_Result item in Proc_AspNetManagerLocations_Result)
{
tbl_Location UserLocation = new tbl_Location();
UserLocation.LocationID = item.LocationID;
UserLocation.LocationDesc = item.LocationDesc;
Locations.Add(UserLocation);
}
}
else
{
List <Proc_AspNetUsersLocations_Result> Proc_AspNetUsersLocations_Result = new List <Entity.Entities.Proc_AspNetUsersLocations_Result>();
Proc_AspNetUsersLocations_Result = AuthenticationBL.AspNetUserLocationAuthentication(EmailID);
foreach (Proc_AspNetUsersLocations_Result item in Proc_AspNetUsersLocations_Result)
{
tbl_Location UserLocation = new tbl_Location();
UserLocation.LocationID = item.LocationID;
UserLocation.LocationDesc = item.LocationDesc;
Locations.Add(UserLocation);
}
}
}
return(Locations);
}
catch (Exception ex)
{
//POS Log Exception to db table
return(null);
}
finally
{
Locations = null;
}
}
partial void Updatetbl_Location(tbl_Location instance);
partial void Deletetbl_Location(tbl_Location instance);