public int UpdateValuablesItemDetails(int ID, ValuableItemDetails valuableItemModel)
{
int icount = 0;
try
{
MasterDataEntities db = new MasterDataEntities();
icount = db.IT_CC_UPDATE_ValuablesItemDetails(ID, valuableItemModel.ValuablesDescription);
}
catch (Exception xp)
{
}
finally
{
}
return(icount);
}
public int InsertValuablesItemDetails(ValuableItemDetails valuableItemModel)
{
int details = 0;
try
{
MasterDataEntities db = new MasterDataEntities();
details = db.IT_CC_Insert_ValuablesItems(valuableItemModel.PcId, valuableItemModel.TrId, valuableItemModel.HomeID, valuableItemModel.ValuablesItemID, valuableItemModel.ValuablesDescription, valuableItemModel.ValuablesSumInsured);
}
catch (Exception xp)
{
}
finally
{
}
return(details);
}
public ValuableItemDetailsRef GetValuablesItemDetails(int Id)
{
ValuableItemDetailsRef valuableItemRef = new ValuableItemDetailsRef();
try
{
ValuableItemDetails valuableItemModel = new ValuableItemDetails();
MasterDataEntities db = new MasterDataEntities();
var str = db.IT_CC_GET_ValuablesItemDetails(Id).ToList();
if (str.Count > 0)
{
foreach (var item in str)
{
valuableItemModel = new ValuableItemDetails();
valuableItemModel.ValuablesSumInsured = item.ValuablesSumInsured;
valuableItemModel.ValuablesDescription = item.ValuablesDescription;
valuableItemRef.ValuableItemDetailsData = valuableItemModel;
valuableItemRef.Status = "Success";
}
}
else
{
valuableItemRef.ErrorMessage.Add("No Data Available");
valuableItemRef.Status = "Failure";
}
}
catch (Exception xp)
{
valuableItemRef.ErrorMessage.Add(xp.Message);
valuableItemRef.Status = "Failure";
}
finally
{
}
return(valuableItemRef);
}
// POST: api/ValuableItemDetails
public ValuableItemDetailsRef Post([FromBody] ValuableItemDetails value)
{
ValuableItemDetailsRef valuableItemDetailsRef = new ValuableItemDetailsRef();
ValuableItemsDetailsClass valuableItemClass = new ValuableItemsDetailsClass();
try
{
List <string> Errors = new List <string>();
valuableItemDetailsRef.ErrorMessage = new List <string>();
if (value.PcId == null || value.PcId <= 0)
{
Errors.Add("PolicyID is required");
}
if (value.TrId == null || value.TrId <= 0)
{
Errors.Add("TransactionID is required");
}
if (value.HomeID == null || value.HomeID <= 0)
{
Errors.Add("HomeID is required");
}
if (string.IsNullOrWhiteSpace(value.ValuablesDescription))
{
Errors.Add("Description is required");
}
if (value.ValuablesSumInsured == null || value.ValuablesSumInsured <= 0)
{
Errors.Add("SumInsured is required");
}
if (value.ValuablesItemID == null || value.ValuablesItemID <= 0)
{
Errors.Add("ValuableItemID is required");
}
if (Errors != null && Errors.Count() > 0)
{
valuableItemDetailsRef.Status = "Failure";
valuableItemDetailsRef.ErrorMessage = Errors;
return(valuableItemDetailsRef);
}
else
{
int?result = valuableItemClass.InsertValuablesItemDetails(value);
if (result.HasValue && result > 0)
{
valuableItemDetailsRef.Status = "Success";
valuableItemDetailsRef.ValuableItemDetailsData.ValuablesItemID = result.Value;
}
else if (result.HasValue && result == (int)ValuableResult.Exception)
{
valuableItemDetailsRef.Status = "Failure";
valuableItemDetailsRef.ErrorMessage.Add("Failed to insert.");
}
}
}
catch (Exception xp)
{
valuableItemDetailsRef.Status = "Failure";
valuableItemDetailsRef.ErrorMessage.Add(xp.Message);
}
finally
{
}
return(valuableItemDetailsRef);
}
