//Add:New Material Classification
public bool Add_MaterialClassification(MaterialClassification mat)
{
bool status = false;
if (mat != null)
{
db.MaterialClassifications.InsertOnSubmit(mat);
db.SubmitChanges();
status = true;
}
return(status);
}
//Delete:Material Classification record by id
public bool Delete_MaterialClassification(int id)
{
bool status = false;
MaterialClassification mat = db.MaterialClassifications.FirstOrDefault(x => x.Id == id && x.IsDeleted == false);
if (mat != null)
{
mat.IsDeleted = true;
db.SubmitChanges();
status = true;
}
return(status);
}
private void beforeSaveMaterial(EntityInfo entityInfo)
{
if (entityInfo.EntityState == EntityState.Added)
{
Material material = entityInfo.Entity as Material;
if (string.IsNullOrEmpty(material.UploadedBy))
{
material.UploadedBy = Thread.CurrentPrincipal.Identity.Name;
}
if (!material.UploaderType.HasValue)
{
material.UploaderType = UploaderType.Other;
}
if (string.IsNullOrEmpty(material.ActivityLabel))
{
MaterialClassification mc = Session.Query <MaterialClassification>().First(x => x.Id == material.MaterialClassificationId);
material.ActivityLabel = "Request creation";
if (mc.Code.Equals("SOUR") || mc.Code.Equals("OLDO") || mc.Code.Equals("OLDT") || mc.Code.Equals("CREF"))
{
material.ActivityLabel = "Request creation";
}
}
}
}
//Get:Material Classification By Code
public MaterialClassification Get_Material_ClassificationByCode(string code)
{
MaterialClassification mat = db.MaterialClassifications.FirstOrDefault(x => x.MaterialClassificationCode == code && x.IsDeleted == false);
return(mat);
}
//Get:Material Classification by Id
public MaterialClassification Get_MaterialClassificationById(int id)
{
MaterialClassification mat = db.MaterialClassifications.FirstOrDefault(x => x.Id == id && x.IsDeleted == false);
return(mat);
}
//Save:Excel file data to the server
public string SaveDataToServer(DataSet ds)
{
string result = string.Empty;
using (DataClasses1DataContext db = new DataClasses1DataContext())
{
string connection = ConfigurationManager.ConnectionStrings["AveryDBConnectionString"].ConnectionString;
DataTable dt = ds.Tables[0];
int _failed = 0;
int _success = 0;
int _update = 0;
foreach (DataRow dr in dt.Rows)
{
try
{
string _MaterialClassificationCode = dr["Material Classification Code"].ToString();
string _MaterialClassificationDesc = dr["Material Classification Des"].ToString();
string _SupplierVendorCode = dr["Supplier Vendor Code"].ToString();
var _MaterialClassification = db.MaterialClassifications.Where(x => x.MaterialClassificationCode == _MaterialClassificationCode && x.IsDeleted == false).FirstOrDefault();
var supplier = db.tblSuppliers.FirstOrDefault(x => x.Code == _SupplierVendorCode && x.IsDeleted == false);
if (_MaterialClassification != null)
{
_MaterialClassification.MaterialClassificationDesc = _MaterialClassificationDesc;
_MaterialClassification.Supplier_VendorCode = _SupplierVendorCode;
_update++;
}
else
{
if (!string.IsNullOrEmpty(_MaterialClassificationCode) && !string.IsNullOrEmpty(_MaterialClassificationDesc))
{
MaterialClassification _mat = db.MaterialClassifications.Where(x => x.MaterialClassificationCode == _MaterialClassificationCode && x.IsDeleted == false).FirstOrDefault();
if (_mat != null)
{
_failed++;
}
else
{
if (supplier != null)
{
db.MaterialClassifications.InsertOnSubmit(new MaterialClassification
{
MaterialClassificationCode = _MaterialClassificationCode,
MaterialClassificationDesc = _MaterialClassificationDesc,
Supplier_VendorCode = _SupplierVendorCode,
IsDeleted = false
});
db.SubmitChanges();
_success++;
}
}
}
else
{
_failed++;
}
}
}
catch { _failed++; }
}
result = "New Added: " + _success + " Updated: " + _update + " Failed: " + _failed + "";
}
return(result);
}
//Save:Excel data to the server
public string SaveDataToServer(DataSet ds)
{
string result = string.Empty;
using (DataClasses1DataContext db = new DataClasses1DataContext())
{
string connection = ConfigurationManager.ConnectionStrings["AveryDBConnectionString"].ConnectionString;
DataTable dt = ds.Tables[0];
int _failed = 0;
int _success = 0;
int _update = 0;
foreach (DataRow dr in dt.Rows)
{
try
{
string _PackingCode = dr["Packing Code"].ToString();
string _Matclascode = dr["Material Classification Code"].ToString();
string _MaterialCode = dr["Material Code"].ToString();
string _MaterialDesc = dr["Material Desc"].ToString();
MaterialClassification mc = db.MaterialClassifications.FirstOrDefault(x => x.MaterialClassificationCode == _Matclascode && x.IsDeleted == false);
PackingMaster pm = db.PackingMasters.Where(x => x.PackingCode == _PackingCode && x.IsDeleted == false).FirstOrDefault();
var data = db.tblMaterials.Where(x => x.MaterialCode == _MaterialCode && x.IsDeleted == false).FirstOrDefault();
if (data != null)
{
if (string.IsNullOrEmpty(_PackingCode) && string.IsNullOrEmpty(_Matclascode) && string.IsNullOrEmpty(_MaterialDesc))
{
_failed++;
}
else
{
data.MaterialDesc = _MaterialDesc;
data.PackingCode = _PackingCode;
data.MaterialClassificationCodeId = _Matclascode;
db.SubmitChanges();
_update++;
}
}
else
{
if (!string.IsNullOrEmpty(_MaterialCode) && !string.IsNullOrEmpty(_MaterialDesc) && !string.IsNullOrEmpty(_PackingCode) && !string.IsNullOrEmpty(_Matclascode))
{
tblMaterial _tblmaterial = db.tblMaterials.Where(x => x.MaterialCode == _MaterialCode && x.IsDeleted == false).FirstOrDefault();
if (_tblmaterial != null)
{
_failed++;
}
else
{
db.tblMaterials.InsertOnSubmit(new tblMaterial
{
MaterialCode = _MaterialCode,
MaterialDesc = _MaterialDesc,
PackingCodeId = _PackingCode,
MaterialClassificationCodeId = _Matclascode,
IsDeleted = false
});
db.SubmitChanges();
_success++;
}
}
else
{
_failed++;
}
}
}
catch { _failed++; }
}
result = "New Added: " + _success + " Updated: " + _update + " Failed: " + _failed + "";
}
return(result);
}
