public int Add(Mail.Model.T_Base_Mail item)
{
SqlConnection co = new SqlConnection();
co.ConnectionString = connstring;
co.Open();
SqlCommand cm = new SqlCommand();
cm.Connection = co;
cm.CommandText = "Insert into T_Base_Mail(enteringTime,isReturn,isReceived,typeId,RecipientId) values (@enteringTime,@isReturn,@isReceived,@typeId,@RecipientId)";
cm.Parameters.AddWithValue("@enteringTime", item.EnteringTime);
cm.Parameters.AddWithValue("@isReturn", item.IsReturn);
cm.Parameters.AddWithValue("@isReceived", item.IsRecieved);
cm.Parameters.AddWithValue("@typeId", item.TypeId);
cm.Parameters.AddWithValue("@RecipientId", item.RecipientId);
int result = cm.ExecuteNonQuery();
co.Close();
return(result);
}
public int Update(Mail.Model.T_Base_Mail item)
{
SqlConnection co = new SqlConnection();
co.ConnectionString = connstring;
co.Open();
SqlCommand cm = new SqlCommand();
cm.Connection = co;
cm.CommandText = "update T_Base_Mail set enteringTime=@enteringTime,isReturn=@isReturn,isReceived@isReceived,@typeId,@RecipientId where Id=@Id";
cm.Parameters.AddWithValue("@enteringTime", item.EnteringTime);
cm.Parameters.AddWithValue("@isReturn", item.IsReturn);
cm.Parameters.AddWithValue("@isReceived", item.IsRecieved);
cm.Parameters.AddWithValue("@typeId", item.TypeId);
cm.Parameters.AddWithValue("@RecipientId", item.RecipientId);
cm.Parameters.AddWithValue("@Id", item.Id);
int result = cm.ExecuteNonQuery();
co.Close();
return(result);
}
