/// <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);
}
