public int UpdateMessr(TblMessrs model)
        {
            try
            {
                var recordToUpdateInDb = dbContext.TblMessrs.Where(x => x.Id == model.Id).FirstOrDefault();
                if (recordToUpdateInDb != null)
                {
                    var duplicateNameRecord = dbContext.TblMessrs.Where(x => x.Id != model.Id &&
                                                                        (x.PhoneNo == model.PhoneNo ||
                                                                         x.Cnic == model.Cnic)).FirstOrDefault();

                    if (duplicateNameRecord != null)
                    {
                        return(0);
                    }
                    else
                    {
                        recordToUpdateInDb.Name    = model.Name;
                        recordToUpdateInDb.PhoneNo = model.PhoneNo;
                        recordToUpdateInDb.Cnic    = model.Cnic;
                        return(dbContext.SaveChanges());
                    }
                }
                else
                {
                    return(0);
                }
            }
            catch (Exception ex)
            {
                StaticHelper.LogException(path: up.GetLogFilePath(), errorMessage: ex.Message, methodName: $"Repository name: {nameof(ReceiptRepository)} - Method name:  {nameof(UpdateMessr)}", stackTrace: ex.StackTrace);
                return(0);
            }
        }
示例#2
0
 public IActionResult UpdateMessrs(TblMessrs model)
 {
     try
     {
         return(Ok(rp.UpdateMessr(model)));
     }
     catch (Exception ex)
     {
         Exceptions(ex);
         return(StatusCode(500));
     }
 }
 public int UpdateMessr(TblMessrs model)
 {
     try
     {
         return(receipt.UpdateMessr(model));
     }
     catch (Exception ex)
     {
         StaticHelper.LogException(path: up.GetLogFilePath(), errorMessage: ex.Message, methodName: $"Class Name: {nameof(ReceiptPresenter)} - Method name:  {nameof(UpdateMessr)}", stackTrace: ex.StackTrace);
         return(0);
     }
 }
 public int CreateMessr(TblMessrs model)
 {
     try
     {
         var IsMessrExists = dbContext.TblMessrs.Where(x => x.PhoneNo == model.PhoneNo || x.Cnic == model.Cnic).FirstOrDefault();
         if (IsMessrExists != null)
         {
             return(0);
         }
         else
         {
             dbContext.Add(model);
             return(dbContext.SaveChanges());
         }
     }
     catch (Exception ex)
     {
         StaticHelper.LogException(path: up.GetLogFilePath(), errorMessage: ex.Message, methodName: $"Repository name: {nameof(ReceiptRepository)} - Method name:  {nameof(CreateMessr)}", stackTrace: ex.StackTrace);
         return(0);
     }
 }