Entity Framework - Validations

Riddhi Valecha

6y1.1k.NET

Dear Team,

I need help in validations in Entity Framework with Swagger.

For Example - If I do not put any values for inputs - Locationcode, drivercode, isactive and isapproved, then it should return all the records. But, here , it takes LocationCode input as "string" and searches the data where locationcode is "string". How do I overcome this ?

--------

For Saving data, I need to make all the inputs compulsory.

Here, how do I make all the inputs compulsory ? and give user-friendly messages that - LocationCode is compulsory?

Please guide on this ..

38 Replies

Know the answer? Post it — somebody with the same question will find it here.

Riddhi Valecha6y ago
Hello sir ...
DriverCode - it is column name of table Driver_Master

DriverCode - It is the Primary Key Column of the table.

So, user can update one row at a time.
Viswanatha Swamy6y ago
Riddhi,
Good afternoon. What is this DriveCode? Is this pointing to a different table? Could you please paste the complete error message? Many thanks.
DriverMaster = DBDriverMaster.Driver_Master.Where(e => e.DriveCode == DriverMasterUpdate.DriveCodeUpdate).ToList();
Riddhi Valecha6y ago
[Route("DriverUpdate")]
[HttpPost]
public IActionResult DriverUpdate(DriverMasterModelUpdate rEQDriverMasterModelUpdate)
{
Response responseUpdate = new Response();
try
{
responseUpdate.Code = (int)HttpStatusCode.OK;
responseUpdate.Message = new DAL.DriverMaster ().DriverUpdate (rEQDriverMasterModelUpdate);
}
catch
{
throw;
}
return StatusCode(responseUpdate.Code, responseUpdate);
}
---------------------
public class DriverMaster
{
public string DriverUpdate(DriverMasterModelUpdate DriverMasterUpdate)
{
string ResponseUpdateDriver = string.Empty;
try
{
List DriverMaster = new List();
DriverMasterModel DriverMasterReq = new DriverMasterModel();
using (DriverMasterDbContext DBDriverMaster = new DriverMasterDbContext())
{
if(DriverMasterUpdate.DriveCodeUpdate.ToLower() != "string" || DriverMasterUpdate.DriveCodeUpdate.Length > 0)
{
DriverMaster = DBDriverMaster.Driver_Master.Where(e => e.DriveCode == DriverMasterUpdate.DriveCodeUpdate).ToList();
if(DriverMaster.Count > 0)
{
bool isact; int isactint;
bool isapp; int isappint;
if(DriverMasterUpdate.LocationCodeUpdate.ToLower() != "string" || DriverMasterUpdate.LocationCodeUpdate.Length > 0)
DriverMaster[0].LocationCode = DriverMasterUpdate.LocationCodeUpdate;
if (DriverMasterUpdate.DriveNameUpdate.ToLower() != "string" || DriverMasterUpdate.DriveNameUpdate.Length > 0)
DriverMaster[0].DriveName = DriverMasterUpdate.DriveNameUpdate ;
if (DriverMasterUpdate.MobileNumberUpdate.ToLower() != "string" || DriverMasterUpdate.MobileNumberUpdate .Length > 0)
DriverMaster[0].MobileNumber = DriverMasterUpdate.MobileNumberUpdate;
if(DriverMasterUpdate.LicenseNumberUpdate.ToLower() != "string" || DriverMasterUpdate.LicenseNumberUpdate.Length > 0)
DriverMaster[0].LicenseNumber = DriverMasterUpdate.LicenseNumberUpdate;
if (DriverMasterUpdate.ShiftFromTimeUpdate.ToLower() != "string" || DriverMasterUpdate.ShiftFromTimeUpdate.Length > 0)
DriverMaster[0].ShiftFromTime = DriverMasterUpdate.ShiftFromTimeUpdate;
if (DriverMasterUpdate.ShiftToTimeUpdate.ToLower() != "string" || DriverMasterUpdate.ShiftToTimeUpdate.Length > 0)
DriverMaster[0].ShiftToTime = DriverMasterUpdate.ShiftToTimeUpdate;
isact = int.TryParse(DriverMasterUpdate.IsActiveUpdate.ToString(), out isactint);
if (DriverMasterUpdate.IsActiveUpdate.ToString().Length == 1 && isact == true)
DriverMaster[0].IsActive = DriverMasterUpdate.IsActiveUpdate;
isapp = int.TryParse(DriverMasterUpdate.IsApproveUpdate.ToString(), out isappint);
if(DriverMasterUpdate.IsApproveUpdate.ToString().Length == 1 && isapp == true)
DriverMaster[0].IsApprove = DriverMasterUpdate.IsApproveUpdate;
if (DriverMasterUpdate.UpdateBYUpdate.ToLower() != "string" || DriverMasterUpdate.UpdateBYUpdate.Length > 0)
DriverMaster[0].UpdateBY = DriverMasterUpdate.UpdateBYUpdate;
if (DriverMasterUpdate.VendorCodeUpdate.ToLower() != "string" || DriverMasterUpdate.VendorCodeUpdate.Length > 0)
DriverMaster[0].VendorCode = DriverMasterUpdate.VendorCodeUpdate;
DriverMaster[0].Updatedate = DateTime.Now;
DBDriverMaster.Driver_Master.Update(DriverMaster[0]);
DBDriverMaster.SaveChanges();
ResponseUpdateDriver = "Driver Name " + " " + DriverMasterUpdate.DriveNameUpdate + " " + " is successfully updated.";
}
else
{
ResponseUpdateDriver = "There is no record with Driver Code - " + DriverMasterUpdate.DriveCodeUpdate + ".";
}
}
else
{
ResponseUpdateDriver = "Driver Code is mandatory.";
}

}
}
catch (Exception)
{
throw;
}
return ResponseUpdateDriver;
}
}
-----------------
public class DriverMasterModelUpdate : Models.IValidation
{
[Required]
[MinLength(1, ErrorMessage = "Location Code is required.")]
public string LocationCodeUpdate { get; set; }
[Required]
[MinLength(1, ErrorMessage = "Driver Code is required.")]
public string DriveCodeUpdate { get; set; }
[Key]
[Required]
[MinLength(1, ErrorMessage = "Driver name is required.")]
public string DriveNameUpdate { get; set; }
[MinLength(10, ErrorMessage = "Mobile Number should be 10 numbers")]
public string MobileNumberUpdate { get; set; }
public DateTime DOJDate { get; set; }
[Required]
[MinLength(1, ErrorMessage = "License Number is required.")]
public string LicenseNumberUpdate { get; set; }
public DateTime LicenseExDateUpdate { get; set; }
[Required]
[MinLength(1, ErrorMessage = "Shift From Time is required.")]
public string ShiftFromTimeUpdate { get; set; }
[Required]
[MinLength(1, ErrorMessage = "Shift To Time is required.")]
public string ShiftToTimeUpdate { get; set; }
[Required]
[MaxLength(1,ErrorMessage = "Is Active is required.")]
public int IsActiveUpdate { get; set; }
[Required]
[MaxLength(1, ErrorMessage = "Is Approve is required.")]
public int IsApproveUpdate { get; set; }
public DateTime IsApproveDate { get;set; }
[Required]
[MinLength(1, ErrorMessage = "Update By is required.")]
public string UpdateBYUpdate { get; set; }
[Required]
[MinLength(1, ErrorMessage = "Vendor Code is required.")]
public string VendorCodeUpdate { get; set; }
public string GetValidationMessage()
{
throw new NotImplementedException();
}
public void SetValidationMessage(string message)
{
throw new NotImplementedException();
}
}
Viswanatha Swamy6y ago
Riddhi,
Good afternoon. Could you please paste the error message and also the Code in text instead of Image. That will be of great help. Many thanks.
Riddhi Valecha6y ago
Hello sir,
I am sharing my code -
Riddhi Valecha6y ago
Hello All, How Do I update a record in with Entity Framework ?

