/// <summary> /// Grabs the parameter information from the CMS Control Settings /// </summary> /// <param name="param"></param> public void SetParamInfo(object param) { try { ControlSettings settings = (ControlSettings)param; if (settings != null && settings.Params != null) { if (settings.Params["Depository"] != null) { this.Depository = (Depository)Enum.Parse(typeof(Depository), settings.Params["Depository"].ToString()); } } this.DataBind(); } catch { } }
public JsonResponse AddUpdate(Depository model) { //Used for inserting and updating state //Stored Procedure Used for insert Admin_InsertDepository //Stored Procedure Used for update Admin_UpdateDepository // Createdby and Modifiedby parameters are hardcoded as of now if (model.Id == 0) { if (!IsExsits(model.DPCode, model.Id)) { try { SqlParameter[] ObjParams = new SqlParameter[] { new SqlParameter("@id ", model.Id), new SqlParameter("@DPCode", model.DPCode), new SqlParameter("@DPName", model.DPName), new SqlParameter("@AddressLine1", model.AddressLine1), new SqlParameter("@AddressLine2", model.AddressLine2), new SqlParameter("@Pincode", model.Pincode), new SqlParameter("@City", model.CityId), new SqlParameter("@StateId", model.StateId), new SqlParameter("@CountryId", model.CountryId), new SqlParameter("@Longitude", model.Longitude), new SqlParameter("@Latitude", model.Latitude), new SqlParameter("@IsActive", model.IsActive), new SqlParameter("@User", GetUserID()) }; new ADODataFunction().ExecuteNonQuery("Admin_InsertDepository", 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("@DPCode", model.DPCode), new SqlParameter("@DPName", model.DPName), new SqlParameter("@AddressLine1", model.AddressLine1), new SqlParameter("@AddressLine2", model.AddressLine2), new SqlParameter("@Pincode", model.Pincode), new SqlParameter("@City", model.CityId), new SqlParameter("@StateId", model.StateId), new SqlParameter("@CountryId", model.CountryId), new SqlParameter("@Longitude", model.Longitude), new SqlParameter("@Latitude", model.Latitude), new SqlParameter("@IsActive", model.IsActive), new SqlParameter("@User", GetUserID()) }; new ADODataFunction().ExecuteNonQuery("Admin_UpdateDepository", 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); }