public Int32 insertCollectionLine(Models.TrnCollectionLine collectionLine)
{
try
{
Data.TrnCollectionLine newCollectionLine = new Data.TrnCollectionLine();
newCollectionLine.ORId = collectionLine.ORId;
newCollectionLine.BranchId = collectionLine.BranchId;
newCollectionLine.AccountId = collectionLine.AccountId;
newCollectionLine.ArticleId = collectionLine.ArticleId;
newCollectionLine.SIId = collectionLine.SIId;
newCollectionLine.Particulars = collectionLine.Particulars;
newCollectionLine.Amount = collectionLine.Amount;
newCollectionLine.PayTypeId = collectionLine.PayTypeId;
newCollectionLine.CheckNumber = collectionLine.CheckNumber;
newCollectionLine.CheckDate = Convert.ToDateTime(collectionLine.CheckDate);
newCollectionLine.CheckBank = collectionLine.CheckBank;
newCollectionLine.DepositoryBankId = collectionLine.DepositoryBankId;
newCollectionLine.IsClear = collectionLine.IsClear;
db.TrnCollectionLines.InsertOnSubmit(newCollectionLine);
db.SubmitChanges();
return(newCollectionLine.Id);
}
catch
{
return(0);
}
}
public HttpResponseMessage updateCollectionLine(String id, Models.TrnCollectionLine collectionLine)
{
try
{
var collectionLines = from d in db.TrnCollectionLines where d.Id == Convert.ToInt32(id) select d;
if (collectionLines.Any())
{
var updateCollectionLine = collectionLines.FirstOrDefault();
updateCollectionLine.ORId = collectionLine.ORId;
updateCollectionLine.BranchId = collectionLine.BranchId;
updateCollectionLine.AccountId = collectionLine.AccountId;
updateCollectionLine.ArticleId = collectionLine.ArticleId;
updateCollectionLine.SIId = collectionLine.SIId;
updateCollectionLine.Particulars = collectionLine.Particulars;
updateCollectionLine.Amount = collectionLine.Amount;
updateCollectionLine.PayTypeId = collectionLine.PayTypeId;
updateCollectionLine.CheckNumber = collectionLine.CheckNumber;
updateCollectionLine.CheckDate = Convert.ToDateTime(collectionLine.CheckDate);
updateCollectionLine.CheckBank = collectionLine.CheckBank;
updateCollectionLine.DepositoryBankId = collectionLine.DepositoryBankId;
updateCollectionLine.IsClear = collectionLine.IsClear;
db.SubmitChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound));
}
}
catch
{
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
}