I am not able to debug the code.

I am getting the following error -
Viswanatha Swamy6y ago
Riddhi,
Good evening. I have verified the code and checked into the GitHub. Please refer to the repository.
URL: https://github.com/vishipayyallore/speaker_series/tree/master/MicroServices/01Feb2020/College.ServicesWebApi

Step 1: Create a file called JsonDateConverter.cs
using System;
using System.Globalization;
using System.Text.Json;
using System.Text.Json.Serialization;

namespace College.Api.Entities
{
    public class JsonDateConverter : JsonConverter
    {
        public override DateTime Read(ref Utf8JsonReader reader, Type typeToConvert, JsonSerializerOptions options)
       => DateTime.ParseExact(reader.GetString(),
                    "yyyy-MM-dd", CultureInfo.InvariantCulture);


        public override void Write(Utf8JsonWriter writer, DateTime value, JsonSerializerOptions options)
       => writer.WriteStringValue(value.ToString(
                    "dd-MMMM-yyyy", CultureInfo.InvariantCulture));
    }
}
Step 2: Add JsonConverter Attribute to the field inside the Model Class.
public class Professor
{
    [Key]
    public Guid ProfessorId { get; set; }

    public string Name { get; set; }

    [JsonConverter(typeof(JsonDateConverter))]
    public DateTime Doj { get; set; }

