/// <summary> /// Created By: HytechPro /// Created Date: 12-06-2015 /// Modified By: /// Modified Date: /// Objective:This method will save new data in Car_Project. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnAddnewProject_Click(object sender, EventArgs e) { CAR_Project objCarProject = new CAR_Project { ProjectID = txtAddProjectId.Text, ShipName = txtAddShipName.Text, HullNumber = txtAddHullNumber.Text, ContractPONumber = txtAddContract.Text }; ECRFEntities context = new ECRFEntities(); try { context.AddToCAR_Project(objCarProject); context.SaveChanges(); BindProjectGrid(); } catch (Exception ex) { ErrorLog.WriteErrorLog("CAR", "CAR_Create.aspx", "btnAddnewProject_Click", ex.Message); } ModalPopupExtender.Show(); clearControlsOfProjectPopUpExtender(); }
/// <summary> /// Created By: HytechPro /// Created Date: 26-06-2015 /// Modified By: /// Modified Date: /// Objective:This method will return dbkey(primary key) of car from database. /// </summary> /// <param name="strCarType"></param> /// <param name="year"></param> /// <param name="carNumber"></param> /// <returns></returns> private int GetCarDbKey(string strCarType, int year, int carNumber) { ECRFEntities context = new ECRFEntities(); var dbkeyCar = context.CAR.Where(t => t.Type == strCarType && t.CarNumber == carNumber && t.DateIssued.Value.Year == year); int intCarDbKey = dbkeyCar.FirstOrDefault().DBKey; return intCarDbKey; }
/// <summary> /// Created By: HytechPro /// Created Date: 26-06-2015 /// Modified By: /// Modified Date: /// Objective:This method will check for duplicate car number before saving car to database. /// </summary> /// <param name="carNumber"></param> /// <param name="carType"></param> /// <param name="year"></param> /// <returns></returns> private bool IsDuplicateCar(int carNumber, string carType, int year) { bool blFlagCarNumber = false; ECRFEntities context = new ECRFEntities(); var car = context.CAR.Where(t => t.Type == carType && t.CarNumber == carNumber && t.DateIssued.Value.Year == year); if (car.Count() > 0) blFlagCarNumber = true; return blFlagCarNumber; }
/// <summary> /// Created By: HytechPro /// Created Date: 23-06-2015 /// Modified By: /// Modified Date: /// Objective:This method will return dbkey from database for assigne name on the basis of division id and assignee name. /// </summary> /// <param name="divId"></param> /// <param name="AssigneeName"></param> /// <returns></returns> private int? GetAssigneeDbKey(int? divId, string AssigneeName) { ECRFEntities context = new ECRFEntities(); int? intDbkeyAssignee = null; var dbkey = context.CAR_DefaultAssigneeIssuedTo.Where(t => t.DivisionId == divId && t.Assignment == AssigneeName); if (dbkey.Count() > 0) intDbkeyAssignee = dbkey.FirstOrDefault().DBKey; return intDbkeyAssignee; }