public int UpdateS02008(S02008ViewModel model)
{
int result;
try
{
EntityCommand cmd = new EntityCommand("EProcEntities.sp_UpdateS02008", entityConnection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("PONUMBER", DbType.String).Value = model.PONumber;
cmd.Parameters.Add("VERSIONPOSERA", DbType.Int32).Value = Convert.ToInt32(model.VersionPOSERA);
cmd.Parameters.Add("DATAVERSION", DbType.Int32).Value = Convert.ToInt32(model.DataVersion);
cmd.Parameters.Add("SALESORDERNO", DbType.String).Value = model.SalesOrderNo;
cmd.Parameters.Add("NOCHASIS_INPUT", DbType.String).Value = model.ChassisNumberByVendor;
cmd.Parameters.Add("TGLMASUKKAROSERI", DbType.DateTime).Value = model.DateEntryCarrosserieAccessories;
OpenConnection();
result = Convert.ToInt32(cmd.ExecuteScalar());
}
catch (Exception ex)
{
result = 0;
throw ex;
}
finally
{
CloseConnection();
}
return(result);
}
public int UpdateS02004(S02004ViewModel model)
{
int result;
try
{
EntityCommand cmd = new EntityCommand("EProcEntities.sp_UpdateS02004", entityConnection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("PONUMBER", DbType.String).Value = model.PONumber;
cmd.Parameters.Add("VERSIONPOSERA", DbType.Int32).Value = Convert.ToInt32(model.VersionPOSERA);
cmd.Parameters.Add("DATAVERSION", DbType.Int32).Value = Convert.ToInt32(model.DataVersion);
cmd.Parameters.Add("STATUS", DbType.DateTime).Value = model.Status;
cmd.Parameters.Add("REASONREJECTION", DbType.String).Value = model.ReasonRejection;
OpenConnection();
result = Convert.ToInt32(cmd.ExecuteScalar());
}
catch (Exception ex)
{
result = 0;
throw ex;
}
finally
{
CloseConnection();
}
return(result);
}
public object CustomerQuery(string Sqlstring)
{
//string con = "name = EntityFrameworkOracleContext";
using (EntityConnection econn = new EntityConnection(lbc.GetDataContext().MetadataWorkspace, lbc.GetDataContext().Connection))
{
econn.Open();
EntityCommand ecmd = new EntityCommand(Sqlstring, econn);
return(ecmd.ExecuteScalar());
}
}
private object QueryScalar(string connectionString, string commandString)
{
var connection = new EntityConnection(connectionString);
connection.Open();
var command = new EntityCommand(commandString, connection);
var result = command.ExecuteScalar();
connection.Close();
return(result);
}
public static T ExecuteScalarFunction <T>(this ObjectContext context, string functionImportName, EntityParameter[] parameters)
where T : struct
{
if (functionImportName == null)
{
throw new ArgumentNullException("functionName");
}
EntityCommand cmd = (EntityCommand)context.Connection.CreateCommand();
cmd.CommandText = context.DefaultContainerName + "." + functionImportName;
cmd.CommandType = CommandType.StoredProcedure;
if (context.CommandTimeout.HasValue)
{
cmd.CommandTimeout = context.CommandTimeout.Value;
}
if (parameters != null)
{
foreach (EntityParameter parameter in parameters)
{
cmd.Parameters.Add(parameter);
}
}
T ret = default(T);
context.EnsureConnection();
try
{
object o = cmd.ExecuteScalar();
ret = (T)Convert.ChangeType(o, typeof(T));
}
finally
{
context.ReleaseConnection();
}
return(ret);
}
public int UpdateS02006(S02006ViewModel model)
{
int result;
try
{
EntityCommand cmd = new EntityCommand("EProcEntities.sp_UpdateS02006", entityConnection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("PONUMBER", DbType.String).Value = model.PONumberSERA;
cmd.Parameters.Add("NOFAKTUR", DbType.String).Value = model.BillingNo; //mapping to CUSTOMPO.DONUMBER 01NOV2013
cmd.Parameters.Add("INVNO", DbType.String).Value = model.KuitansiNo;
cmd.Parameters.Add("INVDATE", DbType.DateTime).Value = model.KuitansiDate;
cmd.Parameters.Add("NOFAKTURPAJAK", DbType.String).Value = model.NomorFakturPajak;
cmd.Parameters.Add("NOCHASIS_INPUT", DbType.String).Value = model.ChasisNumber;
cmd.Parameters.Add("NETPRICE", DbType.Decimal).Value = model.AmountKuitansiDC;
//CUSTOM_VENDOR_TRANSACTION
cmd.Parameters.Add("BUSINESSAREACODE", DbType.String).Value = model.BusinessAreaCode;
cmd.Parameters.Add("CUSTOMERNO", DbType.String).Value = model.CustomerNo;
cmd.Parameters.Add("NOMORSPES", DbType.String).Value = model.NomorSpes;
cmd.Parameters.Add("SALESORDERNO", DbType.String).Value = model.SalesOrderNo;
cmd.Parameters.Add("SALESMANNUMBER", DbType.String).Value = model.SalesmanNumber;
cmd.Parameters.Add("VERSIONPOSERA", DbType.Int32).Value = Convert.ToInt32(model.VersionPOSERA);
cmd.Parameters.Add("KUITANSINOREF", DbType.String).Value = model.KuitansiNoRef;
cmd.Parameters.Add("KUITANSIDATEREF", DbType.String).Value = model.KuitansiDateRef;
cmd.Parameters.Add("DOWNLOADDATE", DbType.DateTime).Value = model.DownloadDate;
OpenConnection();
result = Convert.ToInt32(cmd.ExecuteScalar());
}
catch (Exception ex)
{
result = 0;
throw ex;
}
finally
{
CloseConnection();
}
return(result);
}
public string GetKodeCabangAI(string poNumber)
{
string result;
try
{
EntityCommand cmd = new EntityCommand("EProcEntities.sp_GetKodeCabangAI", entityConnection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("PONUMBER", DbType.String).Value = poNumber;
OpenConnection();
result = Convert.ToString(cmd.ExecuteScalar());
}
catch (Exception ex)
{
result = "";
throw ex;
}
finally
{
CloseConnection();
}
return(result);
}
public int UpdateCustomPOStatusPOId(string poNumber, string poStatusId)
{
int result;
try
{
EntityCommand cmd = new EntityCommand("EProcEntities.sp_UpdateCustomPOStatusPOId", entityConnection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("PONUMBER", DbType.String).Value = poNumber;
cmd.Parameters.Add("POSTATUSID", DbType.String).Value = poStatusId;
OpenConnection();
result = Convert.ToInt32(cmd.ExecuteScalar());
}
catch (Exception ex)
{
result = 0;
throw ex;
}
finally
{
CloseConnection();
}
return(result);
}
public int UpdateS02002HS(string poNumber, string HSorIS, S02002ViewModel model)
{
int result;
try
{
EntityCommand cmd = new EntityCommand("EProcEntities.sp_UpdateS02002_HS", entityConnection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("PONUMBER", DbType.String).Value = poNumber;
//CUSTOM_VENDOR_TRANSATION
cmd.Parameters.Add("VERSIONPOSERA", DbType.Int32).Value = Convert.ToInt32(model.VersionPOSERA);
cmd.Parameters.Add("DATAVERSION", DbType.Int32).Value = Convert.ToInt32(model.DataVersion);
cmd.Parameters.Add("STATUSPOSERA", DbType.String).Value = model.StatusPOSERA;
cmd.Parameters.Add("REJECTREVISEDPOSERA", DbType.String).Value = model.RejectRevisedPOSERA;
cmd.Parameters.Add("DOCUMENTNO", DbType.String).Value = model.DocumentNo;
cmd.Parameters.Add("AIMATERIALNUMBER", DbType.String).Value = model.AIMaterialNumber;
cmd.Parameters.Add("SERAMATERIALNUMBER", DbType.String).Value = model.SERAMaterialNumber;
cmd.Parameters.Add("SERAMATERIALDESCRIPTION", DbType.String).Value = model.SERAMaterialDescription;
cmd.Parameters.Add("AICOLOR", DbType.String).Value = model.AIColor;
cmd.Parameters.Add("SERACOLOR", DbType.String).Value = model.SERAColor;
cmd.Parameters.Add("QUOTATIONNO", DbType.String).Value = model.QuotationNo;
//cmd.Parameters.Add("HSORIS", DbType.String).Value = HSorIS;
OpenConnection();
result = Convert.ToInt32(cmd.ExecuteScalar());
}
catch (Exception ex)
{
result = 0;
throw ex;
}
finally
{
CloseConnection();
}
return(result);
}
public int UpdateS02002IS(string poNumber, string HSorIS, S02002ViewModel model)
{
int result;
try
{
EntityCommand cmd = new EntityCommand("EProcEntities.sp_UpdateS02002_IS", entityConnection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("PONUMBER", DbType.String).Value = poNumber;
cmd.Parameters.Add("HARGADPP_INPUT", DbType.Double).Value = model.DPPByVendor;
cmd.Parameters.Add("HARGAPPNUNIT_INPUT", DbType.Double).Value = model.PPNByVendor;
cmd.Parameters.Add("HARGABBN_INPUT", DbType.Double).Value = model.BBNPriceByVendor;
// cmd.Parameters.Add("CBUCKD", DbType.String).Value = model.CBUCKD;// tidak ada di table
cmd.Parameters.Add("DONUMBER", DbType.String).Value = model.FactureDONumber;
cmd.Parameters.Add("DODATE", DbType.DateTime).Value = model.FactureDODate;
cmd.Parameters.Add("ACTUALDATEDELIVEREDUNIT", DbType.DateTime).Value = model.ActualDateDeliveryUnit;
cmd.Parameters.Add("NOCHASIS_INPUT", DbType.String).Value = model.ChassisNumberByVendor;
cmd.Parameters.Add("NOENGINE_INPUT", DbType.String).Value = model.MachineNumberByVendor;
cmd.Parameters.Add("NOFAKTUR", DbType.String).Value = model.NoFakturKendaraan;
cmd.Parameters.Add("TGLFAKTUR", DbType.DateTime).Value = model.TanggalFakturKendaraan;
cmd.Parameters.Add("NOPOLISI_INPUT", DbType.String).Value = model.LicensePlateByVendor;
cmd.Parameters.Add("TGLSTNK_INPUT", DbType.DateTime).Value = model.STNKDateByVendor;
cmd.Parameters.Add("NOSERTIFIKAT", DbType.String).Value = model.NoSertifikat;
cmd.Parameters.Add("TGLSERTIFIKAT", DbType.DateTime).Value = model.TglSertifikat;
cmd.Parameters.Add("NOFORMULIRA", DbType.String).Value = model.NoFormulirA;
cmd.Parameters.Add("TGLFORMULIRA", DbType.DateTime).Value = model.TglFormulirA;
cmd.Parameters.Add("NOSERTIFIKATREGUJITIPE", DbType.String).Value = model.NoSertifikatRegUjiTipe;
cmd.Parameters.Add("DATEDELIVERYTOBRANCHORVENDOR", DbType.DateTime).Value = model.ActualDeliveryBPKBDate;
cmd.Parameters.Add("NOBPKB", DbType.String).Value = model.BPKBNumber;
cmd.Parameters.Add("KETBPKB", DbType.String).Value = model.RemarksBPKB;
cmd.Parameters.Add("REVISEDATE", DbType.DateTime).Value = model.RevisiBPKB;
////CUSTOM_VENDOR_TRANSATION
//cmd.Parameters.Add("VERSIONPOSERA", DbType.Int32).Value = model.VersionPOSERA;
//cmd.Parameters.Add("DATAVERSION", DbType.Int32).Value = model.DataVersion;
//cmd.Parameters.Add("STATUSPOSERA", DbType.String).Value = model.StatusPOSERA;
//cmd.Parameters.Add("REJECTREVISEDPOSERA", DbType.String).Value = model.RejectRevisedPOSERA;
//cmd.Parameters.Add("DOCUMENTNO", DbType.String).Value = model.DocumentNo;
//cmd.Parameters.Add("AIMATERIALNUMBER", DbType.String).Value = model.AIMaterialNumber;
//cmd.Parameters.Add("SERAMATERIALNUMBER", DbType.String).Value = model.SERAMaterialNumber;
//cmd.Parameters.Add("SERAMATERIALDESCRIPTION", DbType.String).Value = model.SERAMaterialDescription;
//cmd.Parameters.Add("AICOLOR", DbType.String).Value = model.AIColor;
//cmd.Parameters.Add("SERACOLOR", DbType.String).Value = model.SERAColor;
//cmd.Parameters.Add("QUOTATIONNO", DbType.String).Value = model.QuotationNo;
cmd.Parameters.Add("SALESORDERNO", DbType.String).Value = model.SalesOrderNo;
cmd.Parameters.Add("SALESORDERSTATUS", DbType.Boolean).Value = model.SalesOrderStatus;
cmd.Parameters.Add("CURRENCY", DbType.String).Value = model.Currency;
cmd.Parameters.Add("YEAR", DbType.Int32).Value = model.Year;
cmd.Parameters.Add("BILLINGSTATUS", DbType.Boolean).Value = model.BillingStatus;
cmd.Parameters.Add("BSTKBNO", DbType.String).Value = model.BSTKBNo;
cmd.Parameters.Add("REVISISTNK", DbType.DateTime).Value = model.RevisiSTNK;
cmd.Parameters.Add("NAMAPENERIMA", DbType.String).Value = model.NamaPenerima;
cmd.Parameters.Add("ALAMATPENERIMA", DbType.String).Value = model.AlamatPenerima;
//cmd.Parameters.Add("HSORIS", DbType.String).Value = HSorIS;
OpenConnection();
result = Convert.ToInt32(cmd.ExecuteScalar());
}
catch (Exception ex)
{
result = 0;
throw ex;
}
finally
{
CloseConnection();
}
return(result);
}