コード例 #1
0
 /// <summary>
 /// Add new a row
 /// </summary>
 /// <param name="entity"></param>
 /// <returns></returns>
 public int Dealer_Insert(Dealer entity)
 {
     return dealer.Dealer_Insert(entity);
 }
コード例 #2
0
 /// <summary>
 /// Update a row
 /// </summary>
 /// <param name="entity"></param>
 /// <returns></returns>
 public int Dealer_Update(Dealer entity)
 {
     return dealer.Dealer_Update(entity);
 }
コード例 #3
0
        /// <summary>
        /// Add new a row
        /// </summary>
        /// <param name="entity"></param>
        /// <returns></returns>
        public int Dealer_Insert(Dealer entity)
        {
            using (SqlConnection conn = new SqlConnection(AppConfiguration.ConnectionString))
            {
                SqlCommand command = new SqlCommand("Dealer_Insert", conn);
                command.CommandType = CommandType.StoredProcedure;
                try
                {
                    command.Parameters.Add(new SqlParameter("@Company_Id", SqlDbType.UniqueIdentifier));
                    command.Parameters["@Company_Id"].Value = entity.Company_Id;
                    command.Parameters.Add(new SqlParameter("@Dealer_Name", SqlDbType.NVarChar));
                    command.Parameters["@Dealer_Name"].Value = entity.Dealer_Name;
                    command.Parameters.Add(new SqlParameter("@Dealer_Address", SqlDbType.NVarChar));
                    command.Parameters["@Dealer_Address"].Value = entity.Dealer_Address;
                    command.Parameters.Add(new SqlParameter("@Dealer_Phone", SqlDbType.NVarChar));
                    command.Parameters["@Dealer_Phone"].Value = entity.Dealer_Phone;
                    command.Parameters.Add(new SqlParameter("@Dealer_Email", SqlDbType.NVarChar));
                    command.Parameters["@Dealer_Email"].Value = entity.Dealer_Email;

                    conn.Open();

                    return command.ExecuteNonQuery();
                }
                catch
                {

                    throw;
                }
                finally
                {
                    command.Dispose();
                }

            }
        }