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