public SupplierAEForm(SupplierObject ob)
{
supplier = ob;
InitializeComponent();
this.bindingSource.DataSource = supplier;
this.cbx_class.DataSource = SupplierClassManager.SupplierClassList;
this.cbx_class.DisplayMember = "Name";
this.cbx_class.ValueMember = "Id";
this.cbx_class.SelectedValue = 0;
this.cbx_class.Text = string.Empty;
}
public ActionResult AddSupplier(SupplierObject supplier)
{
var gVal = new GenericValidator();
try
{
if (ModelState.IsValid)
{
var valStatus = ValidateSupplier(supplier);
if (valStatus.Code < 1)
{
gVal.Code = -1;
gVal.Error = valStatus.Error;
return(Json(gVal, JsonRequestBehavior.AllowGet));
}
supplier.DateJoined = DateTime.Now;
var k = new SupplierServices().AddSupplier(supplier);
if (k < 1)
{
gVal.Code = -1;
gVal.Error = k == -3 ? message_Feedback.Item_Duplicate : message_Feedback.Insertion_Failure;
return(Json(gVal, JsonRequestBehavior.AllowGet));
}
gVal.Code = 5;
return(Json(gVal, JsonRequestBehavior.AllowGet));
}
gVal.Code = -1;
gVal.Error = message_Feedback.Model_State_Error;
return(Json(gVal, JsonRequestBehavior.AllowGet));
}
catch
{
gVal.Code = -1;
gVal.Error = message_Feedback.Process_Failed;
return(Json(gVal, JsonRequestBehavior.AllowGet));
}
}
public bool UpdateSupplier(SupplierObject SupComp)
{
SqlParameter[] params_ = new SqlParameter[] {
new SqlParameter("@Id", SupComp.Id),
new SqlParameter("@Code", SupComp.Code),
new SqlParameter("@Name", SupComp.Name),
new SqlParameter("@Email", SupComp.Email),
new SqlParameter("@ContactNumber", SupComp.ContactNbr),
new SqlParameter("@UnitNumber", SupComp.UnitNbr),
new SqlParameter("@StreetName", SupComp.StreetName),
new SqlParameter("@Municipality", SupComp.Municipality),
new SqlParameter("@City", SupComp.City),
new SqlParameter("@Country", SupComp.Country),
new SqlParameter("@ZipCode", SupComp.Zip),
new SqlParameter("@DateCreated", SupComp.DateAdded),
new SqlParameter("@AddedBy", SupComp.AddedBy),
new SqlParameter("@ImpexRefNbr", SupComp.ImpexRefNbr),
new SqlParameter("@IP", Helpers.CustomHelper.GetLocalIPAddress()),
new SqlParameter("@MAC", Helpers.CustomHelper.GetMACAddress()),
};
return(Library.ConnectionString.returnCon.executeQuery("spUpdateSupplierCompany", params_, CommandType.StoredProcedure));
}
void IEditableObject.EndEdit()
{
try
{
if (_inTxn)
{
_loadedMaterialCategory = MaterialCategory;
_loadedMaterialType = MaterialType;
_loadedMaterialSubType = MaterialSubType;
_loadedEmployeeCreator = EmployeeCreator;
_loadedEmployeeResponsable = EmployeeResponsable;
_loadedVehicle = Vehicle;
_loadedSupplier = Supplier;
_loadedName = Name;
_loadedDescription = Description;
_loadedType = Type;
_loadedSerieNumber = SerieNumber;
_loadedInternalNumber = InternalNumber;
_loadedPurchasedOn = PurchasedOn;
_loadedPrice = Price;
_loadedNextMaintenance = NextMaintenance;
_loadedMaintenanceFrequency = MaintenanceFrequency;
_loadedActive = Active;
_loadedBroken = Broken;
//Child members
_loadedMemos = Memos;
_loadedMaintenances = Maintenances;
_inTxn = true;
}
}
catch (Exception exception1)
{
Exception innerException = exception1;
throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
}
}
public Dictionary <string, object> UploadTargets(string path_and_file)
{
try
{
//variable for logs
int success = 0;
int fail = 0;
int total = 0;
//get current workweek and year
//di ko sure kung kailangan to
//List<int> curr_ww = workweek_helper.GetCurrentWorkWeek();
//int current_workweek = curr_ww[0];
//int current_year = curr_ww[1];
response = new Dictionary <string, object>();
//kailangan ko to
SupplierModels t = new SupplierModels();
FileStream stream = File.Open(path_and_file, FileMode.Open, FileAccess.Read);
IExcelDataReader excelReader = null;
string ext = Path.GetExtension(stream.Name);
if (ext == ".xls")
{
//1. Reading from a binary Excel file ('97-2003 format; *.xls)
excelReader = ExcelReaderFactory.CreateBinaryReader(stream);
}
else if (ext == ".xlsx")
{
//2. Reading from a OpenXml Excel file (2007 format; *.xlsx)
excelReader = ExcelReaderFactory.CreateOpenXmlReader(stream);
}
else
{
throw new Exception("Invalid file type.");
}
//Choose one of either 3, 4, or 5
//3. DataSet - The result of each spreadsheet will be created in the result.Tables
//DataSet result = excelReader.AsDataSet();
//4. DataSet - Create column names from first row
excelReader.IsFirstRowAsColumnNames = true;
DataSet result = excelReader.AsDataSet();
//5. Data Reader methods
DateTime dateCreated = DateTime.Now;
int ctr = 0;
string log_output = "";
////override function
//if (allowOverride)
//{
// t.DeleteTestTargets("WW" + current_workweek.ToString().PadLeft(2, '0'), current_year);
//}
while (excelReader.Read())
{
if (ctr >= 1)
{
SupplierObject targets = new SupplierObject();
targets.Name = excelReader.IsDBNull(0) ? string.Empty : excelReader.GetString(0);
targets.Email = excelReader.IsDBNull(1) ? string.Empty : excelReader.GetString(1);
targets.ContactNbr = excelReader.IsDBNull(2) ? string.Empty : excelReader.GetString(2);
targets.UnitNbr = excelReader.IsDBNull(3) ? string.Empty : excelReader.GetString(3);
targets.StreetName = excelReader.IsDBNull(4) ? string.Empty : excelReader.GetString(4);
targets.Municipality = excelReader.IsDBNull(5) ? string.Empty : excelReader.GetString(5);
targets.City = excelReader.IsDBNull(6) ? string.Empty : excelReader.GetString(6);
targets.Country = excelReader.IsDBNull(7) ? string.Empty : excelReader.GetString(7);
targets.Zip = excelReader.IsDBNull(8) ? 0 : Convert.ToInt32(excelReader.GetString(8));
targets.ImpexRefNbr = excelReader.IsDBNull(9) ? string.Empty : excelReader.GetString(9);
targets.IsActive = true;
targets.AddedBy = Convert.ToInt32(HttpContext.Current.Session["userId_local"]);
targets.DateAdded = dateCreated;
t.SaveNewSupplier(targets);
total++;
success++;
//buburahin ko to titira ko lang "t.SaveTargets(targets)"
//if (targets.WorkWeek != "WW" + current_workweek.ToString().PadLeft(2, '0') || targets.FiscalYear != current_year)
//{
// fail++;
// log_output += "<p><span class='label label-danger'>[" + targets.ProductGroup + "] [" + targets.PackageGroupA + "] [" + targets.PackageGroupB + "] [" + targets.Target + "] [" + targets.WorkWeek + "] [" + targets.FiscalYear + "] = work week or year mismatch</span></p>";
//}
//else
//{
// if (t.CheckExistingTestTarget(targets) > 0)
// {
// fail++;
// log_output += "<p><span class='label label-danger'>[" + targets.ProductGroup + "] [" + targets.PackageGroupA + "] [" + targets.PackageGroupB + "] [" + targets.Target + "] [" + targets.WorkWeek + "] [" + targets.FiscalYear + "] = already exists</span></p>";
// }
// else
// {
// if (!t.SaveTargets(targets))
// {
// fail++;
// log_output += "<p><span class='label label-danger'>[" + targets.ProductGroup + "] [" + targets.PackageGroupA + "] [" + targets.PackageGroupB + "] [" + targets.Target + "] [" + targets.WorkWeek + "] [" + targets.FiscalYear + "] = failed</span></p>";
// }
// else
// {
// hasSuccess = true;
// success++;
// log_output += "<p><span class='label label-success'>[" + targets.ProductGroup + "] [" + targets.PackageGroupA + "] [" + targets.PackageGroupB + "] [" + targets.Target + "] [" + targets.WorkWeek + "] [" + targets.FiscalYear + "] = added</span></p>";
// }
// }
//}
//hanggang dito
//total++;
}
ctr++;
}
//if (hasSuccess)
//{
// t.RefreshData();
//}
//6. Free resources (IExcelDataReader is IDisposable)
excelReader.Close();
Dictionary <string, int> stats = new Dictionary <string, int>();
stats.Add("success", success);
stats.Add("fail", fail);
Dictionary <string, string> msg = new Dictionary <string, string>();
if (total <= 0)
{
throw new Exception("Uploaded file is empty or is in the wrong format. Kindly check the guidelines for uploading.");
}
else
{
if (success == total)
{
msg.Add("title", "Uploading Successful!");
msg.Add("body", "New targets uploaded successfully!");
msg.Add("type", "success");
}
else
{
msg.Add("title", "Uploading Unsuccessful!");
msg.Add("body", success + " / " + total + " uploaded successfully!");
msg.Add("type", "danger");
}
}
response.Add("success", true);
response.Add("error", false);
response.Add("stats", stats);
response.Add("logs", log_output);
response.Add("message", msg);
}
catch (Exception e)
{
response.Add("success", false);
response.Add("error", true);
response.Add("message", e.ToString());
}
return(response);
}
