/// <summary>
/// AutoSearch
/// Calls [usp_autosearch_Part]
/// </summary>
public override List <PartDetails> AutoSearch(System.Int32?clientId, System.String partSearch)
{
SqlConnection cn = null;
SqlCommand cmd = null;
try {
cn = new SqlConnection(this.ConnectionString);
cmd = new SqlCommand("usp_autosearch_Part", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandTimeout = 60;
cmd.Parameters.Add("@ClientId", SqlDbType.Int).Value = clientId;
cmd.Parameters.Add("@PartSearch", SqlDbType.NVarChar).Value = partSearch;
cn.Open();
DbDataReader reader = ExecuteReader(cmd);
List <PartDetails> lst = new List <PartDetails>();
while (reader.Read())
{
PartDetails obj = new PartDetails();
obj.PartName = GetReaderValue_String(reader, "PartName", "");
lst.Add(obj);
obj = null;
}
return(lst);
} catch (SqlException sqlex) {
//LogException(sqlex);
throw new Exception("Failed to get Parts", sqlex);
} finally {
cmd.Dispose();
cn.Close();
cn.Dispose();
}
}
public void ReadPointerData(Vault vault, BinaryReader br)
{
PartDetails.ReadPointerData(vault, br);
_offerIdText.ReadPointerData(vault, br);
OfferID = _offerIdText.Value;
}
/// <summary>
/// AutoSearch
/// Calls [usp_autosearch_CustReqPart]
/// </summary>
public override List <PartDetails> CustReqPart(System.Int32?clientId, System.String partSearch, System.String ids, System.String DateCode)
{
SqlConnection cn = null;
SqlCommand cmd = null;
string ManufacturerNo = "";
string ProductNumber = "";
string PackageNumber = "";
string[] values = ids.Split('|');// ids.Split(",");
ManufacturerNo = values[0].Trim();
ProductNumber = values[1].Trim();
PackageNumber = values[2].Trim();
try
{
cn = new SqlConnection(this.ConnectionString);
cmd = new SqlCommand("usp_autosearch_CustReqPart", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandTimeout = 60;
cmd.Parameters.Add("@ClientId", SqlDbType.Int).Value = clientId;
cmd.Parameters.Add("@PartSearch", SqlDbType.NVarChar).Value = partSearch;
cmd.Parameters.Add("@ManufacturerNo", SqlDbType.Int).Value = Convert.ToInt32(ManufacturerNo);
cmd.Parameters.Add("@ProductNumber", SqlDbType.Int).Value = Convert.ToInt32(ProductNumber);
cmd.Parameters.Add("@PackageNumber", SqlDbType.Int).Value = Convert.ToInt32(PackageNumber);
cmd.Parameters.Add("@DateCode", SqlDbType.NVarChar).Value = DateCode;
cn.Open();
DbDataReader reader = ExecuteReader(cmd);
List <PartDetails> lst = new List <PartDetails>();
while (reader.Read())
{
PartDetails obj = new PartDetails();
obj.PartNameWithManufacture = GetReaderValue_String(reader, "PartName", "");
obj.PartName = GetReaderValue_String(reader, "Parts", "");
obj.ManufacturerNo = GetReaderValue_Int32(reader, "ManufacturerId", 0);
obj.Productname = GetReaderValue_String(reader, "ProductName", "");
obj.Packagename = GetReaderValue_String(reader, "PackageName", "");
obj.DateCode = GetReaderValue_String(reader, "DateCode", "");
obj.ProductNo = GetReaderValue_Int32(reader, "ProductNo", 0);
obj.PackageNo = GetReaderValue_Int32(reader, "PackageNo", 0);
obj.ManufacturerName = GetReaderValue_String(reader, "ManufacturerName", "");
obj.ROHSNo = GetReaderValue_Int32(reader, "ROHS", 0);
lst.Add(obj);
obj = null;
}
return(lst);
}
catch (SqlException sqlex)
{
//LogException(sqlex);
throw new Exception("Failed to get Parts", sqlex);
}
finally
{
cmd.Dispose();
cn.Close();
cn.Dispose();
}
}
protected void gvPartDetails_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "EditRow")
{
int rowIndex = ((GridViewRow)((LinkButton)e.CommandSource).NamingContainer).RowIndex;
gvPartDetails.EditIndex = rowIndex;
showdata();
}
else if (e.CommandName == "DeleteRow")
{
PartDetails partInfo = new PartDetails();
int rowIndex = ((GridViewRow)((LinkButton)e.CommandSource).NamingContainer).RowIndex;
Label lblPartID = (Label)gvPartDetails.Rows[rowIndex].FindControl("lblPartID");
partInfo.PartID = int.Parse(lblPartID.Text);
obj.DeletePartDetails(partInfo);
showdata();
}
else if (e.CommandName == "CancelUpdate")
{
gvPartDetails.EditIndex = -1;
showdata();
}
else if (e.CommandName == "UpdateRow")
{
int rowIndex = ((GridViewRow)((LinkButton)e.CommandSource).NamingContainer).RowIndex;
PartDetails partInfo = new PartDetails();
Label lblEditPartID = (Label)gvPartDetails.Rows[rowIndex].FindControl("lblEditPartID");
TextBox txtEditName = ((TextBox)gvPartDetails.Rows[rowIndex].FindControl("txtEditName"));
TextBox txtEditCarModel = ((TextBox)gvPartDetails.Rows[rowIndex].FindControl("txtEditCarModel"));
TextBox txtEditCost = ((TextBox)gvPartDetails.Rows[rowIndex].FindControl("txtEditCost"));
partInfo.PartID = int.Parse(lblEditPartID.Text);
partInfo.PartName = txtEditName.Text;
partInfo.CarModel = txtEditCarModel.Text;
partInfo.Cost = float.Parse(txtEditCost.Text);
obj.UpdatePartDetails(partInfo);
gvPartDetails.EditIndex = -1;
showdata();
}
else if (e.CommandName == "InsertRow")
{
PartDetails partInfo = new PartDetails();
TextBox txtPartName = ((TextBox)gvPartDetails.FooterRow.FindControl("txtPartName"));
TextBox txtCarModel = ((TextBox)gvPartDetails.FooterRow.FindControl("txtCarModel"));
TextBox txtCost = ((TextBox)gvPartDetails.FooterRow.FindControl("txtCost"));
partInfo.PartName = txtPartName.Text;
partInfo.CarModel = txtCarModel.Text;
partInfo.Cost = float.Parse(txtCost.Text);
obj.InsertPartDetails(partInfo);
showdata();
}
}
public void AddPointers(Vault vault)
{
AutoSculptCamera1.AddPointers(vault);
AutoSculptCamera2.AddPointers(vault);
AutoSculptCamera3.AddPointers(vault);
PartDetails.AddPointers(vault);
_offerIdText.AddPointers(vault);
}
public void WritePointerData(Vault vault, BinaryWriter bw)
{
AutoSculptCamera1.WritePointerData(vault, bw);
AutoSculptCamera2.WritePointerData(vault, bw);
AutoSculptCamera3.WritePointerData(vault, bw);
PartDetails.WritePointerData(vault, bw);
_offerIdText.WritePointerData(vault, bw);
}
public void ReadPointerData(Vault vault, BinaryReader br)
{
AutoSculptCamera1.ReadPointerData(vault, br);
AutoSculptCamera2.ReadPointerData(vault, br);
AutoSculptCamera3.ReadPointerData(vault, br);
PartDetails.ReadPointerData(vault, br);
_offerIdText.ReadPointerData(vault, br);
OfferID = _offerIdText.Value;
}
public void DeletePartDetails(PartDetails partInfo)
{
SqlConnection con = new SqlConnection(conStr);
con.Open();
SqlCommand cmd = new SqlCommand("delete from PART_DETAILS where part_id=@PartID", con);
cmd.Parameters.AddWithValue("@PartID", partInfo.PartID);
cmd.ExecuteNonQuery();
con.Close();
}
public void InsertPartDetails(PartDetails partInfo)
{
SqlConnection con = new SqlConnection(conStr);
con.Open();
SqlCommand cmd = new SqlCommand("insert into PART_DETAILS (part_name,carmodel,cost) values(@PartName,@CarModel,@Cost)", con);
cmd.Parameters.AddWithValue("@PartName", partInfo.PartName);
cmd.Parameters.AddWithValue("@CarModel", partInfo.CarModel);
cmd.Parameters.AddWithValue("@Cost", partInfo.Cost);
cmd.ExecuteNonQuery();
con.Close();
}
/// <summary>
/// AutoSearch
/// Calls [usp_autosearch_Part_New]
/// </summary>
public override List <PartDetails> CustReqPartsGRID(System.Int32?clientId, System.String partSearch)
{
SqlConnection cn = null;
SqlCommand cmd = null;
try
{
partSearch = partSearch + "%";
cn = new SqlConnection(this.ConnectionString);
cmd = new SqlCommand("usp_PartSearch_GRID", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandTimeout = 60;
cmd.Parameters.Add("@ClientId", SqlDbType.Int).Value = clientId;
cmd.Parameters.Add("@PartSearch", SqlDbType.NVarChar).Value = partSearch;
cn.Open();
DbDataReader reader = ExecuteReader(cmd);
List <PartDetails> lst = new List <PartDetails>();
while (reader.Read())
{
PartDetails obj = new PartDetails();
obj.PartNameWithManufacture = GetReaderValue_String(reader, "PartName", "");
obj.PartName = GetReaderValue_String(reader, "Parts", "");
obj.ManufacturerNo = GetReaderValue_Int32(reader, "ManufacturerId", 0);
obj.ProductNo = GetReaderValue_Int32(reader, "ProductNo", 0);
obj.PackageNo = GetReaderValue_Int32(reader, "PackageNo", 0);
obj.ManufacturerName = GetReaderValue_String(reader, "ManufacturerName", "");
obj.Productname = GetReaderValue_String(reader, "ProductName", "");
obj.Packagename = GetReaderValue_String(reader, "PackageName", "");
obj.DateCode = GetReaderValue_String(reader, "DateCode", "");
obj.DateCodeOriginal = GetReaderValue_String(reader, "DateCodeOriginal", "");
obj.ROHSNo = GetReaderValue_Int32(reader, "ROHS", 0);
obj.ProductDescription = GetReaderValue_String(reader, "ProductDescription", "");
obj.ProductInactive = GetReaderValue_NullableBoolean(reader, "ProductInactive", false);
lst.Add(obj);
obj = null;
}
return(lst);
}
catch (SqlException sqlex)
{
//LogException(sqlex);
throw new Exception("Failed to get Parts", sqlex);
}
finally
{
cmd.Dispose();
cn.Close();
cn.Dispose();
}
}
public void UpdatePartDetails(PartDetails partInfo)
{
SqlConnection con = new SqlConnection(conStr);
con.Open();
SqlCommand cmd = new SqlCommand("update PART_DETAILS set part_name=@PartName,carmodel=@CarModel, cost=@Cost where part_id=@PartID", con);
cmd.Parameters.AddWithValue("@PartID", partInfo.PartID);
cmd.Parameters.AddWithValue("@PartName", partInfo.PartName);
cmd.Parameters.AddWithValue("@CarModel", partInfo.CarModel);
cmd.Parameters.AddWithValue("@Cost", partInfo.Cost);
cmd.ExecuteNonQuery();
con.Close();
}
public List <PartDetails> AutoCompletePartDetails(string term)
{
List <PartDetails> PartList = new List <PartDetails>();
try
{
DataSet ds = null;
using (SqlConnection Connection = connection.returnConnection())
{
using (SqlCommand command = new SqlCommand())
{
ds = new DataSet();
command.Connection = Connection;
command.CommandText = "AutoComplete_PartDetailsList";
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@PartName", term);
SqlDataAdapter da = new SqlDataAdapter(command);
da.Fill(ds);
}
}
if (ds.Tables[0].Rows.Count > 0)
{
try
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
PartDetails obj = new PartDetails();
obj.PartNumber = Convert.ToString(dr["PartNumber"].ToString());
obj.PartDescription = dr["PartDescription"].ToString();
obj.UnitCost = dr["UnitCost"].ToString();
PartList.Add(obj);
}
}
catch (Exception ex)
{
clsError.WriteException(ex);
}
}
}
catch (Exception ex)
{
clsError.WriteException(ex);
}
return(PartList);
}
public override void Write(Vault vault, BinaryWriter bw)
{
bw.Write(HAL_ID);
bw.Write(CF_HAL_ID);
bw.Write(Price);
bw.Write(Drift);
bw.Write(Drag);
bw.Write(Grip);
bw.Write(Speed);
bw.Write(Tier);
bw.Write(BrandHALId);
bw.Write(LogoTextureId);
bw.Write((byte)AutoSculptCamera1.Items.Count);
bw.Write((byte)AutoSculptCamera2.Items.Count);
bw.Write((byte)AutoSculptCamera3.Items.Count);
bw.Write((byte)0);
AutoSculptCamera1.Write(vault, bw);
AutoSculptCamera2.Write(vault, bw);
AutoSculptCamera3.Write(vault, bw);
bw.Write(DetailHash);
PartDetails.Write(vault, bw);
_offerIdText.Write(vault, bw);
}
private static Part PopulateFromDBDetailsObject(PartDetails obj)
{
Part objNew = new Part();
objNew.PartId = obj.PartId;
objNew.FullPart = obj.FullPart;
objNew.ManufacturerNo = obj.ManufacturerNo;
objNew.PackageNo = obj.PackageNo;
objNew.ProductNo = obj.ProductNo;
objNew.MinimumQuantity = obj.MinimumQuantity;
objNew.ReOrderQuantity = obj.ReOrderQuantity;
objNew.LeadTime = obj.LeadTime;
objNew.ClientNo = obj.ClientNo;
objNew.ResalePrice = obj.ResalePrice;
objNew.ROHSCompliant = obj.ROHSCompliant;
objNew.MasterPart = obj.MasterPart;
objNew.GoldenPart = obj.GoldenPart;
objNew.UpdatedBy = obj.UpdatedBy;
objNew.DLUP = obj.DLUP;
objNew.PartTitle = obj.PartTitle;
objNew.PartName = obj.PartName;
return(objNew);
}
public override void Write(Vault vault, BinaryWriter bw)
{
bw.Write(HAL_ID);
bw.Write(CF_HAL_ID);
bw.Write(Price);
bw.Write(ShowroomUnlock);
bw.Write(Tier1Price);
bw.Write(Tier2Price);
bw.Write(Tier3Price);
bw.Write(Tier4Price);
bw.Write(Tier);
bw.Write(Tier1ShowroomUnlock);
bw.Write(Tier2ShowroomUnlock);
bw.Write(Tier3ShowroomUnlock);
bw.Write(Tier4ShowroomUnlock);
bw.AlignWriter(4);
bw.Write(BrandHALId);
bw.Write(LogoTextureId);
bw.Write(DetailHash);
PartDetails.Write(vault, bw);
_offerIdText.Write(vault, bw);
bw.Write(IsOnlineLockable);
bw.AlignWriter(4);
}
public static void PopulateTestData(AppDbContext dbContext)
{
//Remove Transaction data
foreach (var inv in dbContext.Inventory)
{
dbContext.Remove(inv);
}
foreach (var inventoryLoc in dbContext.InventoryLocation)
{
dbContext.Remove(inventoryLoc);
}
//Remove Master data
foreach (var usr in dbContext.User)
{
dbContext.Remove(usr);
}
foreach (var location in dbContext.Location)
{
dbContext.Remove(location);
}
foreach (var wearHouse in dbContext.Warehouse)
{
dbContext.Remove(wearHouse);
}
foreach (var binloc in dbContext.BinLocation)
{
dbContext.Remove(binloc);
}
foreach (var partDetail in dbContext.PartDetails)
{
dbContext.Remove(partDetail);
}
//Save Changes
dbContext.SaveChanges();
//Add Master data
var user1 = new User()
{
Name = "User1", Role = Role.Admin, CreatedOn = DateTime.Now
};
var user2 = new User()
{
Name = "User2", Role = Role.Admin, CreatedOn = DateTime.Now
};
dbContext.User.Add(user1);
dbContext.User.Add(user2);
//Add Master data
var location1 = new Location()
{
Name = "Ageo", Description = "AgeoDescription", CreatedBy = user1, CreatedOn = DateTime.Now
};
var location2 = new Location()
{
Name = "India", Description = "IndiaDescription", CreatedBy = user1, CreatedOn = DateTime.Now
};
dbContext.Location.Add(location1);
dbContext.Location.Add(location2);
var warehouse1 = new Warehouse()
{
Id = 1, Name = "Wearhouse1", Description = "W1Description", Location = location1, CreatedBy = user1, CreatedOn = DateTime.Now
};
dbContext.Warehouse.Add(warehouse1);
var binLocation1 = new BinLocation()
{
Name = "C903370A00", Description = "BinLoc1Desc", BinType = BinningType.Prime, Warehouse = warehouse1, CreatedBy = user1, Capacity = 120, CreatedOn = DateTime.Now
};
var binLocation2 = new BinLocation()
{
Name = "C903230B00", Description = "BinLoc2Desc", BinType = BinningType.Prime, Warehouse = warehouse1, CreatedBy = user1, Capacity = 100, CreatedOn = DateTime.Now
};
var binLocation3 = new BinLocation()
{
Name = "C903120B00", Description = "BinLoc3Desc", BinType = BinningType.Prime, Warehouse = warehouse1, CreatedBy = user1, Capacity = 90, CreatedOn = DateTime.Now
};
var binLocation4 = new BinLocation()
{
Name = "C902170A00", Description = "BinLoc4Desc", BinType = BinningType.Prime, Warehouse = warehouse1, CreatedBy = user1, Capacity = 80, CreatedOn = DateTime.Now
};
var binLocation5 = new BinLocation()
{
Name = "C902020A00", Description = "BinLoc5Desc", BinType = BinningType.Prime, Warehouse = warehouse1, CreatedBy = user1, Capacity = 70, CreatedOn = DateTime.Now
};
var binLocation6 = new BinLocation()
{
Name = "C901360A00", Description = "BinLoc6Desc", BinType = BinningType.Prime, Warehouse = warehouse1, CreatedBy = user1, Capacity = 110, CreatedOn = DateTime.Now
};
var binLocation7 = new BinLocation()
{
Name = "C903200B", Description = "BinLoc7Desc", BinType = BinningType.Prime, Warehouse = warehouse1, CreatedBy = user1, Capacity = 130, CreatedOn = DateTime.Now
};
var binLocation8 = new BinLocation()
{
Name = "C902200B00", Description = "BinLoc8Desc", BinType = BinningType.Prime, Warehouse = warehouse1, CreatedBy = user1, Capacity = 140, CreatedOn = DateTime.Now
};
var binLocation9 = new BinLocation()
{
Name = "C902120B00", Description = "BinLoc9Desc", BinType = BinningType.Prime, Warehouse = warehouse1, CreatedBy = user1, Capacity = 60, CreatedOn = DateTime.Now
};
var binLocation10 = new BinLocation()
{
Name = "C902080A00", Description = "BinLoc10Desc", BinType = BinningType.Prime, Warehouse = warehouse1, CreatedBy = user1, Capacity = 50, CreatedOn = DateTime.Now
};
var binLocation11 = new BinLocation()
{
Name = "C901370B00", Description = "BinLoc11Desc", BinType = BinningType.Prime, Warehouse = warehouse1, CreatedBy = user1, Capacity = 110, CreatedOn = DateTime.Now
};
var binLocation12 = new BinLocation()
{
Name = "C901110B00", Description = "BinLoc12Desc", BinType = BinningType.Prime, Warehouse = warehouse1, CreatedBy = user1, Capacity = 100, CreatedOn = DateTime.Now
};
var binLocation13 = new BinLocation()
{
Name = "C901090B00", Description = "BinLoc13Desc", BinType = BinningType.Prime, Warehouse = warehouse1, CreatedBy = user1, Capacity = 120, CreatedOn = DateTime.Now
};
var binLocation14 = new BinLocation()
{
Name = "C903400A00", Description = "BinLoc14Desc", BinType = BinningType.Prime, Warehouse = warehouse1, CreatedBy = user1, Capacity = 130, CreatedOn = DateTime.Now
};
var binLocation15 = new BinLocation()
{
Name = "C903300B", Description = "BinLoc15Desc", BinType = BinningType.Prime, Warehouse = warehouse1, CreatedBy = user1, Capacity = 150, CreatedOn = DateTime.Now
};
var binLocation16 = new BinLocation()
{
Name = "C903250B00", Description = "BinLoc16Desc", BinType = BinningType.Prime, Warehouse = warehouse1, CreatedBy = user1, Capacity = 140, CreatedOn = DateTime.Now
};
var binLocation17 = new BinLocation()
{
Name = "C903100A", Description = "BinLoc17Desc", BinType = BinningType.Prime, Warehouse = warehouse1, CreatedBy = user1, Capacity = 90, CreatedOn = DateTime.Now
};
var binLocation18 = new BinLocation()
{
Name = "C902140B00", Description = "BinLoc18Desc", BinType = BinningType.Prime, Warehouse = warehouse1, CreatedBy = user1, Capacity = 80, CreatedOn = DateTime.Now
};
var binLocation19 = new BinLocation()
{
Name = "Buffer1", Description = "BinLoc18Desc", BinType = BinningType.Buffer, Warehouse = warehouse1, CreatedBy = user1, Capacity = 60, CreatedOn = DateTime.Now
};
var binLocation20 = new BinLocation()
{
Name = "Buffer2", Description = "BinLoc18Desc", BinType = BinningType.Buffer, Warehouse = warehouse1, CreatedBy = user1, Capacity = 50, CreatedOn = DateTime.Now
};
var binLocation21 = new BinLocation()
{
Name = "Buffer3", Description = "BinLoc18Desc", BinType = BinningType.Buffer, Warehouse = warehouse1, CreatedBy = user1, Capacity = 40, CreatedOn = DateTime.Now
};
var binLocation22 = new BinLocation()
{
Name = "Buffer4", Description = "BinLoc18Desc", BinType = BinningType.Buffer, Warehouse = warehouse1, CreatedBy = user1, Capacity = 40, CreatedOn = DateTime.Now
};
var binLocation23 = new BinLocation()
{
Name = "Buffer5", Description = "BinLoc18Desc", BinType = BinningType.Buffer, Warehouse = warehouse1, CreatedBy = user1, Capacity = 40, CreatedOn = DateTime.Now
};
var binLocation24 = new BinLocation()
{
Name = "Buffer6", Description = "BinLoc18Desc", BinType = BinningType.Buffer, Warehouse = warehouse1, CreatedBy = user1, Capacity = 40, CreatedOn = DateTime.Now
};
dbContext.BinLocation.Add(binLocation1);
dbContext.BinLocation.Add(binLocation2);
dbContext.BinLocation.Add(binLocation3);
dbContext.BinLocation.Add(binLocation4);
dbContext.BinLocation.Add(binLocation5);
dbContext.BinLocation.Add(binLocation6);
dbContext.BinLocation.Add(binLocation7);
dbContext.BinLocation.Add(binLocation8);
dbContext.BinLocation.Add(binLocation9);
dbContext.BinLocation.Add(binLocation10);
dbContext.BinLocation.Add(binLocation11);
dbContext.BinLocation.Add(binLocation12);
dbContext.BinLocation.Add(binLocation13);
dbContext.BinLocation.Add(binLocation14);
dbContext.BinLocation.Add(binLocation15);
dbContext.BinLocation.Add(binLocation16);
dbContext.BinLocation.Add(binLocation17);
dbContext.BinLocation.Add(binLocation18);
dbContext.BinLocation.Add(binLocation19);
dbContext.BinLocation.Add(binLocation20);
dbContext.BinLocation.Add(binLocation21);
dbContext.BinLocation.Add(binLocation22);
dbContext.BinLocation.Add(binLocation23);
dbContext.BinLocation.Add(binLocation24);
var part1 = new PartDetails()
{
Name = "SPRING", PartNo = "9524600Z17", CreatedBy = user1, CreatedOn = DateTime.Now
};
var part2 = new PartDetails()
{
Name = "FILTER KIT", PartNo = "5222842791", CreatedBy = user1, CreatedOn = DateTime.Now
};
var part3 = new PartDetails()
{
Name = "OIL FILTER", PartNo = "5222771970", CreatedBy = user1, CreatedOn = DateTime.Now
};
var part4 = new PartDetails()
{
Name = "BUSHING", PartNo = "5406300Z11", CreatedBy = user1, CreatedOn = DateTime.Now
};
var part5 = new PartDetails()
{
Name = "PLATE-LOCATING", PartNo = "1301000Z01", CreatedBy = user1, CreatedOn = DateTime.Now
};
var part6 = new PartDetails()
{
Name = "BRAKE VALVE", PartNo = "4528900Z05", CreatedBy = user1, CreatedOn = DateTime.Now
};
var part7 = new PartDetails()
{
Name = "PRESSURE LIMITI", PartNo = "4758000Z1B", CreatedBy = user1, CreatedOn = DateTime.Now
};
var part8 = new PartDetails()
{
Name = "V-RIBBED BELT", PartNo = "5222802248", CreatedBy = user1, CreatedOn = DateTime.Now
};
var part9 = new PartDetails()
{
Name = "DIAPHRAGM", PartNo = "C903250B00", CreatedBy = user1, CreatedOn = DateTime.Now
};
dbContext.PartDetails.Add(part1);
dbContext.PartDetails.Add(part2);
dbContext.PartDetails.Add(part3);
dbContext.PartDetails.Add(part4);
dbContext.PartDetails.Add(part5);
dbContext.PartDetails.Add(part6);
dbContext.PartDetails.Add(part7);
dbContext.PartDetails.Add(part8);
dbContext.PartDetails.Add(part9);
var inventoryLoc1 = new InventoryLocation()
{
BinLocation = binLocation1, Quantity = 50, CreatedBy = user1, CreatedOn = DateTime.Now
};
var inventoryLoc2 = new InventoryLocation()
{
BinLocation = binLocation2, Quantity = 50, CreatedBy = user1, CreatedOn = DateTime.Now
};
var inventoryLoc3 = new InventoryLocation()
{
BinLocation = binLocation3, Quantity = 50, CreatedBy = user1, CreatedOn = DateTime.Now
};
var inventoryLoc4 = new InventoryLocation()
{
BinLocation = binLocation4, Quantity = 50, CreatedBy = user1, CreatedOn = DateTime.Now
};
var inventoryLoc5 = new InventoryLocation()
{
BinLocation = binLocation5, Quantity = 50, CreatedBy = user1, CreatedOn = DateTime.Now
};
var inventoryLoc6 = new InventoryLocation()
{
BinLocation = binLocation6, Quantity = 50, CreatedBy = user1, CreatedOn = DateTime.Now
};
var inventoryLoc7 = new InventoryLocation()
{
BinLocation = binLocation7, Quantity = 50, CreatedBy = user1, CreatedOn = DateTime.Now
};
var inventoryLoc8 = new InventoryLocation()
{
BinLocation = binLocation8, Quantity = 50, CreatedBy = user1, CreatedOn = DateTime.Now
};
var inventoryLoc9 = new InventoryLocation()
{
BinLocation = binLocation9, Quantity = 50, CreatedBy = user1, CreatedOn = DateTime.Now
};
var inventoryLoc10 = new InventoryLocation()
{
BinLocation = binLocation10, Quantity = 50, CreatedBy = user1, CreatedOn = DateTime.Now
};
var inventoryLoc11 = new InventoryLocation()
{
BinLocation = binLocation11, Quantity = 50, CreatedBy = user1, CreatedOn = DateTime.Now
};
var inventoryLoc12 = new InventoryLocation()
{
BinLocation = binLocation12, Quantity = 50, CreatedBy = user1, CreatedOn = DateTime.Now
};
var inventoryLoc13 = new InventoryLocation()
{
BinLocation = binLocation13, Quantity = 50, CreatedBy = user1, CreatedOn = DateTime.Now
};
var inventoryLoc14 = new InventoryLocation()
{
BinLocation = binLocation14, Quantity = 50, CreatedBy = user1, CreatedOn = DateTime.Now
};
var inventoryLoc15 = new InventoryLocation()
{
BinLocation = binLocation15, Quantity = 50, CreatedBy = user1, CreatedOn = DateTime.Now
};
var inventoryLoc16 = new InventoryLocation()
{
BinLocation = binLocation16, Quantity = 50, CreatedBy = user1, CreatedOn = DateTime.Now
};
var inventoryLoc17 = new InventoryLocation()
{
BinLocation = binLocation17, Quantity = 50, CreatedBy = user1, CreatedOn = DateTime.Now
};
var inventoryLoc18 = new InventoryLocation()
{
BinLocation = binLocation18, Quantity = 50, CreatedBy = user1, CreatedOn = DateTime.Now
};
var inventoryLoc19 = new InventoryLocation()
{
BinLocation = binLocation19, Quantity = 50, CreatedBy = user1, CreatedOn = DateTime.Now
};
var inventoryLoc20 = new InventoryLocation()
{
BinLocation = binLocation20, Quantity = 50, CreatedBy = user1, CreatedOn = DateTime.Now
};
var inventoryLoc21 = new InventoryLocation()
{
BinLocation = binLocation21, Quantity = 50, CreatedBy = user1, CreatedOn = DateTime.Now
};
var inventoryLoc22 = new InventoryLocation()
{
BinLocation = binLocation22, Quantity = 50, CreatedBy = user1, CreatedOn = DateTime.Now
};
var inventoryLoc23 = new InventoryLocation()
{
BinLocation = binLocation23, Quantity = 50, CreatedBy = user1, CreatedOn = DateTime.Now
};
var inventoryLoc24 = new InventoryLocation()
{
BinLocation = binLocation24, Quantity = 50, CreatedBy = user1, CreatedOn = DateTime.Now
};
var inventory1 = new Inventory()
{
QRCode = "Q1201807121", Warehouse = warehouse1, Description = "Description1", TotalQuantity = 100, Part = part1, InventoryLocations = new List <InventoryLocation>()
{
inventoryLoc1, inventoryLoc19
}, CreatedBy = user1, CreatedOn = DateTime.Now
};
var inventory2 = new Inventory()
{
QRCode = "Q1201807122", Warehouse = warehouse1, Description = "Description2", TotalQuantity = 200, Part = part2, InventoryLocations = new List <InventoryLocation>()
{
inventoryLoc2, inventoryLoc20
}, CreatedBy = user1, CreatedOn = DateTime.Now
};
var inventory3 = new Inventory()
{
QRCode = "Q1201807123", Warehouse = warehouse1, Description = "Description3", TotalQuantity = 60, Part = part3, InventoryLocations = new List <InventoryLocation>()
{
inventoryLoc3, inventoryLoc21
}, CreatedBy = user1, CreatedOn = DateTime.Now
};
var inventory4 = new Inventory()
{
QRCode = "Q1201807124", Warehouse = warehouse1, Description = "Description4", TotalQuantity = 80, Part = part4, InventoryLocations = new List <InventoryLocation>()
{
inventoryLoc4, inventoryLoc22
}, CreatedBy = user1, CreatedOn = DateTime.Now
};
var inventory5 = new Inventory()
{
QRCode = "Q1201807125", Warehouse = warehouse1, Description = "Description5", TotalQuantity = 70, Part = part5, InventoryLocations = new List <InventoryLocation>()
{
inventoryLoc5, inventoryLoc23
}, CreatedBy = user1, CreatedOn = DateTime.Now
};
var inventory6 = new Inventory()
{
QRCode = "Q1201807126", Warehouse = warehouse1, Description = "Description6", TotalQuantity = 40, Part = part6, InventoryLocations = new List <InventoryLocation>()
{
inventoryLoc6, inventoryLoc24
}, CreatedBy = user1, CreatedOn = DateTime.Now
};
var inventory7 = new Inventory()
{
QRCode = "Q1201807127", Warehouse = warehouse1, Description = "Description7", TotalQuantity = 110, Part = part7, InventoryLocations = new List <InventoryLocation>()
{
inventoryLoc7
}, CreatedBy = user1, CreatedOn = DateTime.Now
};
var inventory8 = new Inventory()
{
QRCode = "Q1201807128", Warehouse = warehouse1, Description = "Description8", TotalQuantity = 120, Part = part8, InventoryLocations = new List <InventoryLocation>()
{
inventoryLoc8
}, CreatedBy = user1, CreatedOn = DateTime.Now
};
var inventory9 = new Inventory()
{
QRCode = "Q1201807129", Warehouse = warehouse1, Description = "Description9", TotalQuantity = 130, Part = part9, InventoryLocations = new List <InventoryLocation>()
{
inventoryLoc9
}, CreatedBy = user1, CreatedOn = DateTime.Now
};
//dbContext.InventoryLocation.Add(inventoryLoc1);
//dbContext.InventoryLocation.Add(inventoryLoc2);
//dbContext.InventoryLocation.Add(inventoryLoc3);
//dbContext.InventoryLocation.Add(inventoryLoc4);
//dbContext.InventoryLocation.Add(inventoryLoc5);
//dbContext.InventoryLocation.Add(inventoryLoc6);
//dbContext.InventoryLocation.Add(inventoryLoc7);
//dbContext.InventoryLocation.Add(inventoryLoc8);
//dbContext.InventoryLocation.Add(inventoryLoc9);
//dbContext.InventoryLocation.Add(inventoryLoc10);
//dbContext.InventoryLocation.Add(inventoryLoc11);
//dbContext.InventoryLocation.Add(inventoryLoc12);
//dbContext.InventoryLocation.Add(inventoryLoc13);
//dbContext.InventoryLocation.Add(inventoryLoc14);
//dbContext.InventoryLocation.Add(inventoryLoc15);
//dbContext.InventoryLocation.Add(inventoryLoc16);
//dbContext.InventoryLocation.Add(inventoryLoc17);
//dbContext.InventoryLocation.Add(inventoryLoc18);
dbContext.Inventory.Add(inventory1);
dbContext.Inventory.Add(inventory2);
dbContext.Inventory.Add(inventory3);
dbContext.Inventory.Add(inventory4);
dbContext.Inventory.Add(inventory5);
dbContext.Inventory.Add(inventory6);
dbContext.Inventory.Add(inventory7);
dbContext.Inventory.Add(inventory8);
dbContext.Inventory.Add(inventory9);
//Save Changes
dbContext.SaveChanges();
}
public ActionResult CheckIn()
{
ServiceOrder serviceOrder = new ServiceOrder();
Customer customer = new Customer();
WOClassification woClassification = new WOClassification();
List <WOClassification> woClassificationCollection = new List <WOClassification>();
ServiceTechnician serviceTechnician = new ServiceTechnician();
List <ServiceTechnician> serviceTechnicianCollection = new List <ServiceTechnician>();
PartDetails partDetails = new PartDetails();
List <PartDetails> partDetailsCollection = new List <PartDetails>();
ServiceOrderLine serviceOrderLine = new ServiceOrderLine();
List <ServiceOrderLine> serviceOrderLineList = new List <ServiceOrderLine>();
List <Address> addressList = new List <Address>();
string userName = null;
userName = User.Identity.Name.ToString().Split('\\')[1];
try
{
if (HttpContext.Session != null)
{
if (Session["SiteID"] == null)
{
RedirectToAction("ServiceOrderWithHistory", "WorkOrder");
}
}
IEnumerable <Customer> customerCollection = customer.GetCustomers(User.Identity.Name.ToString().Split('\\')[1]);
customer.CustomerList = new SelectList(customerCollection, "CustomerAccount", "CustomerName", null);
serviceOrder.Customer = customer;
ViewData["CustomerList"] = customer.CustomerList;
woClassification.WOClassificationList = new SelectList(woClassificationCollection.AsEnumerable <WOClassification>(), "WOClassificationCode", "WOClassificationName", null);
serviceOrder.WOClassification = woClassification;
serviceTechnician.ServiceTechnicianList = new SelectList(serviceTechnicianCollection.AsEnumerable <ServiceTechnician>(), "ServiceTechnicianNo", "ServiceTechnicianName", null);
serviceOrder.ServiceTechnician = serviceTechnician;
serviceOrder.ServiceResponsible = serviceTechnician;
partDetails.PartDetailsList = new SelectList(partDetailsCollection.AsEnumerable <PartDetails>(), "ItemNumber", "ItemNumber", null);
ViewData["PartNumberList"] = partDetails.PartDetailsList;
serviceOrder.PartDetails = partDetails;
ViewData["ServiceOrderLine"] = serviceOrderLineList;
TempData["ServiceOrderLine"] = serviceOrderLineList;
serviceOrderLine.ServiceOrderLineList = serviceOrderLineList;
serviceOrder.ServiceOrderLine = serviceOrderLine;
ViewData["BillingAddress"] = addressList;
ViewData["ShippingAddress"] = addressList;
serviceOrder.BillingAddressList = addressList;
serviceOrder.ShippingAddressList = addressList;
ViewData["ServiceOrder"] = serviceOrder;
TempData.Keep();
}
catch (Exception ex)
{
TempData.Keep();
ExceptionLog.LogException(ex, userName);
}
return(View(serviceOrder));
}
public JsonResult GetOtherDetails(string customerAccount)
{
WOClassification woClassification = new WOClassification();
ServiceTechnician serviceTechnician = new ServiceTechnician();
PartDetails partDetails = new PartDetails();
ServiceOrder serviceOrder = new ServiceOrder();
ServiceOrderLine serviceOrderLine = new ServiceOrderLine();
string userName = null;
try
{
if (customerAccount != null)
{
userName = User.Identity.Name.ToString().Split('\\')[1];
List <Address> addressList = (new Address()).GetCustomerAddress(customerAccount, userName);
List <Address> addressShipping = (from item1 in addressList
where item1.IsShipping == "1"
select item1).ToList <Address>();
List <Address> addressBilling = (from item1 in addressList
where item1.IsBilling == "1"
select item1).ToList <Address>();
if (addressShipping.Count >= 1)
{
for (int i = 0; i <= addressShipping.Count - 1; i++)
{
if (i == 0)
{
addressShipping[i].IsSelected = "checked";
}
else
{
addressShipping[i].IsSelected = null;
}
}
serviceOrder.ShippingAddressList = addressShipping;
}
//ViewData["BillingAddress"] = addressBilling;
//ViewData["ShippingAddress"] = addressShipping;
TempData["CustomerAccount"] = customerAccount;
serviceOrder.BillingAddressList = addressBilling;
IEnumerable <WOClassification> woClassificationCollection = woClassification.GetWOClassification(User.Identity.Name.ToString().Split('\\')[1]);
woClassification.WOClassificationList = new SelectList(woClassificationCollection, "WOClassificationCode", "WOClassificationName", null);
//ViewData["WOClassificationList"] = woClassification.WOClassificationList;
serviceOrder.WOClassification = woClassification;
IEnumerable <ServiceTechnician> serviceTechnicianCollection = serviceTechnician.GetTechnicians(User.Identity.Name.ToString().Split('\\')[1]);
serviceTechnician.ServiceTechnicianList = new SelectList(serviceTechnicianCollection, "ServiceTechnicianNo", "ServiceTechnicianName", null);
//ViewData["ServiceTechnicianList"] = serviceTechnician.ServiceTechnicianList;
//ViewData["ServiceResponsibleList"] = serviceTechnician.ServiceTechnicianList;
serviceOrder.ServiceTechnician = serviceTechnician;
serviceOrder.ServiceResponsible = serviceTechnician;
IEnumerable <PartDetails> partDetailsCollection = partDetails.GetItemNumbers(User.Identity.Name.ToString().Split('\\')[1]);
//partDetails.PartDetailsList1 = partDetailsCollection.ToList<PartDetails>();
partDetails.PartDetailsList = new SelectList(partDetailsCollection, "ItemNumber", "ItemNumber", null);
ViewData["PartNumberList"] = partDetails.PartDetailsList;
serviceOrder.PartDetails = partDetails;
serviceOrderLine.ServiceOrderLineList = new List <ServiceOrderLine>();
serviceOrder.ServiceOrderLine = serviceOrderLine;
}
TempData.Keep();
}
catch (Exception ex)
{
TempData.Keep();
ExceptionLog.LogException(ex, userName);
}
return(Json(serviceOrder, JsonRequestBehavior.AllowGet));
}
// GET: /ServiceOrderProcess/
public ActionResult ServiceOrderProcess()
{
string userName = "";
TempData["ServiceOrderId"] = Session["SID"];
TempData["WorkOrderSiteId"] = Session["SiteID"];
userName = User.Identity.Name.ToString().Split('\\')[1];
SerivceOrderPartLine serivceOrderPartLineObject = new SerivceOrderPartLine();
ServiceOrderLine serivceOrderLineObject = new ServiceOrderLine();
List <ServiceOrderLine> serviceOrderLineList = new List <ServiceOrderLine>();
try
{
if (HttpContext.Session != null)
{
if (Session["SiteID"] == null)
{
return(RedirectToAction("ServiceOrderWithHistory"));
}
}
if (TempData["ServiceOrderId"] != null)
{
serivceOrderLineObject.ServiceOrderLineList = serviceOrderLineList;
serivceOrderPartLineObject.ServiceOrderLine = serivceOrderLineObject;
FailureCode failureCodeObject = new FailureCode();
IEnumerable <FailureCode> failureCodeCollection = failureCodeObject.GetFailureCode(userName);
failureCodeObject.FailureCodeList = new SelectList(failureCodeCollection, "FailureCodeNo", "FailureDescription", null);
ViewData["FailureCodeList"] = failureCodeObject.FailureCodeList;
PartDetails partDetails = new PartDetails();
partDetails.PartDetailsList = new SelectList(partDetails.GetItemNumbers(userName), "ItemNumber", "ItemNumber", null);
ViewData["PartNumberList"] = partDetails.PartDetailsList;
LineProperty LinePropertyObject = new LineProperty();
IEnumerable <LineProperty> LinePropertyCollection = LinePropertyObject.GetLineProperty(userName);
LinePropertyObject.LinePropertyList = new SelectList(LinePropertyCollection, "LinePropertyCode", "LinePropertyDescription", null);
ViewData["LinePropertyList"] = LinePropertyObject.LinePropertyList;
IEnumerable <SerivceOrderPartLine> serviceOrderPartLineCollection = null;
serviceOrderPartLineCollection = serivceOrderPartLineObject.GetSerialNumberByServiceOrder(TempData["ServiceOrderId"].ToString(), userName);
serivceOrderPartLineObject.ServiceOrderPartLineList = new SelectList(serviceOrderPartLineCollection, "ServiceObjectRelation", "SerialNumber", null);
ViewData["SORelationList"] = serivceOrderPartLineObject.ServiceOrderPartLineList;
ViewData["WorkSerialNumberList"] = serivceOrderPartLineObject.ServiceOrderPartLineList;
ViewData["ServiceOrderPartLines"] = GetServiceOrderPartLinesByServiceOrderID(TempData["ServiceOrderId"].ToString());
ServiceOrder ServiceOrder = new ServiceOrder();
ServiceOrder.ServiceOrderList = GetServiceOrderDetailsByServiceOrder(TempData["WorkOrderSiteId"].ToString(), TempData["ServiceOrderId"].ToString());
serivceOrderPartLineObject.ServiceOrders = ServiceOrder;
ViewData["ServiceOrderLineinProcess"] = serivceOrderPartLineObject.ServiceOrders.ServiceOrderList;
ServiceTechnician serviceTechnician = new ServiceTechnician();
IEnumerable <ServiceTechnician> serviceTechnicianCollection = null;
serviceTechnicianCollection = serviceTechnician.GetTechnicians(userName);
if (!String.IsNullOrEmpty(TempData["Technician"].ToString()))
{
serviceTechnician.ServiceTechnicianList = new SelectList(serviceTechnicianCollection, "ServiceTechnicianNo", "ServiceTechnicianName", serviceTechnicianCollection.First <ServiceTechnician>().ServiceTechnicianNo = TempData["Technician"].ToString());
}
else
{
serviceTechnician.ServiceTechnicianList = new SelectList(serviceTechnicianCollection, "ServiceTechnicianNo", "ServiceTechnicianName", null);
}
ViewData["ServiceTechnicianLoadList"] = serviceTechnician.ServiceTechnicianList;
Site site = new Site();
IEnumerable <Site> siteCollection = null;
siteCollection = site.GetSites(userName);
if (!String.IsNullOrEmpty(TempData["WorkOrderSiteId"].ToString()))
{
site.SiteList = new SelectList(siteCollection, "SiteId", "SiteName", siteCollection.First <Site>().SiteID = TempData["WorkOrderSiteId"].ToString());
}
else
{
site.SiteList = new SelectList(siteCollection, "SiteId", "SiteName", siteCollection.First <Site>().SiteID);
}
ViewData["siteList"] = site.SiteList;
ViewData["TranasactionTypes"] = TransactionType.GetTransactionTypes();
TempData.Keep();
}
else
{
return(RedirectToAction("ServiceOrderWithHistory"));
// return View("ServiceOrderWithHistory", serivceOrderPartLineObject);
//throw new Exception("Select the service order number in Service Order with history page");
}
}
catch (Exception ex)
{
TempData.Keep();
ExceptionLog.LogException(ex, userName);
// throw new Exception("Select the service order number in Service Order with history page");
//return RedirectToAction("ServiceOrderWithHistory");
// return Json("Select the service order number in Service Order with history page",JsonRequestBehavior.AllowGet);
}
return(View(serivceOrderPartLineObject));
}
public void WritePointerData(Vault vault, BinaryWriter bw)
{
PartDetails.WritePointerData(vault, bw);
_offerIdText.WritePointerData(vault, bw);
}
public void AddPointers(Vault vault)
{
PartDetails.AddPointers(vault);
_offerIdText.AddPointers(vault);
}
