public void Delete(XpayModel xpayModel) { XpayModel XpayModel = new XpayModel(); XpayModel.id = xpayModel.id; conn.Open(); SqlCommand cm = new SqlCommand("DeleteData", conn); cm.Parameters.AddWithValue("@id", XpayModel.id); cm.CommandType = CommandType.StoredProcedure; cm.ExecuteNonQuery(); conn.Close(); }
public void Create(XpayModel xpayModel) { SqlCommand cm = new SqlCommand("InsertData", conn); cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("@name", xpayModel.Name); cm.Parameters.AddWithValue("@description", xpayModel.Description); cm.Parameters.AddWithValue("@amount", xpayModel.amount); cm.Parameters.AddWithValue("@termAndCondition", xpayModel.TermAndCondition); conn.Open(); cm.ExecuteNonQuery(); conn.Close(); }