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); }
public void Insert_Customer_Contact_Type(CustomerContactTypeInfo CustomerContactType) { _customerRepo.Insert_Customer_Contact_Type(CustomerContactType); }