Завершено

Portal booking error fixing ASPX and MS sql database - visual studio

We have a portal login system which started to give errors after 27 of march , which we need someone to fix , error code bellow and see the attached document , WE DO NOT HAVE THE ORIGINAL FILES SO DECOMPILING WILL NEED !!

// [login to view URL]

protected void btn_login_Click(object sender, EventArgs e)

{

string arg_26_0 = [login to view URL]();

string a = [login to view URL]();

if (arg_26_0 == "")

{

[login to view URL]([login to view URL](), "alertMessage", "calert('Please Enter Email');", true);

[login to view URL]();

return;

}

if (a == "")

{

[login to view URL]([login to view URL](), "alertMessage", "calert('Please Enter Password');", true);

[login to view URL]();

return;

}

boUser arg_95_0 = new boUser();

DataTable dataTable = new DataTable();

arg_95_0.Email_ID = [login to view URL]();

[login to view URL] = [login to view URL]([login to view URL]());

dataTable = arg_95_0.Check_User_Credential();

if ([login to view URL] <= 0)

{

[login to view URL]([login to view URL](), "alertMessage", "calert('Invalid Credential');", true);

return;

}

byte b = [login to view URL]([login to view URL][0]["Status"]);

if (b == 1)

{

this.type_of_login = "Normal_Login";

[login to view URL]["Login_Type"] = this.type_of_login;

[login to view URL]["Email_ID"] = [login to view URL]([login to view URL][0]["Email_ID"]);

[login to view URL]["UserID"] = [login to view URL]([login to view URL][0]["UserID"]);

[login to view URL]["Full_Name"] = [login to view URL]([login to view URL][0]["Full_Name"]);

<<<<<<<Trimmed for space>>>>>>>>

}

It looks like above highlighted method is the cause of crash. Checking what the highlighted method is doing:

// [login to view URL]

public DataTable Check_User_Credential()

{

daUser daUser = new daUser();

[login to view URL](daUser);

return daUser.Check_User_Credential();

}

Dumping the highlighted method:

// [login to view URL]

public DataTable Check_User_Credential()

{

DataTable result;

try

{

DateTime t = [login to view URL]("2019-03-27", "yyyy-MM-dd", null);

if ([login to view URL] > t)

{

result = null;

}

else

{

SqlConnection sqlConnection = new SqlConnection();

SqlCommand sqlCommand = new SqlCommand();

SqlDataAdapter arg_AD_0 = new SqlDataAdapter();

DataTable dataTable = new DataTable();

string connectionString = [login to view URL]([login to view URL]["CRM"].ConnectionString);

<<<<<<Trimmed for space>>>>>>

Квалификация: ASP, Программирование на C#, PHP

Показать больше azure sql database connection timeout, sql connection retry logic, sql server connection string retry, database error number, unable to connect to azure database, ms sql error, sql transient connection exception, connect to azure sql database, save array sql database visual basic image, read access database visual studio 2005, deploy sql express visual studio, converting access database visual studio, report sql video visual studio, clickonce deploying sql express visual studio, insert sql 2005 visual studio, including sql express visual studio deployment, mvc access database visual studio 2008 web application, free ms sql database download, ms sql accessing visual basic net, ms sql database registration module website

О работодателе:
( 2 отзыв(-а, -ов) ) london, United Kingdom

ID проекта: #19281143

Поручен:

xutao650

Hi The root cause is bellow codes. It returns null which causes nullpointreference exception. if ([login to view URL] > t) { result = null; } Do you have source code of your website? If you have, I can help Больше

$100 USD за 3 дней(-я)
(35 отзывов(-а))
5.1

23 фрилансеров(-а) в среднем готовы выполнить эту работу за $118

bmartynvw

Hi, My name is Benjamin. I'm an expert developer with over 14 years of experience. I can fix your date check code quickly. Look forward to a chat. Thanks,

$140 USD за 1 день
(44 отзывов(-а))
7.2
sumon355

Hello, As an experienced asp.net developer and having sound knowledge in ms sql server, i am very much interested to fix the issue. I have check the code and the attached image and i can fix the issue quickly. Looking Больше

$50 USD за 0 дней(-я)
(194 отзывов(-а))
7.2
adeelpirzada

Hi it feels good to talk to you, My video portfolio: [login to view URL] My Reputation: I am rated in top 3% freelancers here on my .Net C# Programming skills. I have completed numerous projects on MVC a Больше

$125 USD за 7 дней(-я)
(43 отзывов(-а))
6.5
schoudhary1553

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Больше

$220 USD за 3 дней(-я)
(45 отзывов(-а))
6.2
ludwig333

Hi. i am a full web developer with over 5 years on freelancer.com. ****In SPECIAL very familiar with ASP.NET, C#, MSSQL, MVC***** I have read your description and have interests in your project. I have rich expe Больше

$70 USD за 3 дней(-я)
(44 отзывов(-а))
6.0
intemo

Hi! I offer you my skills for your task. I'm ready de-compiling, fixing your issue and compile your project again. I have a lot experiences for asp.net development, I'm expert for MS SQL SERVER (full stack), html,css, Больше

$200 USD за 20 дней(-я)
(58 отзывов(-а))
5.6
RushService

Feel fee to contact me for Portal booking error fixing ASPX and MS sql database - visual studio .Shoot me message to discuss further more details .We provide the comments,images,videos,demos and live sessions in o Больше

$130 USD за 3 дней(-я)
(35 отзывов(-а))
5.8
hardikshah83

Its a small fix, I can fix it immediately. Programmer with more than 10 years of development experience here. I have handled production applications with various technologies like .NET, PHP, Classic ASP and many more Больше

$50 USD за 1 день
(44 отзывов(-а))
5.8
servicebenq

Hi I am very interest your project. I can do this fix for your in few hours. I am ready to start right now. Hope to hear from you soon. Thanks

$45 USD за 1 день
(54 отзывов(-а))
5.6
amitadlakha04

Hi wecomputing I've checked your job post Portal booking error fixing ASPX and MS sql database - visual studio and I am much interested to assist you on requirement . I'll provide you with the quick turnaround for th Больше

$95 USD за 13 дней(-я)
(26 отзывов(-а))
5.2
Vadimwang

I am very interested in your job I have ever been developed some time limit project at last years I want to discuss about you job

$100 USD за 3 дней(-я)
(32 отзывов(-а))
5.3
sshyam24

Hi, Thanks for sharing your requirements here at freelancer. I am more than happy to help you on your project. I have excellent experience in Website Designing/Development. I believe my abilities would be perfect Больше

$155 USD за 3 дней(-я)
(19 отзывов(-а))
4.0
jayantavkumar

I can fix this issue... I am a database / Business Intelligence / solution architect. I have more than 14 years of experience in various technologies as mentioned below: Database - SQL Server, Oracle, MySQL BI Больше

$155 USD за 3 дней(-я)
(3 отзывов(-а))
3.5
shailikhatri

I am an experienced Web and Software Developer, and I am very interested in your job post. I have excellent experience in MVC,.Net Core, ASP.NET, C#, Linq, Entity Framework, MySQL, MSSQL, REST API, JSON, HTML5, Angu Больше

$100 USD за 3 дней(-я)
(5 отзывов(-а))
3.2
akshaykumavat69

I will help you to solve this issue. Will start working on it right away. I am .NET developer. I have good hands-on experience more than 4 yrs in asp.net web and windows application development.I have my own workst Больше

$100 USD за 4 дней(-я)
(4 отзывов(-а))
2.4
FreelancerTechX

Hello, the easiest way to fix this without recompiling is simply change the year to year 3000 or something. I can do this in 15 minutes ************************************************************

$30 USD за 1 день
(3 отзывов(-а))
2.3
sajeeshchatl

Hello, I have read you description and attachment. I didn't see any error related code in the description. But attachment says object reference not set instance of object. This error related to creation of object with Больше

$40 USD за 0 дней(-я)
(8 отзывов(-а))
1.8
mezoni

Hi, I can help you to fix it. It seems like you have logic to disable connections after that date. I don't see the code after connection strings but it looks like simple fix. I have 10+ experience in .NET (ASP.NET Больше

$199 USD за 2 дней(-я)
(0 отзывов(-а))
0.0
sreekantha86

hi, it is a minor bug in point of a programmer and major bug in the view of user. I will fix this bug at free of cost bcz it won't take too much time. please come to chat for more.

$30 USD за 1 день
(0 отзывов(-а))
3.0
rasouliali

I'm new to freelancer but I have 7 years of experience in DOT NET development. I write many program with .NET but they are enterprise and some projects are in local network in organization(like private portal site)so Больше

$277 USD за 3 дней(-я)
(0 отзывов(-а))
2.5