    public string Teaches { get; set; }

    public decimal Salary { get; set; }

    public bool IsPhd { get; set; }

    public ICollection Students { get; set; } = new List();

}
Step 3: Test in Browser OR Post Man
Viswanatha Swamy6y ago
Riddhi,
Good evening. You can use the below-mentioned data annotations on the fields on the data model. Please refer to the URL for additional details. Many thanks.
[DataType(DataType.Date)]
[DisplayFormat(DataFormatString="{0:dd-MMMM-yyyy}")]
https://www.csharp-examples.net/string-format-datetime/
Riddhi Valecha6y ago
Hello Team,
How Do I update a record ?

1. I need to display date in format -
dd-MMM-yyyy (E.G. - 02-April-2020)
2. I want to update a record -
.NET Core 2.2 Web API using Entity Framework and MySQL(Backend)
a. Check the values - Mobile_Update != "string" || Mobile_Update != "" then update else do not update Mobile Number
LocationCodeUpdate - this is the primary key.
Riddhi Valecha6y ago
Date Format is not working with -

[DataType(DataType.Date), DisplayFormat(DataFormatString = "{0:dd'/'MM'/'yyyy HH:mm}", ApplyFormatInEditMode = true)]
also.
Riddhi Valecha6y ago
For Date , it is not working with this also -

[DisplayFormat(ApplyFormatInEditMode = true, DataFormatString = "{0:dd-MMM-yyyy}")]
Jignesh Kumar6y ago
Hi Ridhi,

Please try below link for update,
https://www.dotnetcurry.com/entityframework/619/add-update-delete-objects-entity-framework

for date formate :
https://entityframework.net/knowledge-base/26146606/how-can-i-convert-datetime-to-string-in-linq-query-
Riddhi Valecha6y ago
Hello sir,
I have 2 more doubts here to ask -
1. How do I display date as dd-MON-yyyy format (E.g. - 02-April-2020).
2. How do I update the records using EntityFramework MySQL?

Please guide on this..
Riddhi Valecha6y ago
Dear All,

Any idea - how do I make date format as - dd-Mon-yyyy (E.G. - 01-April-2020) here ?

I have changed the date format in startup.cs class file, but in swagger, it does not change the date format ...
Viswanatha Swamy6y ago
Riddhi,
Good afternoon. Could you please paste your model class instead of on an image? Many thanks.
Riddhi Valecha6y ago
Hello Vishwanath sir,

While validating, do I need to check - LocationCode should not be "string" ?

And, how do I resolve the other issue - Validator typeof(Drivervalidator) issue ?
Viswanatha Swamy6y ago
Riddhi,
Good morning. Swagger showing "String" and other data types are expected. It is the hint for the user to what data type they should provide. When you send the parameters are you facing any issues? Please advise. Many thanks.
Riddhi Valecha6y ago
Hello Team,

Please help me out - I have reached till here -
Riddhi Valecha6y ago
Hello All.. I tried with IValidatableObject Interface -

Here, it is showing "String" .
Any idea, where I am going wrong ?
Riddhi Valecha6y ago
Hello All...

Can we do Fluent Validations in .NET Core 2.0 and Swagger ?
Riddhi Valecha6y ago
Hello Sir,
I have installed all the packages .. PLease see -
Riddhi Valecha6y ago
Hello Jignesh sir,

How do I enable Client Side Validation ?

This is using .NET Core 2.0 Web Api
Jignesh Kumar6y ago
Hi you need to install. https://docs.fluentvalidation.net/en/latest/mvc5.html
Riddhi Valecha6y ago
Dear All,
Please see the error screen -
Please guide - how do I complete this ?

How Do I add the FluentValidations here ?
Jignesh Kumar6y ago
Hi,
https://stackoverflow.com/questions/4746390/fluent-validations-inherit-validation-classes
Riddhi Valecha6y ago
I am facing issue here -

