Entity Framework - Validations

Question

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 ..

Jignesh Kumar · Answer

Hi you need to install. https://docs.fluentvalidation.net/en/latest/mvc5.html

Riddhi Valecha · Answer

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 Swamy · Answer

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 Valecha · Answer

[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 Swamy · Answer

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 Valecha · Answer

Hello sir, I am sharing my code -

Riddhi Valecha · Answer

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 Swamy · Answer

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 Swamy · Answer

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 Valecha · Answer

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 Valecha · Answer

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

Riddhi Valecha · Answer

For Date , it is not working with this also - [DisplayFormat(ApplyFormatInEditMode = true, DataFormatString = "{0:dd-MMM-yyyy}")]

Jignesh Kumar · Answer

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 Valecha · Answer

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 Valecha · Answer

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 Swamy · Answer

Riddhi, Good afternoon. Could you please paste your model class instead of on an image? Many thanks.

Riddhi Valecha · Answer

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 Swamy · Answer

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 Valecha · Answer

Hello Team, Please help me out - I have reached till here -

Riddhi Valecha · Answer

Hello All.. I tried with IValidatableObject Interface - Here, it is showing "String" . Any idea, where I am going wrong ?

Riddhi Valecha · Answer

Hello All... Can we do Fluent Validations in .NET Core 2.0 and Swagger ?

Riddhi Valecha · Answer

Hello Sir, I have installed all the packages .. PLease see -

Riddhi Valecha · Answer

Hello Jignesh sir, How do I enable Client Side Validation ? This is using .NET Core 2.0 Web Api

Riddhi Valecha · Answer

Dear All, Please see the error screen - Please guide - how do I complete this ? How Do I add the FluentValidations here ?

Jignesh Kumar · Answer

Hi, https://stackoverflow.com/questions/4746390/fluent-validations-inherit-validation-classes

Riddhi Valecha · Answer

I am facing issue here - [Validator(typeof(UserValidator))] What is Validator ? Which namespace ?

Jignesh Kumar · Answer

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 Valecha · Answer

Dear Viswanatha sir, Please see the screen shots of my code and swagger output -

Viswanatha Swamy · Answer

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 Valecha · Answer

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 Valecha · Answer

Dear Jignesh sir, Is there no other way than FluentValidation ?

Viswanatha Swamy · Answer

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 Valecha · Answer

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 Valecha · Answer

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 Valecha · Answer

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 Gajbhiye · Answer

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 Valecha · Answer

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 Kumar · Answer

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