private List <SqlParameter> Set_Values_In_Customer_Contact_Type(CustomerContactTypeInfo CustomerContactType)
        {
            List <SqlParameter> sqlParams = new List <SqlParameter>();

            sqlParams.Add(new SqlParameter("@Customer_Id", CustomerContactType.Customer_Id));
            sqlParams.Add(new SqlParameter("@Contact_Type", CustomerContactType.Contact_Type));
            sqlParams.Add(new SqlParameter("@CreatedOn", CustomerContactType.CreatedOn));
            sqlParams.Add(new SqlParameter("@CreatedBy", CustomerContactType.CreatedBy));
            return(sqlParams);
        }
        private CustomerContactTypeInfo Get_Customer_Contact_Type_Values(DataRow dr)
        {
            CustomerContactTypeInfo customerContactType = new CustomerContactTypeInfo();

            customerContactType.Customer_Contact_Type_Id = Convert.ToInt32(dr["Customer_Contact_Type_Id"]);
            customerContactType.Customer_Id  = Convert.ToInt32(dr["Customer_Id"]);
            customerContactType.Contact_Type = Convert.ToString(dr["Contact_Type"]);
            customerContactType.CreatedOn    = Convert.ToDateTime(dr["CreatedOn"]);
            customerContactType.CreatedBy    = Convert.ToInt32(dr["CreatedBy"]);
            return(customerContactType);
        }
 public void Insert_Customer_Contact_Type(CustomerContactTypeInfo CustomerContactType)
 {
     _sqlRepo.ExecuteNonQuery(Set_Values_In_Customer_Contact_Type(CustomerContactType), StoredProcedures.Insert_Customer_Contact_Type_Sp.ToString(), CommandType.StoredProcedure);
 }
Exemple #4
0
 public void Insert_Customer_Contact_Type(CustomerContactTypeInfo CustomerContactType)
 {
     _customerRepo.Insert_Customer_Contact_Type(CustomerContactType);
 }