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