public long InsertPropertyWorkingDays(PropertyWorkingDays workingDays) { long id = 0; using (SqlConnection connection = new SqlConnection(CommonUtility.ConnectionString)) { SqlCommand command = new SqlCommand(StoreProcedure.INSERT_PROPERTY_WORKING_DAYS, connection); command.CommandType = CommandType.StoredProcedure; SqlParameter returnValue = new SqlParameter("@" + "Id", SqlDbType.Int); returnValue.Direction = ParameterDirection.Output; command.Parameters.Add(returnValue); foreach (var propertys in workingDays.GetType().GetProperties()) { if (propertys.Name != "Id") { string name = propertys.Name; var value = propertys.GetValue(workingDays, null); command.Parameters.Add(new SqlParameter("@" + name, value == null ? DBNull.Value : value)); } } try { connection.Open(); command.ExecuteNonQuery(); id = (int)command.Parameters["@Id"].Value; } catch (Exception ex) { throw new Exception("Execption Adding Data. " + ex.Message); } finally { connection.Close(); } } return(id); }
public void _WorkDays(long propertyId, AdminVWModel adminVwModel, PropertyWorkingDays workDays) { adminVwModel.WorkingDays.PropertyId = propertyId; var serviceId = PropertyWorkingDaysManager.InsertPropertyWorkingDays(adminVwModel.WorkingDays); }