public CommonResponse AddUpdateChildFgPartNo(addChildfgPartNoDet data)
{
CommonResponse obj = new CommonResponse();
try
{
var check = db.UnitworkccsTblchildfgpartno.Where(m => m.ChildFgpartId == data.childFgpartId && m.IsDeleted == 0).FirstOrDefault();
if (check == null)
{
UnitworkccsTblchildfgpartno UnitworkccsTblchildfgpartnodet = new UnitworkccsTblchildfgpartno();
UnitworkccsTblchildfgpartnodet.ChildFgpartId = data.childFgpartId;
UnitworkccsTblchildfgpartnodet.ChildFgPartNo = data.fgPartNo;
UnitworkccsTblchildfgpartnodet.FgPartNo = data.fgPartNo;
UnitworkccsTblchildfgpartnodet.ChildPartNoDesc = data.childPartNoDesc;
UnitworkccsTblchildfgpartnodet.FgPartDesc = db.UnitworkccsTblfgandcellallocation.Where(m => m.PartNo == data.fgPartNo).Select(m => m.PartName).FirstOrDefault();
UnitworkccsTblchildfgpartnodet.IsDeleted = 0;
UnitworkccsTblchildfgpartnodet.CreatedBy = 1;
UnitworkccsTblchildfgpartnodet.CreatedOn = DateTime.Now;
db.UnitworkccsTblchildfgpartno.Add(UnitworkccsTblchildfgpartnodet);
db.SaveChanges();
obj.isStatus = true;
obj.response = ResourceResponse.AddedSuccessMessage;
}
else
{
//check.ChildFgpartId = data.ChildFgpartId;
check.ChildFgPartNo = data.childFgPartNo;
check.FgPartNo = data.fgPartNo;
check.FgPartDesc = db.UnitworkccsTblfgandcellallocation.Where(m => m.PartNo == data.fgPartNo).Select(m => m.PartName).FirstOrDefault();
check.ChildPartNoDesc = data.childPartNoDesc;
check.ModifiedBy = 2;
check.ModifiedOn = DateTime.Now;
db.SaveChanges();
obj.isStatus = true;
obj.response = ResourceResponse.UpdatedSuccessMessage;
}
}
catch (Exception e)
{
log.Error(e); if (e.InnerException != null)
{
log.Error(e.InnerException.ToString());
}
obj.isStatus = false;
obj.response = ResourceResponse.FailureMessage;
}
return(obj);
}
/// <summary>
/// Add Child Fg Part No
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public CommonResponse AddChildFgPartNo(CustomChildPartNo data)
{
CommonResponse obj = new CommonResponse();
try
{
var check = db.UnitworkccsTblchildfgpartno.Where(m => m.ChildFgpartId == data.childFgPartId && m.IsDeleted == 0).FirstOrDefault();
if (check == null)
{
UnitworkccsTblchildfgpartno UnitworkccsTblchildfgpartno = new UnitworkccsTblchildfgpartno();
UnitworkccsTblchildfgpartno.ChildFgPartNo = data.childFgPartNo;
UnitworkccsTblchildfgpartno.ChildPartNoDesc = data.childPartNoDesc;
UnitworkccsTblchildfgpartno.FgPartNo = data.fgPartNo;
UnitworkccsTblchildfgpartno.FgPartDesc = data.fgPartDesc;
UnitworkccsTblchildfgpartno.IsDeleted = 0;
UnitworkccsTblchildfgpartno.CreatedOn = DateTime.Now;
db.UnitworkccsTblchildfgpartno.Add(UnitworkccsTblchildfgpartno);
db.SaveChanges();
obj.isStatus = true;
obj.response = ResourceResponse.AddedSuccessMessage;
}
else
{
check.ChildFgPartNo = data.childFgPartNo;
check.ChildPartNoDesc = data.childPartNoDesc;
check.FgPartNo = data.fgPartNo;
check.FgPartDesc = data.fgPartDesc;
check.IsDeleted = 0;
check.CreatedOn = DateTime.Now;
db.SaveChanges();
obj.isStatus = true;
obj.response = ResourceResponse.UpdatedSuccessMessage;
}
}
catch (Exception e)
{
log.Error(e); if (e.InnerException != null)
{
log.Error(e.InnerException.ToString());
}
obj.isStatus = false;
obj.response = ResourceResponse.FailureMessage;
}
return(obj);
}
/// <summary>
/// Upload Child Fg Part No
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public CommonResponse UploadChildFgPartNo(List <UploadChildPartNo> data)
{
CommonResponse obj = new CommonResponse();
try
{
var check = db.UnitworkccsTblchildfgpartno.Where(m => m.IsDeleted == 0).ToList();
db.RemoveRange(check);
db.SaveChanges();
foreach (var item in data)
{
UnitworkccsTblchildfgpartno UnitworkccsTblchildfgpartno = new UnitworkccsTblchildfgpartno();
UnitworkccsTblchildfgpartno.ChildFgPartNo = item.childFgPartNo;
UnitworkccsTblchildfgpartno.ChildPartNoDesc = item.childPartNoDesc;
UnitworkccsTblchildfgpartno.FgPartNo = item.fgPartNo;
UnitworkccsTblchildfgpartno.FgPartDesc = item.fgPartDesc;
UnitworkccsTblchildfgpartno.IsDeleted = 0;
UnitworkccsTblchildfgpartno.CreatedOn = DateTime.Now;
db.UnitworkccsTblchildfgpartno.Add(UnitworkccsTblchildfgpartno);
db.SaveChanges();
obj.isStatus = true;
obj.response = ResourceResponse.AddedSuccessMessage;
}
}
catch (Exception e)
{
log.Error(e); if (e.InnerException != null)
{
log.Error(e.InnerException.ToString());
}
obj.isStatus = false;
obj.response = ResourceResponse.FailureMessage;
}
return(obj);
}
