/// <summary>
///
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public CAS_ProductInfoVM CreateProductData(CAS_ProductInfoVM model)
{
try
{
using (_db = new CFT_DBEntities())
{
_cAS_ProductInfoVM = new CAS_ProductInfoVM();
CAS_ProductInfo productInfo = new CAS_ProductInfo();
productInfo.CAS_ProductId = model.CAS_ProductId;
productInfo.Business_Unit = model.Business_Unit;
productInfo.Project_Name = model.Project_Name;
productInfo.Customer_Name = model.Customer_Name;
productInfo.Customer_Email = model.Customer_Email;
productInfo.Customer_Phone = model.Customer_Phone;
productInfo.IEC_Contact = model.IEC_Contact;
productInfo.Project_Team = model.Project_Team;
productInfo.Function = model.Function;
productInfo.CreatedAt = model.CreatedAt;
productInfo.CreatedBy = model.CreatedBy;
productInfo.UpdateAt = model.UpdateAt;
productInfo.UpdateBy = model.UpdateBy;
productInfo.IsActive = model.IsActive;
productInfo.ISDeleted = model.ISDeleted;
productInfo.CAS_FeedbackData = GetCAS_FeedbackData(model);
_db.CAS_ProductInfo.Add(productInfo);
_db.SaveChanges();
_cAS_ProductInfoVM.Id = productInfo.Id;
return _cAS_ProductInfoVM;
}
}
catch (Exception ex)
{
return _cAS_ProductInfoVM;
}
}
public CAS_ProductInfoVM GetProductDataById(string id)
{
_cAS_ProductInfoVM = new CAS_ProductInfoVM();
try
{
using (_db = new CFT_DBEntities())
{
var getData = (from prod in _db.CAS_ProductInfo.Include("CAS_FeedbackData")
where prod.CAS_ProductId == id
select prod).FirstOrDefault();
_cAS_ProductInfoVM.Business_Unit = getData.Business_Unit;
_cAS_ProductInfoVM.CAS_FeedbackData = getData.CAS_FeedbackData;
_cAS_ProductInfoVM.CAS_ProductId = getData.CAS_ProductId;
_cAS_ProductInfoVM.CreatedAt = getData.CreatedAt;
_cAS_ProductInfoVM.CreatedBy = getData.CreatedBy;
_cAS_ProductInfoVM.Customer_Email = getData.Customer_Email;
_cAS_ProductInfoVM.Customer_Name = getData.Customer_Name;
_cAS_ProductInfoVM.Customer_Phone = getData.Customer_Phone;
_cAS_ProductInfoVM.Function = getData.Function;
_cAS_ProductInfoVM.Id = getData.Id;
_cAS_ProductInfoVM.IEC_Contact = getData.IEC_Contact;
_cAS_ProductInfoVM.IsActive = getData.IsActive;
_cAS_ProductInfoVM.ISDeleted = getData.ISDeleted;
_cAS_ProductInfoVM.Project_Name = getData.Project_Name;
_cAS_ProductInfoVM.Project_Team = getData.Project_Team;
_cAS_ProductInfoVM.UpdateAt = getData.UpdateAt;
_cAS_ProductInfoVM.UpdateBy = getData.UpdateBy;
_cAS_ProductInfoVM.CAS_FeedbackDataVM = ConvertToFeedBackDataVM(getData);
}
}
catch (Exception ex)
{
return _cAS_ProductInfoVM;
}
return _cAS_ProductInfoVM;
}
public void UpdateProductInfoAfterMailSent(string id)
{
try
{
using (_db = new CFT_DBEntities())
{
var getData = _db.CAS_ProductInfo
.Include("CAS_FeedbackData").Where(p => p.CAS_ProductId == id).FirstOrDefault();
foreach (var item in getData.CAS_FeedbackData)
{
item.Status = "MailSent";
item.UpdatedAt = DateTime.UtcNow;
item.UpdatedBy = "RC";
_db.SaveChanges();
}
}
}
catch (Exception ex)
{
}
}
public List<CAS_ProductInfoVM> GetAllProductData(SearchVM search, out int totalcount)
{
_cAS_ProductInfoVMList = new List<CAS_ProductInfoVM>();
_db = new CFT_DBEntities();
IEnumerable<CAS_ProductInfo> query = _db.CAS_ProductInfo.Include("CAS_FeedbackData").ToList();
totalcount = query.Count();
search.PageCurrentIndex = search.PageCurrentIndex <= 0 ? 0 : search.PageCurrentIndex;
query = query.Skip(search.PageCurrentIndex * search.PageSize).Take(search.PageSize);
search.PageCount =
Convert.ToInt32(Math.Ceiling((double)((double)(totalcount / (double)search.PageSize))));
var lists = query.Select((a => new CAS_ProductInfoVM()
{
Business_Unit = a.Business_Unit,
CAS_ProductId = a.CAS_ProductId,
CAS_FeedbackDataVM = ConvertToFeedBackDataVM(a),
Customer_Email = a.Customer_Email,
Customer_Name = a.Customer_Name,
Customer_Phone = a.Customer_Phone,
Function = a.Function,
Id = a.Id,
IEC_Contact = a.IEC_Contact,
Project_Name = a.Project_Name,
Project_Team = a.Project_Team,
CreatedAt = a.CreatedAt,
CreatedBy = a.CreatedBy,
UpdateAt = a.UpdateAt,
UpdateBy = a.UpdateBy,
IsActive = a.IsActive,
ISDeleted = a.ISDeleted
}));
List<CAS_ProductInfoVM> listitems = lists.ToList();
return listitems;
}
