public string GetweightmachinByCode(string code)
{
WeightMachineMaster _wm = _wrepo.GetMachineMasterByCode(code.ToLower());
string myjsonresult = new JavaScriptSerializer().Serialize(_wm);
return(myjsonresult);
}
//Get:Weight Machine Master by MachineId
public WeightMachineMaster GetMachineMaster_ByMachineId(string MachineId)
{
WeightMachineMaster machine = (from t in db.WeightMachineMasters
where t.MachineId == MachineId && t.IsDeleted == false
select t).FirstOrDefault();
return(machine);
}
public string Check_WeightMachineMaster(string machineid)
{
string json = string.Empty;
WeightMachineMaster m = _wrepo.GetMachineMaster_ByMachineId(machineid.ToLower());
if (m != null)
{
json = new JavaScriptSerializer().Serialize(m);
}
return(json);
}
//Add:New Weight Machine Master record
public bool Add_WeightMachineMaster(WeightMachineMaster wt)
{
bool status = false;
if (wt != null)
{
db.WeightMachineMasters.InsertOnSubmit(wt);
db.SubmitChanges();
status = true;
}
return(status);
}
//Delete:Weight Machine Master
public bool Delete_WeightMachineMaster(int id)
{
bool status = false;
WeightMachineMaster w = db.WeightMachineMasters.FirstOrDefault(x => x.Id == id && x.IsDeleted == false);
if (w != null)
{
w.IsDeleted = true;
db.SubmitChanges();
status = true;
}
return(status);
}
//Add:New Record
private void Add()
{
try
{
var _data = _repo.GetMachineMaster_ByMachineId(txtMachinId.Text.Trim());
if (_data != null)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "toastr", "toastr.error('Same Machin Id Exist Please Try Again');", true);
}
else
{
WeightMachineMaster wm = new WeightMachineMaster();
wm.PlantCodeId = ddlPlantId.SelectedValue;
wm.MachineId = txtMachinId.Text;
wm.Capacity = txtCapacity.Text.ToString() + ddlcapacityuom.SelectedValue.ToString();
wm.Resolution = txtResolution.Text.ToString() + ddlresolutionuom.SelectedValue.ToString();
wm.Model = txtModel.Text.ToString();
wm.PlatformSize = txtPlatformsize.Text.ToString();
wm.MachineNo = txtmachinno.Text.ToString();
wm.Indicator = txtindicator.Text.ToString();
wm.LCType = txtlctype.Text.ToString();
wm.NoOfLoadCells = txtnoofloadcells.Text.ToString();
wm.LoadCellSerialNos = txtnoofloadcells.Text.ToString();
wm.EquipmentId = Convert.ToInt32(txtequipment.Text);
wm.InvoiceNo = txtinvoiceno.Text.ToString();
DateTime dispatchdate = DateTime.ParseExact(txtdispatchdate.Text, "dd/MM/yyyy", new CultureInfo("en-GB"));
wm.DespatchDate = dispatchdate;
DateTime InstallationDate = DateTime.ParseExact(txtinstallationdate.Text, "dd/MM/yyyy", new CultureInfo("en-GB"));
wm.InstallationDate = InstallationDate;
DateTime WarrentyUpto = DateTime.ParseExact(txtwarrantyupto.Text, "dd/MM/yyyy", new CultureInfo("en-GB"));
wm.WarrentyUpto = WarrentyUpto;
wm.ReasonWarrentyUptoDate = txtrowud.Text.ToString();
wm.WeighingUnit = this.ddlcapacityuom.Text.Trim().ToString();
wm.IsDeleted = false;
if (_repo.Add_WeightMachineMaster(wm))
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "toastr", "toastr.success('Save Successfully');", true);
HtmlMeta meta = new HtmlMeta();
meta.HttpEquiv = "Refresh";
meta.Content = "1;url=AddEdit.aspx";
this.Page.Controls.Add(meta);
}
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "toastr", "toastr.error('" + ex.Message.ToString() + "');", true);
}
}
//Update:Weight Machine Master
private void Edit()
{
int id = Convert.ToInt32(Request.QueryString["Id"].ToString());
try
{
var _data = _repo.GetMachineMasters_List().Where(x => x.MachineId == txtMachinId.Text && x.Id != id && x.IsDeleted == false).FirstOrDefault();
if (_data != null)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "toastr", "toastr.error('Same Machin Id Exist! Please try again');", true);
}
else
{
WeightMachineMaster _dt = db.WeightMachineMasters.Where(x => x.Id == id && x.IsDeleted == false).FirstOrDefault();
_dt.MachineId = txtMachinId.Text.ToString();
_dt.PlantCodeId = ddlPlantId.SelectedValue.ToString();
_dt.Capacity = txtCapacity.Text.ToString() + ddlcapacityuom.Text.ToString();
_dt.Resolution = txtResolution.Text.ToString() + ddlresolutionuom.Text.ToString();
_dt.Model = txtModel.Text.ToString();
_dt.PlatformSize = txtPlatformsize.Text.ToString();
_dt.MachineNo = txtmachinno.Text.ToString();
_dt.Indicator = txtindicator.Text.ToString();
_dt.LCType = txtlctype.Text.ToString();
_dt.NoOfLoadCells = txtnoofloadcells.Text.ToString();
_dt.LoadCellSerialNos = txtlcsn.Text.ToString();
_dt.EquipmentId = Convert.ToInt32(txtequipment.Text);
_dt.InvoiceNo = txtinvoiceno.Text.ToString();
_dt.DespatchDate = Convert.ToDateTime(txtdispatchdate.Text);
_dt.InstallationDate = Convert.ToDateTime(txtinstallationdate.Text);
_dt.WarrentyUpto = Convert.ToDateTime(txtwarrantyupto.Text);
_dt.ReasonWarrentyUptoDate = txtrowud.Text.ToString();
_dt.WeighingUnit = this.ddlcapacityuom.Text.Trim().ToString();
db.SubmitChanges();
ScriptManager.RegisterStartupScript(this, this.GetType(), "toastr", "toastr.success('Record Updated Successfully');", true);
HtmlMeta meta = new HtmlMeta();
meta.HttpEquiv = "Refresh";
meta.Content = "1;url=AddEdit.aspx?id=" + id;
this.Page.Controls.Add(meta);
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "toastr", "toastr.error('" + ex.Message.ToString() + "');", true);
}
}
//Get:Previous record
protected void Previous_Record_Click(object sender, EventArgs e)
{
int id = Convert.ToInt32(Request.QueryString["Id"].ToString());
WeightMachineMaster next = null;
try
{
next = _repo.GetMachineMasters_List().Where(x => x.Id < id && x.IsDeleted == false).OrderByDescending(i => i.Id).FirstOrDefault();
}
catch
{
}
if (next != null)
{
Response.Redirect("AddEdit.aspx?id=" + next.Id.ToString());
}
else
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "toastr", "toastr.success('No more records founds.')", true);
}
}
//Get:Weight Machine Master for edit
private void GetWTMachinMasterForEdit()
{
if (Request.QueryString["Id"] != null)
{
txtMachinId.Enabled = false;
ddlPlantId.Enabled = false;
divoptions.Style.Add("display", "block");
int id = Convert.ToInt32(Request.QueryString["Id"].ToString());
WeightMachineMaster _wmm = _repo.Get_WeightMachineMasterById(id);
if (_wmm != null)
{
ddlPlantId.SelectedValue = _wmm.PlantCodeId.ToString();
txtMachinId.Text = _wmm.MachineId.ToString();
txtCapacity.Text = _repo.Get_Number(_wmm.Capacity);
ddlcapacityuom.SelectedValue = _repo.Get_String(_wmm.Capacity);
txtResolution.Text = _repo.Get_Number(_wmm.Resolution);
ddlresolutionuom.SelectedValue = _repo.Get_String(_wmm.Resolution);
txtModel.Text = _wmm.Model.ToString();
txtPlatformsize.Text = _wmm.PlatformSize.ToString();
txtmachinno.Text = _wmm.MachineNo.ToString();
txtindicator.Text = _wmm.Indicator.ToString();
txtlctype.Text = _wmm.LCType.ToString();
txtnoofloadcells.Text = _wmm.NoOfLoadCells.ToString();
txtlcsn.Text = _wmm.LoadCellSerialNos.ToString();
txtequipment.Text = _wmm.EquipmentId.ToString();
txtinvoiceno.Text = _wmm.InvoiceNo.ToString();
txtdispatchdate.Text = _wmm.DespatchDate.ToString();
txtinstallationdate.Text = _wmm.InstallationDate.ToString();
txtwarrantyupto.Text = _wmm.WarrentyUpto.ToString();
txtrowud.Text = _wmm.ReasonWarrentyUptoDate.ToString();
this.ddlcapacityuom.Text = _wmm.WeighingUnit.ToString();
}
}
}
//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 _PlantCode = dr["Plant Code"].ToString();
string _MachineId = dr["Machine Id"].ToString();
string _IPPort = dr["IP Port"].ToString();
string _PortNo = dr["Port No"].ToString();
string _ModeOfComs = dr["Mode Of Coms"].ToString();
string _StabilityNos = dr["Stability Nos"].ToString();
string _StabilityRange = dr["Stability Range"].ToString();
int _ZeroInterlock = Convert.ToInt32(dr["Zero Interlock"]);
string _ZeroInterlockRange = dr["Zero Interlock Range"].ToString();
string _TransactionNoPrefix = dr["Transaction No Prefix"].ToString();
int _TareCheck = Convert.ToInt32(dr["Tare Check"]);
int _StoredTare = Convert.ToInt32(dr["Stored Tare"]);
var data = db.tblMachineWorkingParameters.Where(x => x.PlantCode == _PlantCode && x.MachineId == _MachineId && x.IsDeleted == false).FirstOrDefault();
if (data != null)
{
if (string.IsNullOrEmpty(_IPPort) && string.IsNullOrEmpty(_PortNo) && string.IsNullOrEmpty(_ModeOfComs))
{
_failed++;
}
else
{
data.PlantCode = _PlantCode;
data.MachineId = _MachineId;
data.IPPort = _IPPort;
data.PortNo = _PortNo;
data.StabilityNos = _StabilityNos;
data.StabilityRange = _StabilityRange;
data.TransactionNoPrefix = _TransactionNoPrefix;
data.ZeroInterlock = _ZeroInterlock;
data.ZeroInterlockRange = _ZeroInterlockRange;
data.ModeOfComs = _ModeOfComs;
data.TareCheck = _TareCheck;
data.StoredTare = _StoredTare;
db.SubmitChanges();
_update++;
}
}
else
{
if (!string.IsNullOrEmpty(_PlantCode) && !string.IsNullOrEmpty(_MachineId) && !string.IsNullOrEmpty(_ModeOfComs) && !string.IsNullOrEmpty(_IPPort) && !string.IsNullOrEmpty(_PortNo))
{
PlantMaster _plantmaster = db.PlantMasters.Where(x => x.PlantCode == _PlantCode && x.IsDeleted == false).FirstOrDefault();
WeightMachineMaster _machinemaster = db.WeightMachineMasters.Where(x => x.MachineId == _MachineId && x.IsDeleted == false).FirstOrDefault();
if (_plantmaster != null && _machinemaster != null)
{
tblMachineWorkingParameter _machineparameter = db.tblMachineWorkingParameters.Where(x => x.PlantCode == _PlantCode && x.MachineId == _MachineId && x.IsDeleted == false).FirstOrDefault();
if (_machineparameter != null)
{
_failed++;
}
else
{
tblMachineWorkingParameter t = new tblMachineWorkingParameter();
t.PlantCode = _PlantCode;
t.MachineId = _MachineId;
t.IPPort = _IPPort;
t.PortNo = _PortNo;
t.StabilityNos = _StabilityNos;
t.StabilityRange = _StabilityRange;
t.TransactionNoPrefix = _TransactionNoPrefix;
t.ZeroInterlock = _ZeroInterlock;
t.ZeroInterlockRange = _ZeroInterlockRange;
t.TareCheck = _TareCheck;
t.StoredTare = _StoredTare;
t.ModeOfComs = _ModeOfComs;
db.tblMachineWorkingParameters.InsertOnSubmit(t);
db.SubmitChanges();
_success++;
}
}
else
{
_failed++;
}
}
else
{
_failed++;
}
}
}
catch
{
_failed++;
}
}
result = "New Added: " + _success + " Updated: " + _update + " Failed: " + _failed + "";
}
return(result);
}
//Get:Weight Machine Master By Id
public WeightMachineMaster Get_WeightMachineMasterById(int id)
{
WeightMachineMaster w = db.WeightMachineMasters.FirstOrDefault(x => x.Id == id && x.IsDeleted == false);
return(w);
}
//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 _PlantCode = dr["Plant Code"].ToString();
string _MachineId = dr["Machine Id"].ToString();
string _capacity = dr["Capacity"].ToString();
string _resolution = dr["Resolution"].ToString();
string _model = dr["Model"].ToString();
string _platformsize = dr["Platform Size"].ToString();
string _machinno = dr["Machin No"].ToString();
string _indicator = dr["Indicator"].ToString();
string _lctype = dr["LC Type"].ToString();
string _noofloadcells = dr["No Of Load Cells"].ToString();
string _loadcellserialnos = dr["Load Cell Serial Nos"].ToString();
string _Equipment = dr["Equipment"].ToString();
string _invoiceno = dr["Invoice No"].ToString();
DateTime?_despatchdate = null;
_despatchdate = Convert.ToDateTime(dr["Despatch Date"]);
DateTime?_installationdate = Convert.ToDateTime(dr["Installation Date"]);
DateTime?_warrantydate = Convert.ToDateTime(dr["Warranty Upto"]);
string _reasonofwarrantyuptodate = dr["Reason Of Warranty"].ToString();
var _wt = db.WeightMachineMasters.Where(x => x.MachineId == _MachineId && x.IsDeleted == false).FirstOrDefault();
var _PlantMaster = db.PlantMasters.Where(x => x.PlantCode == _PlantCode && x.IsDeleted == false).FirstOrDefault();
if (_wt != null)
{
if (_PlantMaster == null && string.IsNullOrEmpty(_MachineId) && string.IsNullOrEmpty(_capacity) &&
string.IsNullOrEmpty(_resolution) && string.IsNullOrEmpty(_model) && string.IsNullOrEmpty(_platformsize) &&
string.IsNullOrEmpty(_machinno) && string.IsNullOrEmpty(_indicator) && string.IsNullOrEmpty(_lctype) &&
string.IsNullOrEmpty(_noofloadcells) && string.IsNullOrEmpty(_loadcellserialnos) &&
string.IsNullOrEmpty(_Equipment) && string.IsNullOrEmpty(_invoiceno) && _despatchdate == null && _installationdate == null &&
_warrantydate == null && string.IsNullOrEmpty(_reasonofwarrantyuptodate))
{
_failed++;
}
else
{
_wt.PlantCodeId = _PlantCode;
_wt.Capacity = _capacity;
_wt.Resolution = _resolution;
_wt.Model = _model;
_wt.PlatformSize = _platformsize;
_wt.MachineNo = _machinno;
_wt.Indicator = _indicator;
_wt.LCType = _lctype;
_wt.NoOfLoadCells = _noofloadcells;
_wt.LoadCellSerialNos = _loadcellserialnos;
_wt.EquipmentId = Convert.ToInt32(_Equipment);
_wt.InvoiceNo = _invoiceno;
_wt.DespatchDate = _despatchdate;
_wt.InstallationDate = _installationdate;
_wt.WarrentyUpto = _warrantydate;
_wt.ReasonWarrentyUptoDate = _reasonofwarrantyuptodate;
db.SubmitChanges();
_update++;
}
}
else
{
if (!string.IsNullOrEmpty(_PlantCode) && _PlantMaster != null && !string.IsNullOrEmpty(_MachineId) &&
!string.IsNullOrEmpty(_capacity) && !string.IsNullOrEmpty(_resolution) && !string.IsNullOrEmpty(_model) &&
!string.IsNullOrEmpty(_machinno) && !string.IsNullOrEmpty(_indicator) && !string.IsNullOrEmpty(_lctype) &&
!string.IsNullOrEmpty(_noofloadcells) && !string.IsNullOrEmpty(_loadcellserialnos) &&
!string.IsNullOrEmpty(_Equipment) && !string.IsNullOrEmpty(_invoiceno) && _despatchdate != null &&
_installationdate != null && _warrantydate != null && !string.IsNullOrEmpty(_platformsize) &&
!string.IsNullOrEmpty(_reasonofwarrantyuptodate))
{
WeightMachineMaster _mm = db.WeightMachineMasters.Where(x => x.MachineId == _MachineId && x.IsDeleted == false).FirstOrDefault();
if (_mm != null)
{
_failed++;
}
else
{
db.WeightMachineMasters.InsertOnSubmit(new WeightMachineMaster
{
PlantCodeId = _PlantCode,
MachineId = _MachineId,
Capacity = _capacity,
Resolution = _resolution,
Model = _model,
PlatformSize = _platformsize,
MachineNo = _machinno,
Indicator = _indicator,
LCType = _lctype,
NoOfLoadCells = _noofloadcells,
LoadCellSerialNos = _loadcellserialnos,
EquipmentId = Convert.ToInt16(_Equipment),
InvoiceNo = _invoiceno,
DespatchDate = _despatchdate,
InstallationDate = _installationdate,
WarrentyUpto = _warrantydate,
ReasonWarrentyUptoDate = _reasonofwarrantyuptodate,
IsDeleted = false
});
db.SubmitChanges();
_success++;
}
}
else
{
_failed++;
}
}
}
catch { _failed++; }
}
result = "New Added: " + _success + " Updated: " + _update + " Failed: " + _failed + "";
}
return(result);
}
