/// <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;
}
