// POST api/mailsummary
public string Post([FromBody] BOMailSummary employeeMailDetails)
{
try
{
//TODO : Need to verify Insert
int ret = BLLMailSummary.Save(employeeMailDetails);
return(ret > 0 ? "Mail save successfully" : "There is a problem while saving record");
}
catch (Exception ex)
{
return(ex.Message);
}
}
public static BOMailSummary GetItem(Int32 id)
{
BOMailSummary itemObj = null;
tblMailSummary tblObj = new tblMailSummary();
DataTable dt = tblObj.GetAllData(tblMailSummary.PRIMARYKEY_FIELD1 + " = " + id);
if (dt.Rows.Count > 1)
{
throw new Exception("More than one row returned");
}
if (dt.Rows.Count == 1)
{
itemObj = FillDataRecord(dt.Rows[0]);
}
return(itemObj);
}
private static BOMailSummary FillDataRecord(DataRow dr)
{
BOMailSummary itemObj = new BOMailSummary();
if (dr["MailID"] != DBNull.Value)
{
itemObj.MailID = Int32.Parse(dr["MailID"].ToString());
}
if (dr["ToEmployeeID"] != DBNull.Value)
{
itemObj.ToEmployeeID = Int32.Parse(dr["ToEmployeeID"].ToString());
}
if (dr["CCEmployeeID"] != DBNull.Value)
{
itemObj.CCEmployeeID = Int32.Parse(dr["CCEmployeeID"].ToString());
}
if (dr["FromEmployeeID"] != DBNull.Value)
{
itemObj.FromEmployeeID = Int32.Parse(dr["FromEmployeeID"].ToString());
}
if (dr["MessageBody"] != DBNull.Value)
{
itemObj.MessageBody = dr["MessageBody"].ToString();
}
if (dr["MailSubject"] != DBNull.Value)
{
itemObj.MailSubject = dr["MailSubject"].ToString();
}
if (dr["CreatedOn"] != DBNull.Value)
{
itemObj.CreatedOn = DateTime.Parse(dr["CreatedOn"].ToString());
}
if (dr["CreatedByID"] != DBNull.Value)
{
itemObj.CreatedByID = Int32.Parse(dr["CreatedByID"].ToString());
}
if (dr["ModifiedOn"] != DBNull.Value)
{
itemObj.ModifiedOn = DateTime.Parse(dr["ModifiedOn"].ToString());
}
if (dr["ModifiedByID"] != DBNull.Value)
{
itemObj.ModifiedByID = Int32.Parse(dr["ModifiedByID"].ToString());
}
return(itemObj);
}
public static int Save(BOMailSummary entry, bool adding)
{
tblMailSummary tblObj = new tblMailSummary();
DataRow newRow = tblObj.Table().NewRow();
newRow[tblMailSummary.MAILID_FIELD] = entry.MailID;
newRow[tblMailSummary.TOEMPLOYEEID_FIELD] = entry.ToEmployeeID;
newRow[tblMailSummary.CCEMPLOYEEID_FIELD] = entry.CCEmployeeID;
newRow[tblMailSummary.FROMEMPLOYEEID_FIELD] = entry.FromEmployeeID;
newRow[tblMailSummary.MESSAGEBODY_FIELD] = entry.MessageBody;
newRow[tblMailSummary.MAILSUBJECT_FIELD] = entry.MailSubject;
if (entry.CreatedOn.Equals(new DateTime()))
{
newRow[tblMailSummary.CREATEDON_FIELD] = DBNull.Value;
}
else
{
newRow[tblMailSummary.CREATEDON_FIELD] = entry.CreatedOn;
}
newRow[tblMailSummary.CREATEDBYID_FIELD] = entry.CreatedByID;
if (entry.ModifiedOn.Equals(new DateTime()))
{
newRow[tblMailSummary.MODIFIEDON_FIELD] = DBNull.Value;
}
else
{
newRow[tblMailSummary.MODIFIEDON_FIELD] = entry.ModifiedOn;
}
newRow[tblMailSummary.MODIFIEDBYID_FIELD] = entry.ModifiedByID;
if (adding)
{
return(tblObj.AddToTable(newRow));
}
else
{
return(tblObj.UpdateTable(newRow));
}
}
public static int Update(BOMailSummary entry)
{
return(tblMailSummaryDBManager.Save(entry, false));
}
public static int Save(BOMailSummary entry)
{
return(tblMailSummaryDBManager.Save(entry, true));
}
public static int Save(BOMailSummary entry, bool adding)
{
return(tblMailSummaryDBManager.Save(entry, adding));
}
