public PincodeMaster GetData(long ID) { //Used for finding Pincode by Id PincodeMaster model = new PincodeMaster(); Country C = new Country(); State S = new State(); City CT = new City(); if (ID != 0) { try { model = _context.PincodeMaster.AsNoTracking().Where(e => (e.ID) == ID).FirstOrDefault(); C = _context.Country.AsNoTracking().Where(e => (e.Id) == model.CountryId).FirstOrDefault(); S = _context.State.AsNoTracking().Where(e => (e.Id) == model.StateId).FirstOrDefault(); CT = _context.City.AsNoTracking().Where(e => (e.Id) == model.CityId).FirstOrDefault(); model.CountryName = C.CountryName; model.StateName = S.StateName; model.CityName = CT.CityName; return(model); } catch { return(null); } } else { return(null); } }
public JsonResponse AddUpdate(PincodeMaster model) { //Used for inserting and updating state //Stored Procedure Used for insert Admin_InsertPincode //Stored Procedure Used for update Admin_UpdatePincode // Createdby and Modifiedby parameters are hardcoded as of now if (model.ID == 0) { if (!IsExsits(model.PinCode, model.ID)) { try { SqlParameter[] ObjParams = new SqlParameter[] { new SqlParameter("@id ", model.ID), new SqlParameter("@Pincode", model.PinCode), new SqlParameter("@CityId", model.CityId), new SqlParameter("@StateId", model.StateId), new SqlParameter("@CountryId", model.CountryId), new SqlParameter("@IsActive", model.IsActive), new SqlParameter("@CreatedBy", GetUserID()) }; new ADODataFunction().ExecuteNonQuery(Constants.Procedures.InsertPincode, ObjParams, CommandType.StoredProcedure); ObjParams = null; resp.Status = "S"; resp.Message = "Data inserted successfully"; } catch (Exception ex) { resp.Status = "F"; resp.Message = "Data not insert"; throw ex; } } else { resp.Status = "F"; resp.Message = "This data already exsits"; } } else { resp.Message = "Data updated failed"; try { SqlParameter[] ObjParams = new SqlParameter[] { new SqlParameter("@id ", model.ID), new SqlParameter("@Pincode", model.PinCode), new SqlParameter("@CityId", model.CityId), new SqlParameter("@StateId", model.StateId), new SqlParameter("@CountryId", model.CountryId), new SqlParameter("@IsActive", model.IsActive), new SqlParameter("@ModifiedBy", GetUserID()) }; new ADODataFunction().ExecuteNonQuery(Constants.Procedures.UpdatePincode, ObjParams, CommandType.StoredProcedure); ObjParams = null; resp.Status = "S"; resp.Message = "Data updated Successfully"; } catch (Exception ex) { resp.Status = "F"; resp.Message = "Data not Updated"; throw ex; } } return(resp); }