public List <MyDataBusinessLogic> Register(MyDataBusinessLogic Data)
{
RegistrationManager cm = new RegistrationManager();
List <MyDataBusinessLogic> st = cm.InsertUserMaster(Data);
return(st);
}
public List <MyDataBusinessLogic> LoginValues(MyDataBusinessLogic Data)
{
DataTable dt = ExistingUser(Data);
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
List.Add(new MyDataBusinessLogic
{
ID = Int32.Parse(dt.Rows[i]["ID"].ToString()),
user = dt.Rows[i]["UserName"].ToString(),
});
}
}
else
{
List.Add(new MyDataBusinessLogic
{
ID = Int32.Parse("0")
});
}
return(List);
}
public List <MyDataBusinessLogic> LogIn(MyDataBusinessLogic Data)
{
RegistrationManager cm = new RegistrationManager();
List <MyDataBusinessLogic> st = cm.LoginValues(Data);
return(st);
}
public List <MyDataBusinessLogic> InsertUserMaster(MyDataBusinessLogic Data)
{
int r1 = 0;
int r2 = 0;
DbConnection con = null;
DbTransaction trans;
try
{
con = _dbFactory.GetConnection();
con.Open();
trans = _dbFactory.GetTransaction(con);
DbCommand Cmd = _dbFactory.GetCommand();
Cmd.Connection = con;
Cmd.Transaction = trans;
try
{
Cmd.CommandText = " IF((select count(*) from NVO_Reg where ID=@ID)<=0) " +
" BEGIN " +
" INSERT INTO NVO_Reg(Name,Mobile,Email,UserName,Password,UserCode,Location,Designation,Branch,Address,CurrentDate) " +
" values (@Name,@Mobile,@Email,@UserName,@Password,@UserCode,@Location,@Designation,@Branch,@Address,@CurrentDate) " +
" END " +
" ELSE " +
" UPDATE NVO_Reg SET Name=@Name,Mobile=@Mobile,Email=@Email,UserName=@UserName,Password=@Password,UserCode=@UserCode,Location=@Location,Designation=@Designation,Branch=@Branch,Address=@Address,CurrentDate=@CurrentDate where ID=@ID";
Cmd.Parameters.Add(_dbFactory.GetParameter("@ID", Data.ID));
Cmd.Parameters.Add(_dbFactory.GetParameter("@Name", Data.Name));
Cmd.Parameters.Add(_dbFactory.GetParameter("@Mobile", Data.MobileNo));
Cmd.Parameters.Add(_dbFactory.GetParameter("@Email", Data.Email));
Cmd.Parameters.Add(_dbFactory.GetParameter("@UserName", Data.UserName));
Cmd.Parameters.Add(_dbFactory.GetParameter("@Password", Data.Password));
Cmd.Parameters.Add(_dbFactory.GetParameter("@UserCode", Data.UserCode));
Cmd.Parameters.Add(_dbFactory.GetParameter("@Location", Data.Location));
Cmd.Parameters.Add(_dbFactory.GetParameter("@Designation", Data.Designation));
Cmd.Parameters.Add(_dbFactory.GetParameter("@Branch", Data.Branch));
Cmd.Parameters.Add(_dbFactory.GetParameter("@Address", Data.Address));
Cmd.Parameters.Add(_dbFactory.GetParameter("@CurrentDate", System.DateTime.Now));
int result = Cmd.ExecuteNonQuery();
Cmd.CommandText = "select ident_current('NVO_Reg')";
if (Data.ID == 0)
{
Data.ID = Int32.Parse(Cmd.ExecuteScalar().ToString());
}
else
{
Data.ID = Data.ID;
}
trans.Commit();
return(List);
}
catch (Exception ex)
{
string ss = ex.ToString();
trans.Rollback();
return(List);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (con != null && con.State != ConnectionState.Closed)
{
con.Close();
}
}
}
public DataTable ExistingUser(MyDataBusinessLogic Data)
{
string _query = "select * from NVO_Reg where UserName='******' and Password='******'";
return(GetViewData(_query, ""));
}
