public ActionResult Create(LocationVM v) { if (ModelState.IsValid) { LocationMaster ob = new LocationMaster(); int max = (from c in db.LocationMasters orderby c.LocationID descending select c.LocationID).FirstOrDefault(); if (max == null) { ob.LocationID = 1; ob.Location = v.Location; ob.CityID = v.CityID; } else { ob.LocationID = max + 1; ob.Location = v.Location; ob.CityID = v.CityID; } db.LocationMasters.Add(ob); db.SaveChanges(); TempData["SuccessMsg"] = "You have successfully added Location."; return(RedirectToAction("Index")); } return(View(v)); }
public static string[] GetCompletionListLocationName(string prefixText, int count, string contextKey) { LocationMaster objLocationMaster = new LocationMaster(); DataTable dt = new DataView(objLocationMaster.GetLocationMaster(HttpContext.Current.Session["CompId"].ToString()), "Location_Name like '" + prefixText.ToString() + "%'", "", DataViewRowState.CurrentRows).ToTable(); dt = new DataView(dt, "Brand_Id='" + HttpContext.Current.Session["BrandId"].ToString() + "'", "", DataViewRowState.CurrentRows).ToTable(); if (dt.Rows.Count == 0) { dt = objLocationMaster.GetLocationMaster(HttpContext.Current.Session["CompId"].ToString()); dt = new DataView(dt, "Brand_Id='" + HttpContext.Current.Session["BrandId"].ToString() + "'", "", DataViewRowState.CurrentRows).ToTable(); } else { } string[] txt = new string[dt.Rows.Count]; for (int i = 0; i < dt.Rows.Count; i++) { txt[i] = dt.Rows[i]["Location_Name"].ToString(); } return(txt); }
public List <LocationMaster> Search(string city) { List <LocationMaster> lstsearch = new List <LocationMaster>(); DbCommand dbcommand = myDataBase.GetStoredProcCommand(DBConstant.SEARCH_LOCATION); // DbCommand dbcommand = myDataBase.GetSqlStringCommand("select * from Location where City ='" + city + "'"); myDataBase.AddInParameter(dbcommand, "@city", DbType.String, city); using (IDataReader readersearch = myDataBase.ExecuteReader(dbcommand)) { while (readersearch.Read()) { LocationMaster locationMaster = new LocationMaster(); locationMaster.LocationId = GetIntegerFromDataReader(readersearch, "LocationId"); locationMaster.CityId = GetIntegerFromDataReader(readersearch, "CityId"); locationMaster.LocationTitle = GetStringFromDataReader(readersearch, "LocationTitle"); locationMaster.City = GetStringFromDataReader(readersearch, "City"); locationMaster.CompanyName = GetStringFromDataReader(readersearch, "CompanyName"); locationMaster.LocationAddress = GetStringFromDataReader(readersearch, "LocationAddress"); locationMaster.Created_By = GetStringFromDataReader(readersearch, "Created_By"); locationMaster.Created_Date = GetDateFromReader(readersearch, "Created_Date"); locationMaster.Modified_By = GetStringFromDataReader(readersearch, "Modified_By"); //locationMaster.Modified_Date = GetDateFromReader(reader1, "ModifiedDate"); lstsearch.Add(locationMaster); } } return(lstsearch); }
protected void BtnDelete_Click(object sender, EventArgs e) { try { int DeleteId = 0; if (ViewState["EditID"] != null) { DeleteId = Convert.ToInt32(ViewState["EditID"]); } if (DeleteId != 0) { Entity_PR.LocationId = DeleteId; Entity_PR.LoginId = Convert.ToInt32(Session["UserID"]); Entity_PR.LoginDate = DateTime.Now; int iDelete = Obj_PR.DeleteRecord(ref Entity_PR, out StrError); if (iDelete != 0) { obj_Comm.ShowPopUpMsg("Record Deleted Successfully..!", this.Page); MakeEmptyForm(); } } Entity_PR = null; obj_Comm = null; } catch (Exception ex) { throw new Exception(ex.Message); } }
public async Task <IActionResult> PutLocationMaster([FromQuery] int id, [FromBody] LocationMaster locationMaster) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != locationMaster.Id) { return(BadRequest()); } locationMaster.ModifiedOn = DateTime.Now; _context.Entry(locationMaster).State = EntityState.Modified; try { await _context.SaveChangesAsync(); return(StatusCode(200, new { Msg = "Inserted!" })); } catch (Exception ex) { _ErrLogService.Log(ex, HttpContext); return(StatusCode(500, new { status = true, Msg = ex.Message })); } }
public List <LocationMaster> ReadCity(int?id) { List <LocationMaster> lst = new List <LocationMaster>(); DbCommand dbcommand = myDataBase.GetStoredProcCommand(DBConstant.READ_CITY); myDataBase.AddInParameter(dbcommand, "@in_CityId", DbType.Int32, id); using (IDataReader reader1 = myDataBase.ExecuteReader(dbcommand)) { while (reader1.Read()) { LocationMaster locationMaster = new LocationMaster(); locationMaster.CityId = GetIntegerFromDataReader(reader1, "CityId"); locationMaster.LocationTitle = GetStringFromDataReader(reader1, "DesCription"); locationMaster.City = GetStringFromDataReader(reader1, "CityName"); locationMaster.Country = GetStringFromDataReader(reader1, "COUNTRY_NAME"); locationMaster.CountryId = GetIntegerFromDataReader(reader1, "COUNTRY_ID"); locationMaster.stateName = GetStringFromDataReader(reader1, "state_name"); locationMaster.stateId = GetIntegerFromDataReader(reader1, "state_id"); locationMaster.Created_By = GetStringFromDataReader(reader1, "Created_By"); locationMaster.Created_Date = GetDateFromReader(reader1, "Created_Date"); locationMaster.Modified_By = GetStringFromDataReader(reader1, "Modified_By"); locationMaster.Modified_Date = GetDateFromReader(reader1, "Modified_Date"); lst.Add(locationMaster); } } return(lst); }
public List <LocationMaster> ReadLocation(int?LocationId) { List <LocationMaster> lst = new List <LocationMaster>(); DbCommand dbcommand = myDataBase.GetStoredProcCommand(DBConstant.READ_LOCATION); myDataBase.AddInParameter(dbcommand, "@in_LocationId", DbType.Int32, LocationId); using (IDataReader reader1 = myDataBase.ExecuteReader(dbcommand)) { while (reader1.Read()) { LocationMaster locationMaster = new LocationMaster(); locationMaster.LocationId = GetIntegerFromDataReader(reader1, "LocationId"); locationMaster.CityId = GetIntegerFromDataReader(reader1, "CityId"); locationMaster.LocationTitle = GetStringFromDataReader(reader1, "LocationTitle"); locationMaster.City = GetStringFromDataReader(reader1, "City"); locationMaster.CompanyName = GetStringFromDataReader(reader1, "CompanyName"); locationMaster.LocationAddress = GetStringFromDataReader(reader1, "LocationAddress"); locationMaster.Created_By = GetStringFromDataReader(reader1, "Created_By"); locationMaster.Created_Date = GetDateFromReader(reader1, "Created_Date"); locationMaster.Modified_By = GetStringFromDataReader(reader1, "Modified_By"); //locationMaster.Modified_Date = GetDateFromReader(reader1, "ModifiedDate"); lst.Add(locationMaster); } } return(lst); }
public long InsertUpdateLocationDetails(CompanyBE.LocationMasterBE lst) { if (lst.LocationID != 0) { var lstLocation = _ObjEINS_RBMSEntities.LocationMasters.FirstOrDefault(x => x.LocationId == lst.LocationID); lstLocation.LocationName = lst.LocationName; lstLocation.Description = lst.Description; lstLocation.LocationStatus = true; lstLocation.LastModifiedBy = lst.LastModifiedBy; lstLocation.LastModifiedOn = DateTime.Now; _ObjEINS_RBMSEntities.SaveChanges(); return(lstLocation.LocationId); } else { LocationMaster _ObjLocation = new LocationMaster(); _ObjLocation.LocationName = lst.LocationName; _ObjLocation.Description = lst.Description; _ObjLocation.LocationStatus = true; _ObjLocation.AddedBy = lst.AddedBy; _ObjLocation.AddedOn = DateTime.Now; _ObjEINS_RBMSEntities.AddToLocationMasters(_ObjLocation); _ObjEINS_RBMSEntities.SaveChanges(); return(_ObjLocation.LocationId); } }
public List <LocationMaster> ReadLocationbyId(int LocationId) { List <LocationMaster> listread = new List <LocationMaster>(); DbCommand dbcommand = myDataBase.GetStoredProcCommand(DBConstant.READ_LOCATION); // DbCommand dbcommand = myDataBase.GetSqlStringCommand("select * from Location where LocationId='" + LocationId + "' "); myDataBase.AddInParameter(dbcommand, "@in_LocationId", DbType.Int32, LocationId); using (IDataReader reader2 = myDataBase.ExecuteReader(dbcommand)) { while (reader2.Read()) { LocationMaster Readob = new LocationMaster(); Readob.LocationId = GetIntegerFromDataReader(reader2, "LocationId"); Readob.CityId = GetIntegerFromDataReader(reader2, "CityId"); Readob.CompanyName = GetStringFromDataReader(reader2, "CompanyName"); Readob.City = GetStringFromDataReader(reader2, "City"); Readob.LocationTitle = GetStringFromDataReader(reader2, "LocationTitle"); Readob.LocationAddress = GetStringFromDataReader(reader2, "LocationAddress"); Readob.Created_By = GetStringFromDataReader(reader2, "Created_By"); Readob.Created_Date = GetDateFromReader(reader2, "Created_Date"); Readob.Modified_By = GetStringFromDataReader(reader2, "Modified_By"); //Readob.Modified_Date = GetDateFromReader(reader2, "ModifiedDate"); listread.Add(Readob); } } return(listread); }
public IHttpActionResult UpdateLocation(LocationMaster location) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } try { // var objGM = new GaugeTypeMaster(); var objGM = new LocationMaster(); objGM = objEntity.LocationMasters.Find(location.ID); if (objGM != null) { objGM.ID = location.ID; objGM.LocationName = location.LocationName; } int i = this.objEntity.SaveChanges(); } catch (Exception ex) { throw ex; } return(Ok(location)); }
public async Task <IActionResult> PostLocationMaster([FromBody] LocationMaster locationMaster) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } try { bool exists = _context.LocationMaster.Any(x => x.Name.ToUpper() == locationMaster.Name.ToUpper()); if (!exists) { _context.LocationMaster.Add(locationMaster); await _context.SaveChangesAsync(); return(Ok(new { status = true, Msg = "Inserted" })); } else { return(Ok(new { status = false, Msg = "Already Exists!" })); } } catch (Exception ex) { _ErrLogService.Log(ex, HttpContext); return(StatusCode(500, new { status = true, Msg = ex.Message })); } }
public string GetFormattedValue(string format, string txtCtrl, string mode, string locID) { try { LocationMaster locationMstr = new LocationMaster(); string updateValue = ""; string formattedValue = ""; if (mode == "phone") { formattedValue = FormatContent(format.Trim(), txtCtrl); updateValue = "PhoneFmt='" + format.Trim().Replace("'", "''") + "',LocPhone='" + formattedValue; } else { formattedValue = FormatContent(format.Trim(), txtCtrl); updateValue = "PostCodeFmt='" + format.Trim().Replace("'", "''") + "',LocPostCode='" + formattedValue; } updateValue = updateValue + "'," + "ChangeID='" + Session["UserName"].ToString().Trim() + "'," + "ChangeDt='" + DateTime.Now.ToString() + "'"; string whereclause = "LocID=" + locID.Trim(); locationMstr.UpdateLocationMaster(updateValue, whereclause); return(formattedValue); } catch (Exception ex) { return(""); } }
public ActionResult DeleteConfirmed(int id) { LocationMaster locationmaster = db.LocationMasters.Find(id); db.LocationMasters.Remove(locationmaster); db.SaveChanges(); TempData["SuccessMsg"] = "You have successfully Deleted Location."; return(RedirectToAction("Index")); }
public void InsertConsulate(LocationMaster location) { DbCommand dbCommand = myDataBase.GetStoredProcCommand(DBConstant.CREATE_CONSULATE); // myDataBase.AddInParameter(dbCommand, "@in_LocationTitle", DbType.String, location.LocationTitle); myDataBase.AddInParameter(dbCommand, "@in_City", DbType.String, location.City); myDataBase.AddInParameter(dbCommand, "@in_CreatedBy", DbType.String, location.Created_By); myDataBase.AddInParameter(dbCommand, "@in_CreatedDate", DbType.DateTime, location.Created_Date); myDataBase.ExecuteNonQuery(dbCommand); }
public void UpdateConsulate(int Id, LocationMaster locationmasterUpdate) { DbCommand dbcommand = myDataBase.GetStoredProcCommand(DBConstant.UPDATE_CONSULATE); dbcommand.CommandType = CommandType.StoredProcedure; myDataBase.AddInParameter(dbcommand, "@in_LocationId", DbType.Int32, Id); myDataBase.AddInParameter(dbcommand, "@in_City ", DbType.String, locationmasterUpdate.City); myDataBase.AddInParameter(dbcommand, "@in_ModifiedBy", DbType.String, locationmasterUpdate.Modified_By); myDataBase.ExecuteNonQuery(dbcommand); }
public void InsertCity(LocationMaster location) { DbCommand dbCommand = myDataBase.GetStoredProcCommand(DBConstant.CREATE_CITY); myDataBase.AddInParameter(dbCommand, "@in_stateId", DbType.String, location.stateId); myDataBase.AddInParameter(dbCommand, "@in_City", DbType.String, location.City); myDataBase.AddInParameter(dbCommand, "@in_CreatedBy", DbType.String, location.Created_By); myDataBase.AddInParameter(dbCommand, "@in_CreatedDate", DbType.DateTime, location.Created_Date); myDataBase.ExecuteNonQuery(dbCommand); }
public void UpdateState(int Id, LocationMaster locationmasterUpdate) { DbCommand dbcommand = myDataBase.GetStoredProcCommand(DBConstant.UPDATE_STATE); dbcommand.CommandType = CommandType.StoredProcedure; myDataBase.AddInParameter(dbcommand, "@in_stateId", DbType.Int32, Id); myDataBase.AddInParameter(dbcommand, "@in_countryId ", DbType.Int32, locationmasterUpdate.CountryId); myDataBase.AddInParameter(dbcommand, "@in_state", DbType.String, locationmasterUpdate.stateName); myDataBase.ExecuteNonQuery(dbcommand); }
public IHttpActionResult UpdateLocation(LocationMaster locationMaster) { var isupdate = _locationRepository.UpdateLocation(locationMaster); if (isupdate == true) { return(Ok(isupdate)); } return(BadRequest()); }
public void InsertState(LocationMaster location) { DbCommand dbCommand = myDataBase.GetStoredProcCommand(DBConstant.CREATE_STATE); myDataBase.AddInParameter(dbCommand, "@in_State", DbType.String, location.stateName); myDataBase.AddInParameter(dbCommand, "@in_CountryId", DbType.Int32, location.CountryId); myDataBase.AddInParameter(dbCommand, "@in_CreatedBy", DbType.String, location.Created_By); myDataBase.AddInParameter(dbCommand, "@in_CreatedDate", DbType.DateTime, location.Created_Date); myDataBase.ExecuteNonQuery(dbCommand); }
// // GET: /LocationMaster/Details/5 public ActionResult Details(int id = 0) { LocationMaster locationmaster = db.LocationMasters.Find(id); if (locationmaster == null) { return(HttpNotFound()); } return(View(locationmaster)); }
public IActionResult Put([FromBody] LocationMaster req) { bool result = _repo.Update(req); if (result) { return(Ok("Success")); } return(Ok("Fail")); }
public IHttpActionResult DeleteLocation(int id) { LocationMaster master = objEntity.LocationMasters.Find(id); if (master == null) { return(NotFound()); } objEntity.LocationMasters.Remove(master); objEntity.SaveChanges(); return(Ok(master)); }
public void InsertLocation(LocationMaster location) { DbCommand dbCommand = myDataBase.GetStoredProcCommand(DBConstant.CREATE_LOCATION); myDataBase.AddInParameter(dbCommand, "@in_CityId", DbType.String, location.CityId); myDataBase.AddInParameter(dbCommand, "@in_companyName", DbType.String, location.CompanyName); myDataBase.AddInParameter(dbCommand, "@in_LocationTitle", DbType.String, location.LocationTitle); myDataBase.AddInParameter(dbCommand, "@in_City", DbType.String, location.City); myDataBase.AddInParameter(dbCommand, "@in_LocationAddress", DbType.String, location.LocationAddress); myDataBase.AddInParameter(dbCommand, "@in_CreatedBy", DbType.String, location.Created_By); myDataBase.ExecuteNonQuery(dbCommand); }
public void UpdateCountry(int Id, LocationMaster locationmasterUpdate) { DbCommand dbcommand = myDataBase.GetStoredProcCommand(DBConstant.UPDATE_COUNTRY); dbcommand.CommandType = CommandType.StoredProcedure; myDataBase.AddInParameter(dbcommand, "@in_LocationId", DbType.Int32, Id); myDataBase.AddInParameter(dbcommand, "@in_LocationTitle", DbType.String, locationmasterUpdate.LocationTitle); myDataBase.AddInParameter(dbcommand, "@in_Country ", DbType.String, locationmasterUpdate.Country); myDataBase.AddInParameter(dbcommand, "@in_ModifiedBy", DbType.String, locationmasterUpdate.Modified_By); myDataBase.AddInParameter(dbcommand, "@in_ModifiedDate", DbType.DateTime, locationmasterUpdate.Modified_Date); myDataBase.ExecuteNonQuery(dbcommand); }
public long SaveOrUpdateLocationMasterDetails(LocationMaster lm) { try { mbc.SaveOrUpdateLocationMasterDetails(lm); return(lm.Id); } catch (Exception ex) { throw ex; } finally { } }
protected void BtnAdd_Click(object sender, EventArgs e) { LocationMaster locationDOM = new LocationMaster(); locationDOM.LocationTitle = txtDescription.Text; locationDOM.Country = txtCountryName.Text; locationDOM.Created_By = basePage.LoggedInUser.LoginId; locationDOM.Created_Date = DateTime.Now; locationBusinessAccess.insertCountry(locationDOM); Response.Write("<Script Language=javascript>alert('Country Saved Successfully.');</Script>"); Bindgried(null); Clear(); }
protected void BtnAdd_Click(object sender, EventArgs e) { LocationMaster locationDOM = new LocationMaster(); locationDOM.CountryId = Convert.ToInt32(ddlCountry.SelectedValue); locationDOM.stateName = txtState.Text; locationDOM.Created_By = basePage.LoggedInUser.LoginId; locationDOM.Created_Date = DateTime.Now; locationBusinessAccess.insertState(locationDOM); Response.Write("<Script Language=javascript>alert('State Saved Successfully.');</Script>"); Bindgried(null); Clear(); }
protected void BtnAdd_Click(object sender, EventArgs e) { LocationMaster locationDOM = new LocationMaster(); locationDOM.CompanyId = Convert.ToInt32(ddlCompany.SelectedItem.Value); locationDOM.LocationTitle = txtlocation.Text; locationDOM.City = txtcity.Text; locationDOM.LocationAddress = txtlocationaddress.Text; locationDOM.CreatedBy = "ADMIN"; locationBusinessAccess.insertLocation(locationDOM); Bindgried(null); Empty(); }
public bool UpdateLocation(LocationMaster locationMaster) { DateTime now = DateTime.Now; locationMaster.ModifiedDate = now; int rowsAffected = this._db.Execute("UPDATE LocationMaster SET Name = @Name ,Description = @Description,ModifiedBy=1, ModifiedDate = @ModifiedDate WHERE Id = " + locationMaster.Id, locationMaster); if (rowsAffected > 0) { return(true); } return(false); }
public void Update(int Id, LocationMaster locationmasterUpdate) { DbCommand dbcommand = myDataBase.GetStoredProcCommand(DBConstant.UPDATE_LOCATION); dbcommand.CommandType = CommandType.StoredProcedure; myDataBase.AddInParameter(dbcommand, "@in_LocationId", DbType.Int32, Id); myDataBase.AddInParameter(dbcommand, "@in_CityId", DbType.Int32, locationmasterUpdate.CityId); myDataBase.AddInParameter(dbcommand, "@in_CompanyName", DbType.String, locationmasterUpdate.CompanyName); myDataBase.AddInParameter(dbcommand, "@in_LocationTitle", DbType.String, locationmasterUpdate.LocationTitle); myDataBase.AddInParameter(dbcommand, "@in_City ", DbType.String, locationmasterUpdate.City); myDataBase.AddInParameter(dbcommand, "@in_LocationAddress", DbType.String, locationmasterUpdate.LocationAddress); myDataBase.AddInParameter(dbcommand, "@in_ModifiedBy", DbType.String, locationmasterUpdate.Modified_By); myDataBase.AddInParameter(dbcommand, "@in_ModifieDate", DbType.DateTime, locationmasterUpdate.Modified_Date); myDataBase.ExecuteNonQuery(dbcommand); }