public async Task <IHttpActionResult> PostTRN_SchemeAuditParent(TRN_SchemeAuditParent tRN_SchemeAuditParent)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var Number = db.TRN_SchemeAuditParent.Where(x => x.Number == tRN_SchemeAuditParent.Number).Select(x => x.Number);
//if (tRN_SchemeAuditParent.Number.Substring(0, 3) == "204")
//{
// db.TRN_SchemeAuditParent.Add(tRN_SchemeAuditParent);
// await db.SaveChangesAsync();
//}
if (Number.Count() > 0)
{
return(BadRequest("Data Allready added"));
}
else
{
db.TRN_SchemeAuditParent.Add(tRN_SchemeAuditParent);
await db.SaveChangesAsync();
}
return(CreatedAtRoute("DefaultApi", new { id = tRN_SchemeAuditParent.Id }, tRN_SchemeAuditParent));
// return BadRequest("Data Added Successfuly");
}
public IHttpActionResult PutTRN_SchemeAuditParent(int id, TRN_SchemeAuditParent tRN_SchemeAuditParent)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != tRN_SchemeAuditParent.Id)
{
return(BadRequest());
}
db.Entry(tRN_SchemeAuditParent).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!TRN_SchemeAuditParentExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult GetTRN_SchemeAuditParent(int id)
{
TRN_SchemeAuditParent tRN_SchemeAuditParent = db.TRN_SchemeAuditParent.Find(id);
if (tRN_SchemeAuditParent == null)
{
return(NotFound());
}
return(Ok(tRN_SchemeAuditParent));
}
public IHttpActionResult DeleteTRN_SchemeAuditParent(int id)
{
TRN_SchemeAuditParent tRN_SchemeAuditParent = db.TRN_SchemeAuditParent.Find(id);
if (tRN_SchemeAuditParent == null)
{
return(NotFound());
}
db.TRN_SchemeAuditParent.Remove(tRN_SchemeAuditParent);
db.SaveChanges();
return(Ok(tRN_SchemeAuditParent));
}
public string Post(TRN_SchemeAuditParent _TRN_SchemeAuditParent, string transactionType)
{
string ret = string.Empty;
try
{
Parameters[] colparameters = new Parameters[40] {
new Parameters("@paramId", _TRN_SchemeAuditParent.Id, DbType.Int32, ParameterDirection.Input),
new Parameters("@paramNumber", _TRN_SchemeAuditParent.Number, DbType.String, ParameterDirection.Input),
new Parameters("@paramUserId", _TRN_SchemeAuditParent.UserId, DbType.Int32, ParameterDirection.Input),
new Parameters("@paramOutlateName", _TRN_SchemeAuditParent.OutlateName, DbType.String, ParameterDirection.Input),
new Parameters("@paramDate", _TRN_SchemeAuditParent.Date, DbType.Date, ParameterDirection.Input),
new Parameters("@paramGccCode", _TRN_SchemeAuditParent.GccCode, DbType.Int32, ParameterDirection.Input),
new Parameters("@paramRetailSellerName", _TRN_SchemeAuditParent.RetailSellerName, DbType.String, ParameterDirection.Input),
new Parameters("@paramMobileNumber", _TRN_SchemeAuditParent.MobileNumber, DbType.String, ParameterDirection.Input),
new Parameters("@paramOutlateTypeId", _TRN_SchemeAuditParent.OutlateTypeId, DbType.Int32, ParameterDirection.Input),
new Parameters("@paramVisitedDate", _TRN_SchemeAuditParent.VisitedDate, DbType.Date, ParameterDirection.Input),
new Parameters("@paramDistributorName", _TRN_SchemeAuditParent.DistributorName, DbType.String, ParameterDirection.Input),
new Parameters("@paramAsmId", _TRN_SchemeAuditParent.AsmId, DbType.Int32, ParameterDirection.Input),
new Parameters("@paramAicId", _TRN_SchemeAuditParent.AicId, DbType.Int32, ParameterDirection.Input),
new Parameters("@paramOutlateAddress", _TRN_SchemeAuditParent.OutlateAddress, DbType.String, ParameterDirection.Input),
new Parameters("@paramIsKnowenAboutScheme", _TRN_SchemeAuditParent.IsKnowenAboutScheme, DbType.Int32, ParameterDirection.Input),
new Parameters("@paramSchemeDetails", _TRN_SchemeAuditParent.SchemeDetails, DbType.String, ParameterDirection.Input),
new Parameters("@paramSchemeMediaTypeId", _TRN_SchemeAuditParent.SchemeMediaTypeId, DbType.Int32, ParameterDirection.Input),
new Parameters("@paramIsFacilitatedByScheme", _TRN_SchemeAuditParent.IsFacilitatedByScheme, DbType.Int32, ParameterDirection.Input),
new Parameters("@paramDateOfScheme", _TRN_SchemeAuditParent.DateOfScheme, DbType.Date, ParameterDirection.Input),
new Parameters("@paramIsWrittenRecordAvailable", _TRN_SchemeAuditParent.IsWrittenRecordAvailable, DbType.Int32, ParameterDirection.Input),
new Parameters("@paramLatestChallanDate", _TRN_SchemeAuditParent.LatestChallanDate, DbType.Date, ParameterDirection.Input),
new Parameters("@paramChallanAmount", _TRN_SchemeAuditParent.ChallanAmount, DbType.String, ParameterDirection.Input),
new Parameters("@paramDoesGotAnyChallan", _TRN_SchemeAuditParent.DoesGotAnyChallan, DbType.Int32, ParameterDirection.Input),
new Parameters("@paramChallanTypeId", _TRN_SchemeAuditParent.ChallanTypeId, DbType.Int32, ParameterDirection.Input),
new Parameters("@paramDoesExpiredProductAvailable", _TRN_SchemeAuditParent.DoesExpiredProductAvailable, DbType.Int32, ParameterDirection.Input),
new Parameters("@paramDoesSatisfiedWithSallesOfficer", _TRN_SchemeAuditParent.DoesSatisfiedWithSallesOfficer, DbType.Int32, ParameterDirection.Input),
new Parameters("@paramDoesSatisfiedWithProductOrderAndService", _TRN_SchemeAuditParent.DoesSatisfiedWithProductOrderAndService, DbType.Int32, ParameterDirection.Input),
new Parameters("@paramSallesOfficerVisitingDay", _TRN_SchemeAuditParent.SallesOfficerVisitingDay, DbType.Int32, ParameterDirection.Input),
new Parameters("@paramDoesGotLatestDiscountOffer", _TRN_SchemeAuditParent.DoesGotLatestDiscountOffer, DbType.Int32, ParameterDirection.Input),
new Parameters("@paramWillGetAnyDiscountOfferFromDistributor", _TRN_SchemeAuditParent.WillGetAnyDiscountOfferFromDistributor, DbType.Int32, ParameterDirection.Input),
new Parameters("@paramDoesCocaColaLabelAvailable", _TRN_SchemeAuditParent.DoesCocaColaLabelAvailable, DbType.Int32, ParameterDirection.Input),
new Parameters("@paramIsGccCodeAvailable", _TRN_SchemeAuditParent.IsGccCodeAvailable, DbType.Int32, ParameterDirection.Input),
new Parameters("@paramCommentsType", _TRN_SchemeAuditParent.CommentsType, DbType.Int32, ParameterDirection.Input),
new Parameters("@paramComments", _TRN_SchemeAuditParent.Comments, DbType.Int32, ParameterDirection.Input),
new Parameters("@paramCommentDetails", _TRN_SchemeAuditParent.CommentDetails, DbType.String, ParameterDirection.Input),
new Parameters("@paramCreatorName", _TRN_SchemeAuditParent.CreatorName, DbType.Byte, ParameterDirection.Input),
new Parameters("@paramCreationDate", _TRN_SchemeAuditParent.CreationDate, DbType.DateTime, ParameterDirection.Input),
new Parameters("@paramModifierName", _TRN_SchemeAuditParent.ModifierName, DbType.Byte, ParameterDirection.Input),
new Parameters("@paramModificationDate", _TRN_SchemeAuditParent.ModificationDate, DbType.DateTime, ParameterDirection.Input),
new Parameters("@paramTransactionType", transactionType, DbType.String, ParameterDirection.Input)
};
dbExecutor.ManageTransaction(TransactionType.Open);
ret = dbExecutor.ExecuteScalarString(true, CommandType.StoredProcedure, "wsp_TRN_SchemeAuditParent_Post", colparameters, true);
dbExecutor.ManageTransaction(TransactionType.Commit);
}
catch (DBConcurrencyException except)
{
dbExecutor.ManageTransaction(TransactionType.Rollback);
throw except;
}
catch (Exception ex)
{
dbExecutor.ManageTransaction(TransactionType.Rollback);
throw ex;
}
return(ret);
}
