public int Create_Customers_ClassName(MPanelDTO MClass) { SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = "[Adobe].[SP_Insert_Customers_ClassName]"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@CustomerId", MClass.Customers_ClassName_CustomerId); cmd.Parameters.AddWithValue("@Name", MClass.Customers_ClassName_Name); cmd.Parameters.AddWithValue("@NameLatin", MClass.Customers_ClassName_NameLatin); cmd.Parameters.AddWithValue("@UserCount", MClass.Customers_ClassName_UserCount); cmd.Parameters.AddWithValue("@SessionCount", MClass.Customers_ClassName_SessionCount); cmd.Parameters.AddWithValue("@DateStart", MClass.Customers_ClassName_DateStart); cmd.Parameters.AddWithValue("@DateEnd", MClass.Customers_ClassName_DateEnd); cmd.Parameters.AddWithValue("@ScoId", MClass.Customers_ClassName_ScoId); cmd.Parameters.AddWithValue("@ServerName", MClass.Customers_ClassName_ServerName); cmd.Parameters.AddWithValue("@MeetingAccess", MClass.Customers_ClassName_MeetingAccess); if (conn.State != System.Data.ConnectionState.Open) { conn.Open(); } int modified = (int)cmd.ExecuteScalar(); if (conn.State == System.Data.ConnectionState.Open) { conn.Close(); } cmd.Connection.Close(); cmd.Dispose(); return(modified); }
public int Create_Customers_ClassName(MPanelDTO MClass) { return(MpDAO.Create_Customers_ClassName(MClass)); }