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);
    }
Example #3
0
        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);
        }
Example #4
0
 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);
     }
 }
Example #5
0
        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 }));
            }
        }
Example #6
0
        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);
        }
Example #7
0
        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);
            }
        }
Example #9
0
        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));
        }
Example #11
0
        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 }));
            }
        }
Example #12
0
    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"));
        }
Example #14
0
        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);
        }
Example #15
0
        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);
        }
Example #16
0
        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);
        }
Example #17
0
        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);
        }
Example #18
0
        public IHttpActionResult UpdateLocation(LocationMaster locationMaster)
        {
            var isupdate = _locationRepository.UpdateLocation(locationMaster);

            if (isupdate == true)
            {
                return(Ok(isupdate));
            }
            return(BadRequest());
        }
Example #19
0
        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));
        }
Example #23
0
        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);
        }
Example #24
0
        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 { }
 }
Example #26
0
        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();
        }
Example #27
0
        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();
        }
Example #28
0
        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();
        }
Example #29
0
        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);
        }
Example #30
0
        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);
        }