public List <dynamic> AddUpdateCustomerSetting(CustomerSettings customerSettings)
{
List <dynamic> objDynamic = new List <dynamic>();
CustomerOrderSetting customerOrderSetting = new CustomerOrderSetting();
customerOrderSetting.CustId = customerSettings.CustomerId;
customerOrderSetting.ReferenceNoAuto = customerSettings.Reference;
customerOrderSetting.Addresses = customerSettings.Addresses;
customerOrderSetting.UseItemGroups = customerSettings.UserItem;
customerOrderSetting.UseItemGroupSeparatedFreight = customerSettings.UserItemSp;
customerOrderSetting.RequestNewProducts = customerSettings.RequestNew;
switch (customerSettings.Approver)
{
case 0:
{
customerOrderSetting.Approver = 0;
customerOrderSetting.LevelofAuthority = 0;
break;
}
case 1:
{
customerOrderSetting.Approver = 1;
customerOrderSetting.LevelofAuthority = 1;
break;
}
case 2:
{
customerOrderSetting.Approver = customerSettings.No_Approver;
customerOrderSetting.LevelofAuthority = customerSettings.No_Approver - 1;
break;
}
}
customerOrderSetting.Type = 1;
customerOrderSetting = AddUpdateCustomerOrderSetting(customerOrderSetting);
objDynamic.Add(customerOrderSetting.COSId);
return(objDynamic);
}
private int UpdateCustomerOrderSetting(CustomerOrderSetting customerOrderSettingDTO)
{
SqlConnection connection = plansoni_webstoreData.GetConnection();
Log log = new Log();
string updateProcedure = "[UpdateCustomerOrderSetting]";
SqlCommand updateCommand = new SqlCommand(updateProcedure, connection);
updateCommand.CommandType = CommandType.StoredProcedure;
int COSId = 0;
if (customerOrderSettingDTO.COSId != 0)
{
updateCommand.Parameters.AddWithValue("@COSId", customerOrderSettingDTO.COSId);
}
else
{
updateCommand.Parameters.AddWithValue("@COSId", 0);
}
if (customerOrderSettingDTO.CustId != 0)
{
updateCommand.Parameters.AddWithValue("@CustId", customerOrderSettingDTO.CustId);
}
else
{
updateCommand.Parameters.AddWithValue("@CustId", 0);
}
if (customerOrderSettingDTO.ReferenceNoAuto)
{
updateCommand.Parameters.AddWithValue("@ReferenceNoAuto ", customerOrderSettingDTO.ReferenceNoAuto);
}
else
{
updateCommand.Parameters.AddWithValue("@ReferenceNoAuto", 0);
}
if (customerOrderSettingDTO.UseItemGroups)
{
updateCommand.Parameters.AddWithValue("@UseItemGroups", customerOrderSettingDTO.UseItemGroups);
}
else
{
updateCommand.Parameters.AddWithValue("@UseItemGroups ", 0);
}
if (customerOrderSettingDTO.UseItemGroupSeparatedFreight)
{
updateCommand.Parameters.AddWithValue("@UseItemGroupSeparatedFreight ", customerOrderSettingDTO.UseItemGroupSeparatedFreight);
}
else
{
updateCommand.Parameters.AddWithValue("@UseItemGroupSeparatedFreight ", 0);
}
if (customerOrderSettingDTO.RequestNewProducts)
{
updateCommand.Parameters.AddWithValue("@RequestNewProducts ", customerOrderSettingDTO.RequestNewProducts);
}
else
{
updateCommand.Parameters.AddWithValue("@RequestNewProducts ", 0);
}
if (customerOrderSettingDTO.Desgination)
{
updateCommand.Parameters.AddWithValue("@Desgination ", customerOrderSettingDTO.Desgination);
}
else
{
updateCommand.Parameters.AddWithValue("@Desgination ", 0);
}
if (customerOrderSettingDTO.Addresses != 0)
{
updateCommand.Parameters.AddWithValue("@Addresses ", customerOrderSettingDTO.Addresses);
}
else
{
updateCommand.Parameters.AddWithValue("@Addresses ", 0);
}
if (customerOrderSettingDTO.Approver != 0)
{
updateCommand.Parameters.AddWithValue("@Approver ", customerOrderSettingDTO.Approver);
}
else
{
updateCommand.Parameters.AddWithValue("@Approver ", 0);
}
if (customerOrderSettingDTO.LevelofAuthority != 0)
{
updateCommand.Parameters.AddWithValue("@LevelofAuthority ", customerOrderSettingDTO.LevelofAuthority);
}
else
{
updateCommand.Parameters.AddWithValue("@LevelofAuthority ", 0);
}
updateCommand.Parameters.Add("@ReturnValue", System.Data.SqlDbType.Int);
updateCommand.Parameters["@ReturnValue"].Direction = ParameterDirection.Output;
try
{
int count = 0;
connection.Open();
updateCommand.ExecuteNonQuery();
if (updateCommand.Parameters["@ReturnValue"].Value != DBNull.Value)
{
count = System.Convert.ToInt32(updateCommand.Parameters["@ReturnValue"].Value);
}
return(COSId);
}
catch (Exception ex)
{
log.logErrorMessage("");
log.logErrorMessage(ex.StackTrace);
return(COSId);
}
finally
{
connection.Close();
}
}
