public int SaveIncomingCourierMaster(IncomingCourierMasterVMSave incomingCourierMasterVM)
{
SqlParameter parameter;
int courierMasterId = -1;
try
{
using (SqlConnection connection = new SqlConnection(TradeDBConnectionString))
{
connection.Open();
SqlCommand cmd = new SqlCommand("SaveIncomingCourierMaster", connection);
cmd.CommandType = CommandType.StoredProcedure;
foreach (var property in incomingCourierMasterVM.GetType().GetProperties())
{
parameter = new SqlParameter();
parameter.ParameterName = "@" + property.Name;
switch (Type.GetTypeCode(property.PropertyType))
{
case TypeCode.Int32:
parameter.SqlDbType = SqlDbType.Int;
break;
case TypeCode.String:
parameter.SqlDbType = SqlDbType.NVarChar;
break;
case TypeCode.DateTime:
parameter.SqlDbType = SqlDbType.DateTime;
break;
default:
parameter.SqlDbType = SqlDbType.UniqueIdentifier;
break;
}
parameter.Value = property.GetValue(incomingCourierMasterVM, null);
cmd.Parameters.Add(parameter);
}
courierMasterId = (int)cmd.ExecuteScalar();
connection.Close();
}
}
catch (Exception ex)
{
_tradeLogger.Error("Trading.DAL.Trade.LoadSheet", ex);
throw ex;
}
return(courierMasterId);
}
public ActionResult AddNewCourierMaster(IncomingCourierMasterVMSave courierMaster)
{
Guid companyId = Guid.NewGuid();
courierMaster.CompanyID = companyId;
courierMaster.CreationDate = courierMaster.UpdatedDate = DateTime.Now;
courierMaster.CreatedBy = courierMaster.UpdatedBy = 999;
Trading.BLL.Trade trade = new BLL.Trade();
trade.TradeDBConnectionString = ConfigurationManager.ConnectionStrings["TradeConnectionString"].ConnectionString;
int masterId = trade.SaveIncomingCourierMaster(courierMaster);
courierMaster.MasterID = masterId;
return(Json(courierMaster));
}
public int SaveIncomingCourierMaster(IncomingCourierMasterVMSave incomingCourierMasterVM)
{
DAL.Trade trade = new DAL.Trade();
trade.TradeDBConnectionString = this.TradeDBConnectionString;
return(trade.SaveIncomingCourierMaster(incomingCourierMasterVM));
}