[Validator(typeof(UserValidator))]
What is Validator ? Which namespace ?
Jignesh Kumar6y ago
Hi Riddhi,

As per my understandin, Cliletsied validation is not enalbed. Please make it enable unsing below link,
https://www.tutorialsteacher.com/articles/enable-client-side-valiation-in-mvc
Riddhi Valecha6y ago
Dear Viswanatha sir,

Please see the screen shots of my code and swagger output -
Viswanatha Swamy6y ago
Riddhi,
Good morning. Could you please add Minimum and Maximum Length Data Annotations? It should have the required attribute and on top add Min/Max Lenght. Many thanks.
[Required]
[MaxLength(50,ErrorMessage="Name cannot be greater than 50")]
  public string Name { get; set; }

[Required]
  [MinLength(10, ErrorMessage = "Name cannot be less than 10")]
  public string Address { get; set; }
https://www.tektutorialshub.com/entity-framework/ef-data-annotations-maxlength-minlength-attribute/
https://www.entityframeworktutorial.net/code-first/stringlength-dataannotations-attribute-in-code-first.aspx
Riddhi Valecha6y ago
Hello Viswanatha sir,

I tried this method.

I added [Required] before DriverName property, but while debugging, it takes value "string" for saving the data.

The code is not giving alert message saying - "Name cannot be blank" or something like this ...
Riddhi Valecha6y ago
Dear Jignesh sir,

Is there no other way than FluentValidation ?
Viswanatha Swamy6y ago
Riddhi,
Good evening. Could you please using Data Annotations? Please refer the URL below. Many thanks.

https://docs.microsoft.com/en-us/ef/ef6/modeling/code-first/data-annotations
Riddhi Valecha6y ago
Hello All,

Do anyone has a working example for validations ?

1. For saving/inserting date - All fields should be mandatory ; while debugging - it takes value "string" as Driver Name ; This is in swagger.

How do I solve this issue ?
Riddhi Valecha6y ago
Hello sir,
Could you please explain this with some example ?
Or could you use my class properties ?
I am not able to do this.
While Inserting a new Driver - If I do not put any values - it still saves - Driver Name as "string".
Riddhi Valecha6y ago
Hello sir,
I had followed the same link example for swagger.
My Code (class files) - facing issue is fetching records -

DriverModel.cs
public class DriverMasterGet
{
public string LocationCode {get;set;}
public string DriverCode {get;set;}
public int IsActive {get;set;}
public int IsApproved {get;set;}
}

public class DriverMasterAdd
{
public string LocationCode {get;set;}
public string DriverName {get;set;}
public string Mobile {get;set;}
public DateTime JoiningDate {get;set;}
public string ShiftFromTime {get;set;}
public string ShiftToTime {get;set;}
public int IsActive {get;set;}
public int IsApproved {get;set;}
}
-------------
DriverMaster.cs
public class DriverMaster
{
public List DriverGet(DriverMasterModelGet DriverMasterGet)
{
DriverDBContext DBDriverMaster = new DriverDBContext();
List responseDriverMaster = null;
if(DriverMasterGet.DriverCode == "0")
{
responseDriverMaster = (from p in DBDriverMaster.DriverMastet join e in DBDrivermaster.Vendormaster on p.vendorocode equals e.vendorcode where p.Locationcode = drivermasterget.locationcode && p.isactive = drivermasterget.isactive
select new DriverMasterRess
{
LocationCode = p.LocationCode,
DriverCode = p.DriverCode
}).ToList();
}
}
}
------------------
Here, in debugging, in class "DriverMaster.cs", when I want all the records, it takes p.LocationCode as "string".
Siddharth Gajbhiye6y ago
Hello Riddhi,

https://www.c-sharpcorner.com/article/swagger-for-asp-net-core-api-2-2/

https://www.anexinet.com/blog/asp-net-core-fluentvalidation-swagger/

Please refer this links it might help you

Thank You
Riddhi Valecha6y ago
Hello Sir,
As per the code, I have a class files with all the properties and the DBContext model.

I need to complete it using swagger, and when I debug the code, it takes input as "string".
For E.G. - IF I need all the records in GET method, still the system checks for records where locationcode is "string".

How do I solve this ?
Jignesh Kumar6y ago
Hi Ridhi,

Please find below link,
https://exceptionnotfound.net/custom-validation-in-asp-net-web-api-with-fluentvalidation/