public void SavePanicData(PanicEntity panicEntity)
{
try
{
paramList.Clear();
paramList["@ProfileID"] = panicEntity.ProfileID;
paramList["@name"] = panicEntity.name;
paramList["@phone"] = panicEntity.phone;
paramList["@email"] = panicEntity.email;
paramList["@text"] = panicEntity.text;
spName = "spEM_SavePanic";
db.ExecuteNonQuery(spName, true, Common.Enums.SQLConnectionNames.EMDB, paramList);
}
catch
{
throw;
}
}
public PanicEntity GetPanicData(int profileID)
{
DataTable dt = new DataTable();
PanicEntity entity = new PanicEntity();
try
{
paramList.Clear();
paramList["@ProfileID"] = profileID;
spName = "spEM_GetPanicDetails";
dt.Load(db.ExecuteQuery(spName, true, Common.Enums.SQLConnectionNames.EMDB, paramList));
entity = Utility.ConvertFromDataTable <PanicEntity>(dt).FirstOrDefault();
}
catch
{
throw;
}
return(entity);
}
