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