public Object UpdateCompanyData(LicenseCompanys UsersObject)
{
try
{
Object ReturnValue = ValidateCompanyUpdate(UsersObject);
DataTable dt = DAL.UsersDAL.Ins.GetDataByCompanyName(UsersObject);
if (dt.Rows.Count == 0)
{
if (ReturnValue.ToString() == "")
{
return(DAL.UsersDAL.Ins.UpdateCompanyData(UsersObject));
}
else
{
return(ReturnValue);
}
}
else
{
return("LoginName Is Not Available.");
}
}
catch (Exception ex)
{
throw ex;
}
}
public DataTable GetDataByCompanyName(LicenseCompanys UsersObject)
{
DataTable UsersDataTable = new DataTable();
//Users ReturnUserobject = new Users();
try
{
if (UsersObject.ID == 0)
{
string SqlQuery = "SELECT * FROM [LicenseCompanys] where CompanyName='" + UsersObject.CompanyName + "'";
//string SqlQuery = "SELECT * FROM Servers";
UsersDataTable = objAdaptor.FetchData(SqlQuery);
}
else
{
string SqlQuery = "SELECT * FROM [LicenseCompanys] where CompanyName='" + UsersObject.CompanyName + "' and ID<>'" + UsersObject.ID + "'";
UsersDataTable = objAdaptor.FetchData(SqlQuery);
}
}
catch
{
}
finally
{
}
return(UsersDataTable);
}
public Object ValidateCompanyUpdate(LicenseCompanys UsersObject)
{
Object ReturnValue = "";
try
{
if (UsersObject.CompanyName == null || UsersObject.CompanyName == "")
{
return("ER#Please enter the CompanyName");
}
}
catch (Exception ex)
{ throw ex; }
finally
{ }
return("");
}
public Object UpdateCompanyData(LicenseCompanys UsersObject)
{
Object Update;
try
{
string SqlQuery = "UPDATE [LicenseCompanys] SET [CompanyName]='" + UsersObject.CompanyName + "' WHERE ID=" + UsersObject.ID + "";
Update = objAdaptor.ExecuteNonQuery(SqlQuery);
}
catch
{
Update = false;
}
finally
{
}
return(Update);
}
public bool InsertCompanyName(LicenseCompanys UsersObject)
{
bool Insert = false;
try
{
string SqlQuery = "INSERT INTO [LicenseCompanys] (CompanyName)" +
"VALUES('" + UsersObject.CompanyName + "')";
Insert = objAdaptor.ExecuteNonQuery(SqlQuery);
}
catch
{
Insert = false;
}
finally
{
}
return(Insert);
}
private LicenseCompanys CollectDataForUsers(string Mode, DataRow UsersRow)
{
try
{
LicenseCompanys UsersObject = new LicenseCompanys();
if (Mode == "Update")
{
UsersObject.ID = int.Parse(UsersRow["ID"].ToString());
}
UsersObject.CompanyName = UsersRow["CompanyName"].ToString();
return(UsersObject);
}
catch (Exception ex)
{
Log.Entry.Ins.WriteHistoryEntry(DateTime.Now.ToString() + " Exception - " + ex);
throw ex;
}
finally { }
}
