protected void Button_Databases_Click(object sender, EventArgs e)
{
DataAccessLayer dal = new DataAccessLayer();
resetPanelsAndLabels();
DataTable databases = dal.getDatabaseNames();
if (databases.Rows.Count > 0)
{
Panel_Databases.Visible = true;
GridView_Databases.DataSource = databases;
GridView_Databases.DataBind();
}
else
{
PanelErrorMessages.Visible = true;
Label_ErrorMessage.Visible = true;
Label_ErrorMessage.Text = String.Format("There is some error while connecting to the server " );
}
//foreach (DataRow database in databases.Rows)
//{
// String databaseName = database.Field<String>("database_name");
// short dbID = database.Field<short>("dbid");
// DateTime creationDate = database.Field<DateTime>("create_date");
//}
}
public int CheckMaterial(ModelDB objDB, SqlTransaction objTrans)
{
int flag = 0;
DataAccessLayer objDataLayer = new DataAccessLayer();
SqlCommand objCmd = new SqlCommand();
try
{
objCmd.CommandText = "Usp_CheckMaterial";
objCmd.CommandType = CommandType.StoredProcedure;
objCmd.Parameters.AddWithValue("@Material", objDB.Material);
objCmd.Parameters.AddWithValue("@flag", SqlDbType.Int);
objCmd.Parameters["@flag"].Direction = ParameterDirection.Output;
objCmd.Transaction = objTrans;
objCmd.Connection = objTrans.Connection;
objDataLayer.Command = objCmd;
objDataLayer.ExecQuery();
flag = Convert.ToInt32(objCmd.Parameters["@flag"].Value);
return flag;
}
catch (Exception ex)
{
throw ex;
}
}
public int SaveModelDetail(ModelDB objDB, SqlTransaction objTrans)
{
int MappingID = 0;
DataAccessLayer objDataLayer = new DataAccessLayer();
SqlCommand objCmd = new SqlCommand();
try
{
objCmd.CommandText = "Usp_SaveModelMapping";
objCmd.CommandType = CommandType.StoredProcedure;
objCmd.Parameters.AddWithValue("@Material", objDB.Material);
objCmd.Parameters.AddWithValue("@GroupID", objDB.GroupID);
objCmd.Parameters.AddWithValue("@ModelSpecialID", objDB.ModelSpecialID);
objCmd.Parameters.AddWithValue("@ClutchTypeID", objDB.ClutchTypeID);
objCmd.Parameters.AddWithValue("@ModelCategoryID", objDB.ModelCategoryID);
objCmd.Parameters.AddWithValue("@Description", objDB.Description);
objCmd.Parameters.AddWithValue("@MappingID", SqlDbType.Int);
objCmd.Parameters["@MappingID"].Direction = ParameterDirection.Output;
objCmd.Transaction = objTrans;
objCmd.Connection = objTrans.Connection;
objDataLayer.Command = objCmd;
objDataLayer.ExecQuery();
MappingID = Convert.ToInt32(objCmd.Parameters["@MappingID"].Value);
return MappingID;
}
catch (Exception ex)
{
throw ex;
}
}
public int SaveReworkCost(ReworkCostDB objDB, SqlTransaction objTrans)
{
int ID = 0;
DataAccessLayer objDataLayer = new DataAccessLayer();
SqlCommand objCmd = new SqlCommand();
try
{
objCmd.CommandText = "usp_SaveReworkCost";
objCmd.CommandType = CommandType.StoredProcedure;
objCmd.Parameters.AddWithValue("@MonthID", objDB.MonthID);
objCmd.Parameters.AddWithValue("@YearID", objDB.YearID);
objCmd.Parameters.AddWithValue("@ModelGroupID", objDB.GroupID);
objCmd.Parameters.AddWithValue("@ReworkCost_I_Year", objDB.ReworkCost_I_Year);
objCmd.Parameters.AddWithValue("@ReworkCost_II_Year", objDB.ReworkCost_II_Year);
objCmd.Parameters.AddWithValue("@ModelCategoryID", objDB.ModelCategoryID);
objCmd.Parameters.AddWithValue("@HMR_Range", objDB.HMR_Range);
objCmd.Parameters.AddWithValue("@ID", SqlDbType.Int);
objCmd.Parameters["@ID"].Direction = ParameterDirection.Output;
objCmd.Transaction = objTrans;
objCmd.Connection = objTrans.Connection;
objDataLayer.Command = objCmd;
objDataLayer.ExecQuery();
ID = Convert.ToInt32(objCmd.Parameters["@ID"].Value);
return ID;
}
catch (Exception ex)
{
throw ex;
}
}
protected void Page_Load(object sender, EventArgs e)
{
HttpResponse<string> response = Unirest.get("https://omgvamp-hearthstone-v1.p.mashape.com/cards?collectible=1")
.header("X-Mashape-Key", "Y6G2Ve8iAOmshQFq4sGVgvBtI1HVp1CVLrWjsnPikTu4oqy2EK")
.asJson<string>();
CardCollection collection = new CardCollection();
collection = JsonConvert.DeserializeObject<CardCollection>(response.Body);
List<Card> cards = new List<Card>();
cards.AddRange(collection.basic);
cards.AddRange(collection.classic);
cards.AddRange(collection.naxxramas);
cards.AddRange(collection.gvg);
cards.AddRange(collection.blackrock);
cards.AddRange(collection.grandTournament);
cards.AddRange(collection.leagueOfExplorers);
DataAccessLayer layer1 = new DataAccessLayer();
try
{
layer1.InsertCardsToDb(cards);
}
catch (Exception)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "AlertBox", "alert('Kortit jo kannassa');", true);
}
//Grid.DataSource = cards as IEnumerable<Card>;
Grid.DataSource = cards as IEnumerable<Card>;
Grid.DataBind();
}
public void SaveProductionData()
{
bool flagTransation = true;
DataAccessLayer objDataAccess = new DataAccessLayer();
SqlTransaction objTrans = null;
try
{
if (objTrans == null)
{
flagTransation = false;
objDataAccess.GetConnection.Open();
SqlTransaction objTransaction = objDataAccess.GetConnection.BeginTransaction();
objTrans = objTransaction;
}
ProductionManager objManager = new ProductionManager();
objManager.SaveProductionData(objTrans);
if (!flagTransation)
objTrans.Commit();
}
catch (Exception ex)
{
if (!flagTransation)
objTrans.Rollback();
throw ex;
}
finally
{
objDataAccess.GetConnection.Close();
}
}
public int getModelMapping(Int64 TractorNo, SqlTransaction objTrans)
{
int ModelMappingID = 0;
DataAccessLayer objDataLayer = new DataAccessLayer();
SqlCommand objCmd = new SqlCommand();
try
{
objCmd.CommandText = "usp_getModelMappingID";
objCmd.CommandType = CommandType.StoredProcedure;
objCmd.Parameters.AddWithValue("@TRACTOR_NO", TractorNo);
objCmd.Parameters.AddWithValue("@ModelMappingID", SqlDbType.Int);
objCmd.Parameters["@ModelMappingID"].Direction = ParameterDirection.Output;
objCmd.Transaction = objTrans;
objCmd.Connection = objTrans.Connection;
objDataLayer.Command = objCmd;
objDataLayer.ExecQuery();
ModelMappingID = Convert.ToInt32(objCmd.Parameters["@ModelMappingID"].Value);
}
catch (Exception ex)
{
throw ex;
}
return ModelMappingID;
}
public DataTable ExecuteQuery(string Query)
{
bool flagTransation = true;
DataAccessLayer objDataAccess = new DataAccessLayer();
SqlTransaction objTrans = null;
try
{
if (objTrans == null)
{
flagTransation = false;
objDataAccess.GetConnection.Open();
SqlTransaction objTransaction = objDataAccess.GetConnection.BeginTransaction();
objTrans = objTransaction;
}
QueryManager objManager = new QueryManager();
DataTable dtQueryResult = objManager.ExecuteQuery(Query, objTrans);
if (!flagTransation)
objTrans.Commit();
return dtQueryResult;
}
catch (Exception ex)
{
if (!flagTransation)
objTrans.Rollback();
throw ex;
}
finally
{
objDataAccess.GetConnection.Close();
}
}
public void SaveMonthOpenClose(MonthOpenCloseDB objDB, SqlTransaction objTrans)
{
DataAccessLayer objDataLayer = new DataAccessLayer();
SqlCommand objCmd = new SqlCommand();
try
{
objCmd.CommandText = "usp_SaveMonthOpenClose";
objCmd.CommandType = CommandType.StoredProcedure;
objCmd.Parameters.AddWithValue("@MonthID", objDB.MonthID);
objCmd.Parameters.AddWithValue("@YearID", objDB.YearID);
objCmd.Parameters.AddWithValue("@Status", objDB.Status);
objCmd.Parameters.AddWithValue("@id", SqlDbType.Int);
objCmd.Parameters["@id"].Direction = ParameterDirection.Output;
objCmd.Transaction = objTrans;
objCmd.Connection = objTrans.Connection;
objDataLayer.Command = objCmd;
objDataLayer.ExecQuery();
}
catch (Exception ex)
{
throw ex;
}
}
public int SaveBudget(BudgetDB objDB, SqlTransaction objTrans)
{
int ID = 0;
DataAccessLayer objDataLayer = new DataAccessLayer();
SqlCommand objCmd = new SqlCommand();
try
{
objCmd.CommandText = "usp_SaveBudget";
objCmd.CommandType = CommandType.StoredProcedure;
objCmd.Parameters.AddWithValue("@FinancialYear", objDB.FinancialYear);
objCmd.Parameters.AddWithValue("@QuarterID", objDB.QuarterID);
objCmd.Parameters.AddWithValue("@Budget", objDB.Budget);
objCmd.Parameters.AddWithValue("@ModelGroupID", objDB.ModelGroupID);
objCmd.Parameters.AddWithValue("@ModelCategoryID", objDB.ModelCategoryID);
objCmd.Parameters.AddWithValue("@ModelClutchID", objDB.ModelClutchID);
objCmd.Parameters.AddWithValue("@ModelSpecialID", objDB.ModelSpecialID);
objCmd.Parameters.AddWithValue("@ID", SqlDbType.Int);
objCmd.Parameters["@ID"].Direction = ParameterDirection.Output;
objCmd.Transaction = objTrans;
objCmd.Connection = objTrans.Connection;
objDataLayer.Command = objCmd;
objDataLayer.ExecQuery();
ID = Convert.ToInt32(objCmd.Parameters["@ID"].Value);
return ID;
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet ExecuteMultiTableQuery(string strQuery, SqlTransaction objTrans)
{
SqlCommand cmd = new SqlCommand();
DataAccessLayer objDataAccess = new DataAccessLayer();
try
{
cmd.CommandText = strQuery;
cmd.CommandType = CommandType.Text;
cmd.CommandTimeout = 1000;
cmd.Transaction = objTrans;
cmd.Connection = objTrans.Connection;
objDataAccess.Command = cmd;
DataSet ds = new DataSet();
SqlDataAdapter Sda = new SqlDataAdapter(cmd);
Sda.Fill(ds);
return ds;
}
catch (Exception ex)
{
throw ex;
}
finally
{
cmd.Dispose();
}
}
public SysUserMasterDA()
{
if (db == null)
{
db = new DataAccessLayer();
}
}
public DataSet ExecuteQueryWithDataSet(string strQuery, SqlTransaction objTrans)
{
SqlCommand cmd = new SqlCommand();
DataAccessLayer objDataAccess = new DataAccessLayer();
try
{
cmd.CommandText = "execute usp_getMultipleTable '" + strQuery + "'";
cmd.CommandType = CommandType.Text;
cmd.Transaction = objTrans;
cmd.Connection = objTrans.Connection;
objDataAccess.Command = cmd;
DataSet ds = new DataSet();
SqlDataAdapter Sda = new SqlDataAdapter(cmd);
Sda.Fill(ds);
return ds;
}
catch (Exception ex)
{
throw ex;
}
finally
{
cmd.Dispose();
}
}
public int getModelMapping(Int64 TractorNo)
{
int ModelMappingID = 0;
bool flagTransation = true;
DataAccessLayer objDataAccess = new DataAccessLayer();
SqlTransaction objTrans = null;
try
{
if (objTrans == null)
{
flagTransation = false;
objDataAccess.GetConnection.Open();
SqlTransaction objTransaction = objDataAccess.GetConnection.BeginTransaction();
objTrans = objTransaction;
}
AcrManager objManager = new AcrManager();
ModelMappingID = objManager.getModelMapping(TractorNo, objTrans);
if (!flagTransation)
objTrans.Commit();
}
catch (Exception ex)
{
if (!flagTransation)
objTrans.Rollback();
throw ex;
}
finally
{
objDataAccess.GetConnection.Close();
}
return ModelMappingID;
}
public int Save(PriviledgeDB objDB, SqlTransaction objTrans)
{
int PriviledgeID = 0;
DataAccessLayer objDataLayer = new DataAccessLayer();
SqlCommand objCmd = new SqlCommand();
try
{
objCmd.CommandText = "usp_Priviledges";
objCmd.CommandType = CommandType.StoredProcedure;
objCmd.Parameters.AddWithValue("@FormID", objDB.FormID);
objCmd.Parameters.AddWithValue("@RoleID", objDB.RoleID);
objCmd.Parameters.AddWithValue("@viewing", objDB.viewing);
objCmd.Parameters.AddWithValue("@PriviledgeID", SqlDbType.Int);
objCmd.Parameters["@PriviledgeID"].Direction = ParameterDirection.Output;
objCmd.Transaction = objTrans;
objCmd.Connection = objTrans.Connection;
objDataLayer.Command = objCmd;
objDataLayer.ExecQuery();
PriviledgeID = Convert.ToInt32(objCmd.Parameters["@PriviledgeID"].Value);
return PriviledgeID;
}
catch (Exception ex)
{
throw ex;
}
}
public List<Message> GetAllMessagesForUser(DataAccessLayer.User user, DateTime? syncTime)
{
DateTime now = DateTime.UtcNow;
DateTime nonNullSyncTime = syncTime ?? DateTime.UtcNow - new TimeSpan(7, 0, 0, 0);
List<SortCriteria> sorts = new List<SortCriteria>();
sorts.Add(new SortCriteria() { Column= MessageTable.LastUpdateTimeUtcTicksColumn, SortOrder = SortOrder.Descending });
// Create a filter to say Select * from MessageTable where (Sender = @userId OR Recipient = @userId OR Recipient = @groupThatUserIsAMemberOf) AND LastUpdateTime > @syncTime
QueryFilter filter = new SelectFilter(
MessageTable.Instance,
new AndFilter(
MessageStore.CreateUserFilter(user),
new ComparisonFilter(MessageTable.LastUpdateTimeUtcTicksColumn, nonNullSyncTime.Ticks, ComparisonOperator.Greater)),
sorts);
List<ITableRow> rows = MessageTable.Instance.QueryRows(filter);
List<Message> messages = new List<Message>();
if (rows != null)
{
for (int i = 0; i < rows.Count; i++)
{
messages.Add(DataContractToTableRowConverter.ConvertToMessage(MessageTable.Instance, rows[i]));
}
}
DataAccessLayer.UserService.UpdateUserLastSyncTime(user.Id, now);
return messages;
}
public static BusinessObjects.Category To_BO(DataAccessLayer.Category categoryDAO)
{
BusinessObjects.Category categoryBO = new BusinessObjects.Category();
categoryBO.ID = categoryDAO.ID;
categoryBO.Name = categoryDAO.Name;
return categoryBO;
}
public EmployerSearchForm(DataAccessLayer dataAccessLayer)
{
var desiredWork = dataAccessLayer.Get<DictGroup>(Constants.DesiredWorkCode).DictValues
.Select(x => new DesiredWorkDescription
{
Value = false,
Code = x.Code,
Title = x.Description,
});
DesiredWork = new List<DesiredWorkDescription>(desiredWork);
}
/// <summary>
/// Creates main window
/// </summary>
/// <returns>Main window</returns>
public static MainWindow GetMainWindow()
{
IDataAccessLayer dataAccessLayer = new DataAccessLayer();
IMapper mapper = new Mapper();
IDataProvider dataProvider = new DataProvider(dataAccessLayer, mapper);
IInferenceLogger inferenceLogger = new InferenceLogger();
IInferenceModule inferenceModule = new InferenceModule(dataProvider, inferenceLogger);
IPresenter presenter = new Presenter(inferenceModule, dataAccessLayer);
MainWindow mainWindow = new MainWindow(presenter);
return mainWindow;
}
protected void ibJoin_Click(object sender, ImageClickEventArgs e)
{
DataAccessLayer dalCarPool = new DataAccessLayer();
if (Session["userid"] == null)
{
Response.Redirect("~/LoginPage.aspx?page=joinCP");
}
else
{
Response.Redirect("JoinCarpool.aspx");
}
}
public int SaveUser(UserUI objUI, System.Data.SqlClient.SqlTransaction objTrans)
{
int UserID = 0;
bool flagTransation = true;
UserDB objDB = new UserDB();
objDB.FullName = objUI.FullName;
objDB.EmployeeCode = objUI.EmployeeCode;
objDB.EmailID = objUI.EmailID;
objDB.RoleID = objUI.RoleID;
objDB.LoginID = objUI.LoginID;
objDB.Password = objUI.Password;
objDB.PhoneNo = objUI.PhoneNo;
objDB.MobileNo = objUI.MobileNo;
objDB.PermanentAddress = objUI.PermanentAddress;
objDB.CurrentAddress= objUI.CurrentAddress;
objDB.DateOfJoing = objUI.DateOfJoing;
objDB.CheckID = objUI.CheckID;
objDB.Id = objUI.Id;
objDB.UserTypeID = objUI.UserTypeID;
objDB.LevelID = objUI.LevelID;
objDB.IsActive = objUI.IsActive;
DataAccessLayer objDataAccess = new DataAccessLayer();
try
{
if (objTrans == null)
{
flagTransation = false;
objDataAccess.GetConnection.Open();
SqlTransaction objTransaction = objDataAccess.GetConnection.BeginTransaction();
objTrans = objTransaction;
}
UserManager objManager = new UserManager();
UserID = objManager.SaveUser(objDB, objTrans);
if (!flagTransation)
objTrans.Commit();
return UserID;
}
catch (Exception ex)
{
if (!flagTransation)
objTrans.Rollback();
throw ex;
}
finally
{
objDataAccess.GetConnection.Close();
}
}
public ClientMasterInfo DisplayRecord(IModelObject KeyObject)
{
string sqlString = string.Empty;
sqlString = "SELECT clm_iRecID," + Environment.NewLine;
sqlString += "clm_cClientNum," + Environment.NewLine;
sqlString += "clm_cEnglishName," + Environment.NewLine;
sqlString += "clm_cChinaName," + Environment.NewLine;
sqlString += "clm_cTaxNumber," + Environment.NewLine;
sqlString += "clm_cLinkman," + Environment.NewLine;
sqlString += "clm_cAddress," + Environment.NewLine;
sqlString += "clm_cPhone," + Environment.NewLine;
sqlString += "clm_cFax," + Environment.NewLine;
sqlString += "clm_cWebSite," + Environment.NewLine;
sqlString += "clm_cRemark," + Environment.NewLine;
sqlString += "clm_cAdd," + Environment.NewLine;
sqlString += "clm_dAddDate," + Environment.NewLine;
sqlString += "clm_cLast," + Environment.NewLine;
sqlString += "clm_dLastDate " + Environment.NewLine;
sqlString += " FROM ClientMaster_clm " + Environment.NewLine;
sqlString += " WHERE clm_iRecID=" + KeyObject.RecordID.ToString();
DataAccessLayer dal = new DataAccessLayer();
ClientMasterInfo clientMaster = null;
SqlDataReader dr = null;
try
{
dr = dal.GetDataReader(sqlString);
if (dr != null)
{
if (dr.Read())
{
clientMaster = GetRecord(dr);
}
}
}
catch (Exception Ex)
{
throw Ex;
}
finally
{
if (dr != null)
{
dr.Close();
}
}
return clientMaster;
}
public void SaveProduction(ProductionUI objUI)
{
bool flagTransation = true;
ProductionDB objDB = new ProductionDB();
objDB.S = objUI.S;
objDB.Material = objUI.Material;
objDB.SerialNo = objUI.SerialNo;
objDB.Plnt = objUI.Plnt;
objDB.SLoc = objUI.SLoc;
objDB.Description = objUI.Description;
objDB.Production_Month = objUI.Production_Month;
objDB.Production_Month_Year = objUI.Production_Month_Year;
//objDB.Model_Code = objUI.Model_Code;
objDB.FromDate = objUI.FromDate;
objDB.ToDate = objUI.ToDate;
objDB.MonthID = objUI.MonthID;
objDB.YearID = objUI.YearID;
objDB.Quarter = objUI.Quarter;
objDB.ModelMappingID = objUI.ModelMappingID;
DataAccessLayer objDataAccess = new DataAccessLayer();
SqlTransaction objTrans = null;
try
{
if (objTrans == null)
{
flagTransation = false;
objDataAccess.GetConnection.Open();
SqlTransaction objTransaction = objDataAccess.GetConnection.BeginTransaction();
objTrans = objTransaction;
}
ProductionManager objManager = new ProductionManager();
objManager.SaveProduction(objDB, objTrans);
if (!flagTransation)
objTrans.Commit();
}
catch (Exception ex)
{
if (!flagTransation)
objTrans.Rollback();
throw ex;
}
finally
{
objDataAccess.GetConnection.Close();
}
}
public int DeleteGroupName(ConfiguratorDB objDB, SqlTransaction objTrans)
{
int StatusID = 0;
DataAccessLayer objDataLayer = new DataAccessLayer();
SqlCommand objCmd = new SqlCommand();
try
{
if (objDB.source == "Model")
{
objCmd.CommandText = "Usp_DeleteGroupName";
}
if (objDB.source == "Culprit")
{
objCmd.CommandText = "Usp_DeletCulpritGroup";
}
if (objDB.source == "Defect")
{
objCmd.CommandText = "Usp_DeleteDefectGroup";
}
if (objDB.source == "Cvoice")
{
objCmd.CommandText = "Usp_DeleteCvoiceGroup";
}
if (objDB.source == "Item")
{
objCmd.CommandText = "Usp_DeleteItemGroup";
}
objCmd.CommandType = CommandType.StoredProcedure;
objCmd.Parameters.AddWithValue("@GroupID", objDB.GroupID);
objCmd.Parameters.AddWithValue("@StatusID", SqlDbType.Int);
objCmd.Parameters["@StatusID"].Direction = ParameterDirection.Output;
objCmd.Transaction = objTrans;
objCmd.Connection = objTrans.Connection;
objDataLayer.Command = objCmd;
objDataLayer.ExecQuery();
StatusID = Convert.ToInt32(objCmd.Parameters["@StatusID"].Value);
return StatusID;
}
catch (Exception ex)
{
throw ex;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["userid"] != null)
{
DataAccessLayer DALayer = new DataAccessLayer();
int empId = Convert.ToInt32(Session["userid"]);
lnkLogin.Text = "Log Out";
lblWelcome.Visible = true;
lblWelcome.Text += DALayer.getEmpFirstname(empId);
ddlCarInfo.DataSource = DALayer.ReadRegisteredCars(empId);
Page.DataBind();
// ddlCarInfo.Attributes.Add("onChange", "return saveSelectedCarInfo();");
}
}
public static Session Create(string name, string password,string mandant, DataAccessLayer.NetworkState state)
{
if (state == DataAccessLayer.NetworkState.Disconnected)
{
var session = new Session();
session.ID = null;
session.UserID = null;
return session;
}
else
{
DataAccessLayer.DAL_Session dal_Session = new DataAccessLayer.DAL_Session ();
var session = new Session();
dal_Session.GetSession (ref session,name,password,mandant,state);
return session;
}
}
public int SaveDealer(DealerUI objUI, System.Data.SqlClient.SqlTransaction objTrans)
{
int DealerID = 0;
bool flagTransation = true;
DealerDB objDB = new DealerDB();
objDB.Code = objUI.Code;
objDB.Dealer = objUI.Dealer;
objDB.RegionID = objUI.RegionID;
objDB.IsActive = objUI.IsActive;
objDB.Id = objUI.Id;
objDB.CheckID = objUI.CheckID;
objDB.City = objUI.City;
objDB.InstallerName = objUI.InstallerName;
objDB.IsOperatingDealer = objUI.IsOperatingDealer;
DataAccessLayer objDataAccess = new DataAccessLayer();
try
{
if (objTrans == null)
{
flagTransation = false;
objDataAccess.GetConnection.Open();
SqlTransaction objTransaction = objDataAccess.GetConnection.BeginTransaction();
objTrans = objTransaction;
}
DealerManager objManager = new DealerManager();
DealerID = objManager.SaveDealer(objDB, objTrans);
if (!flagTransation)
objTrans.Commit();
return DealerID;
}
catch (Exception ex)
{
if (!flagTransation)
objTrans.Rollback();
throw ex;
}
finally
{
objDataAccess.GetConnection.Close();
}
}
public static BusinessObjects.Product To_BO(DataAccessLayer.Product productDAO)
{
BusinessObjects.Product productBO = new BusinessObjects.Product();
productBO.ID = productDAO.ID;
productBO.Name = productDAO.Name;
productBO.Description = productDAO.Description;
productBO.Price = productDAO.Price;
productBO.Stock = productDAO.Stock;
productBO.CategoryID = productDAO.CategoryID;
productBO.EntryDate = productDAO.EntryDate;
productBO.ExpirationDate = productDAO.ExpirationDate;
if(productDAO.Category != null)
{
productBO.Category = CategoryMapper.To_BO(productDAO.Category);
}
return productBO;
}
public int SaveBudget(BudgetUI objUI, System.Data.SqlClient.SqlTransaction objTrans)
{
int ID = 0;
bool flagTransation = true;
BudgetDB objDB = new BudgetDB();
objDB.FinancialYear = objUI.FinancialYear;
objDB.QuarterID = objUI.QuarterID;
objDB.Budget = objUI.Budget;
objDB.ModelGroupID = objUI.ModelGroupID;
objDB.ModelCategoryID = objUI.ModelCategoryID;
objDB.ModelClutchID = objUI.ModelClutchID;
objDB.ModelSpecialID = objUI.ModelSpecialID;
DataAccessLayer objDataAccess = new DataAccessLayer();
try
{
if (objTrans == null)
{
flagTransation = false;
objDataAccess.GetConnection.Open();
SqlTransaction objTransaction = objDataAccess.GetConnection.BeginTransaction();
objTrans = objTransaction;
}
BudgetManager objManager = new BudgetManager();
ID = objManager.SaveBudget(objDB, objTrans);
if (!flagTransation)
objTrans.Commit();
return ID;
}
catch (Exception ex)
{
if (!flagTransation)
objTrans.Rollback();
throw ex;
}
finally
{
objDataAccess.GetConnection.Close();
}
}
public int SaveReworkCost(ReworkCostUI objUI, System.Data.SqlClient.SqlTransaction objTrans)
{
int ID = 0;
bool flagTransation = true;
ReworkCostDB objDB = new ReworkCostDB();
objDB.GroupID = objUI.GroupID;
objDB.MonthID = objUI.MonthID;
objDB.YearID = objUI.YearID;
objDB.ReworkCost_I_Year = objUI.ReworkCost_I_Year;
objDB.ReworkCost_II_Year = objUI.ReworkCost_II_Year;
objDB.ModelCategoryID = objUI.ModelCategoryID;
objDB.HMR_Range = objUI.HMR_Range;
DataAccessLayer objDataAccess = new DataAccessLayer();
try
{
if (objTrans == null)
{
flagTransation = false;
objDataAccess.GetConnection.Open();
SqlTransaction objTransaction = objDataAccess.GetConnection.BeginTransaction();
objTrans = objTransaction;
}
ReworkCostManager objManager = new ReworkCostManager();
ID=objManager.SaveReworkCost(objDB, objTrans);
if (!flagTransation)
objTrans.Commit();
return ID;
}
catch (Exception ex)
{
if (!flagTransation)
objTrans.Rollback();
throw ex;
}
finally
{
objDataAccess.GetConnection.Close();
}
}
/// <summary>
/// Creates a new Products repository
/// </summary>
public ProductsRepository()
{
this.dal = new DataAccessLayer();
}
public ActionResult UserProfile(string username)
{
person person = DataAccessLayer.getPersonDetails(username);
return(View(person));
}
public void Setup()
{
TestObjectFactory.SetFakedDataContext();
dataContext = DataAccessLayer.GetDataContext();
}
public static DataSet getTeams()
{
return(DataAccessLayer.getTeams());
}
public void getAvailableTableList()
{
Tablelist = new List <TableList>();
_dbLayerObj = new DataAccessLayer();
Tablelist = _dbLayerObj.getTableListToPlaceOrder();
}
public bool PlaceOrder(List <ViewOrderItems> Obj)
{
_dbLayerObj = new DataAccessLayer();
return(_dbLayerObj.PlaceOrder(Obj));
}
public static void toggleProductActivity(string productVendorUID)
{
DataAccessLayer.toggleProductActivity(productVendorUID);
}
public StudentBll()
{
_dal = new DataAccessLayer();
}
public void DeleteUploadedFilesBeforeSetDate(int cityId, DateTime startDate)
{
string sqlScript = "SELECT SchoolClassMaster.SchoolId, StudentUpload.StudentId," +
" StudentUpload.StagePlanId, StudentUpload.FileName," +
" StudentUpload.StudentUploadId,StudentUpload.ClassId FROM " +
" StudentUpload INNER JOIN StagePlan ON StudentUpload.StagePlanId = StagePlan.StagePlanId AND StagePlan.IsActive=1 " +
" INNER JOIN SchoolClassMaster ON SchoolClassMaster.ClassId = StudentUpload.ClassId INNER JOIN SchoolMaster ON " +
" SchoolClassMaster.SchoolId = SchoolMaster.SchoolId AND SchoolMaster.Isactive = 1 AND " +
" SchoolClassMaster.IsActive = 1 AND " +
" SchoolMaster.CityId = " + cityId +
" INNER JOIN CityAdminCities ON CityAdminCities.CityId = SchoolMaster.CityId AND CityAdminCities.CityAdminId = " +
HttpContext.Current.Session["UserId"] +
" WHERE StudentUpload.IsDeleted=0 " +
" AND StudentUpload.Uploadeddate <= '" + startDate.Year + "-" + startDate.Month + "-" + startDate.Day + " 00:00:00.400'";
int schoolId = 0;
int studentId = 0;
int stagePlanId = 0;
string fileName = string.Empty;
int studentUploadId = 0;
int classId = 0;
string folderPath = string.Empty;
try
{
_dt = DataAccessLayer.ReturnDataTable(sqlScript);
if (_dt != null && _dt.Rows != null &&
_dt.Rows.Count > 0)
{
foreach (DataRow item in _dt.Rows)
{
schoolId = Convert.ToInt32(item["SchoolId"]);
studentId = (item["StudentId"] != null ? Convert.ToInt32(item["StudentId"]) : 0);
stagePlanId = Convert.ToInt32(item["StagePlanId"]);
fileName = Convert.ToString(item["FileName"]);
studentUploadId = Convert.ToInt32(item["StudentUploadId"]);
classId = Convert.ToInt32(item["ClassId"]);
if (studentId > 0)
{
folderPath = HttpContext.Current.Server.MapPath("../GPXFiles/" + schoolId + "/" + classId + "/" + studentId);
}
else
{
folderPath = HttpContext.Current.Server.MapPath("../GPXFiles/" + schoolId + "/" + classId);
}
if (System.IO.File.Exists(folderPath + "/" + fileName))
{
System.IO.File.Delete(folderPath + "/" + fileName);
}
sqlScript = " DELETE FROM StudentUpload WHERE StudentUploadId = " + studentUploadId + ";" +
" UPDATE StagePlan SET Distance_Covered = 0 , Distance_Extra = 0 WHERE StagePlanId = " + stagePlanId;
DataAccessLayer.ExecuteNonQuery(sqlScript);
}
}
}
catch
{
}
}
public void UpdatePBI()
{
using (DataAccessLayer dbAccessLayer = new DataAccessLayer())
{
}
}
public void RemovePBI()
{
using (DataAccessLayer dbAccessLayer = new DataAccessLayer())
{
}
}
public static string SendReportMails(string LocationID, string LocationName, string ShiftName, string ShiftID, string Identifier, string WDRID, string MDate, string Remark)
{
try
{
string spname = "";
DataAccessLayer dal = new DataAccessLayer();
if (Identifier.ToLower().Contains("past"))
{
spname = "GetPastShift";
//dal.executesql("UPDATE WeekDayRoster set Remarks='" + Remark + "' where WDRID=" + WDRID + "");
}
if (Identifier.ToLower().Contains("current"))
{
spname = "GetCurrentShift";
//dal.executesql("UPDATE WeekDayRoster set Remarks='" + Remark + "' where WDRID=" + WDRID + "");
}
if (Identifier.ToLower().Contains("next"))
{
spname = "GetCurrentShift";
//dal.executesql("UPDATE WeekDayRoster set Remarks='" + Remark + "' where WDRID=" + WDRID + "");
}
string shiftid = "";
SqlParameter[] para = new SqlParameter[2];
para[0] = new SqlParameter("@LocationID", int.Parse(LocationID));
para[1] = new SqlParameter("@CurrDate", DateTime.Now);
DataTable dt = dal.executeprocedure(spname, para, false);
string MailTitle = "<table width='100%'><tr><td align='left'>Shift Report for Shift " + ShiftName + " on " + LocationName;
string MailContent = "<b>Shift Timings : </b>" + ShiftName + "<br />";
MailContent += "<b>Final Shift Deployment</b><br />";
MailContent += "<table border='1' style='width:100%;border-width:1px;border-collapse:collapse;'>";
for (int i = 0; i < dt.Rows.Count; i++)
{
MailContent += "<tr><td>" + dt.Rows[i][0].ToString().Split(new String[] { "||" }, StringSplitOptions.None)[0] + "</td></tr>";
}
MailContent += "</table><br/><br/>";
MailContent += "<b>Checkin Status<b><br/>";
MailContent += "<table border='1' style='width:100%;border-width:1px;border-collapse:collapse;'>";
string FromTime, ToTime = "";
FromTime = ShiftName.Split('-')[0].Trim();
ToTime = ShiftName.Split('-')[1].Trim();
DateTime[] dtarr = GetFromToFromColumnName(FromTime, ToTime);
for (int i = 0; i < dt.Rows.Count; i++)
{
MailContent += "<tr><td width='20%'>" + dt.Rows[i][0].ToString().Split(new String[] { "||" }, StringSplitOptions.None)[0] + "</td><td>";
DataTable dtr = CheckUserCheckedInStatus(dt.Rows[i][0].ToString().Split(new String[] { "||" }, StringSplitOptions.None)[2], dtarr[0], dtarr[1], LocationID);
if (dtr.Rows[0][0].ToString() == "Green")
{
MailContent += "<font style='font-color:green'>On Time : </font>Checked In At " + DateTime.Parse(dtr.Rows[0][1].ToString()).ToString("MM/dd/yyyy HH:mm:ss tt");
}
else if (dtr.Rows[0][0].ToString() == "Orange")
{
MailContent += "<font style='font-color:orange'>Late By : </font>" + decimal.Ceiling(decimal.Parse(DateTime.Parse(dtr.Rows[0][1].ToString()).Subtract(dtarr[0]).TotalMinutes.ToString())).ToString() + " minutes. Checked In At : " + DateTime.Parse(dtr.Rows[0][1].ToString()).ToString("MM/dd/yyyy HH:mm:ss tt");
}
else
{
TimeSpan ts = DateTime.Now.Subtract(dtarr[0]);
if (ts.TotalMinutes > 30)
{
MailContent += "<font style='font-color:maroon'>Not Checked In Yet</font>";
}
else
{
MailContent += "<font style='font-color:black'>Expected To Come</font>";
}
}
MailContent += "</td></tr>";
}
MailContent += "</table><br/><br/>";
MailContent += "<b>Check-Out Status<b><br/>";
MailContent += "<table border='1' style='width:100%;border-width:1px;border-collapse:collapse;'>";
for (int i = 0; i < dt.Rows.Count; i++)
{
MailContent += "<tr><td width='20%'>" + dt.Rows[i][0].ToString().Split(new String[] { "||" }, StringSplitOptions.None)[0] + "</td><td>";
DataTable dtr = CheckUserCheckedOutStatus(dt.Rows[i][0].ToString().Split(new String[] { "||" }, StringSplitOptions.None)[2], dtarr[0], dtarr[1], LocationID);
if (dtr.Rows[0][0].ToString() == "Green")
{
MailContent += "<font style='font-color:green'>On Time : </font>Checked Out At " + DateTime.Parse(dtr.Rows[0][1].ToString()).ToString("MM/dd/yyyy HH:mm:ss tt");
}
else if (dtr.Rows[0][0].ToString() == "Orange")
{
MailContent += "<font style='font-color:orange'>Checked Out Late By : </font>" + decimal.Ceiling(decimal.Parse(DateTime.Parse(dtr.Rows[0][1].ToString()).Subtract(dtarr[0]).TotalMinutes.ToString())).ToString() + " minutes. Checked In At : " + DateTime.Parse(dtr.Rows[0][1].ToString()).ToString("MM/dd/yyyy HH:mm:ss tt");
}
else
{
TimeSpan ts = DateTime.Now.Subtract(dtarr[1]);
if (ts.TotalMinutes > 30)
{
MailContent += "<font style='font-color:maroon'>Not Checked Out Yet</font>";
}
else
{
MailContent += "<font style='font-color:black'>Expected To Checkout</font>";
}
}
MailContent += "</td></tr>";
}
MailContent += "</table><br/><br/>";
MailContent += "<b>Remarks For This Shift<b><br/>";
MailContent += "<table border='1' style='width:100%;border-width:1px;border-collapse:collapse;'><tr><td>";
MailContent += Remark + "</td></tr></table></td></tr></table>";
//List<string> emailids = new List<string>();
//DataTable dte = dal.getdata("select EmailID from UserInformation where Role like '%director%' or Role like '%superuser%'");
//foreach (DataRow dr in dte.Rows)
//{
// emailids.Add(dr[0].ToString());
//}
//MailHelper.SendEmail(emailids, "*****@*****.**", "", "Shift Report for Shift " + ShiftName + " on " + LocationName, MailContent, true);
MailHelper.SendEmail("*****@*****.**", "*****@*****.**", "", "Shift Report for Shift " + ShiftName + " on " + LocationName, MailContent, true);
return("Success");
}
catch (Exception ex)
{
return("Failure");
}
}
protected void Page_Load(object sender, EventArgs e)
{
string strUsername = Request.QueryString["user"];
decimal PostCount;
decimal PostCountTotal;
MembershipUser user = Membership.GetUser(strUsername);
ProfileCommon userprofile = Profile.GetProfile(strUsername);
DataAccessLayer dal = new DataAccessLayer();
if (strUsername != "")
{
if (Membership.FindUsersByName(strUsername).Count == 0)
{
Response.Redirect("error.aspx?error=1");
}
}
else
{
Response.Redirect("error.aspx?error=1");
}
lblUsername1.Text = strUsername;
lblUsername2.Text = strUsername;
lblUsername3.Text = strUsername;
lblRank.Text = Roles.GetRolesForUser(strUsername).GetValue(0).ToString();
hplFindPostsByUser.Text = "Find alle posts skrevet af " + user.UserName;
hplFindPostsByUser.NavigateUrl = "search.aspx?author=" + user.UserName;
if (userprofile.Options.ShowEmail & user.Email != "")
{
hplEmail.Visible = true;
hplEmail.NavigateUrl = "mailto:" + user.Email;
}
if (userprofile.Messenger != "")
{
lblMsn.Visible = true;
lblMsn.Text = userprofile.Messenger;
}
lblCreated.Text = Utilities.GetDate(user.CreationDate, true, false);
if (user.IsOnline)
{
lblLastOnline.Text = "Online nu!";
}
else
{
lblLastOnline.Text = Utilities.GetDate(user.LastActivityDate, true, true);
}
dal.AddParameter("Author", strUsername, DbType.String);
PostCount = Convert.ToDecimal(dal.ExecuteScalar("SELECT COUNT(*) FROM Posts WHERE Author = @Author"));
dal.ClearParameters();
PostCountTotal = Convert.ToDecimal(dal.ExecuteScalar("SELECT COUNT(*) FROM Posts"));
lblPostCount.Text = PostCount.ToString();
lblPostPercentOfTotal.Text = Convert.ToString(Math.Round(((PostCount / PostCountTotal) * 100), 2));
lblPostsPerDay.Text = Convert.ToString(Math.Round((PostCount / Convert.ToInt32(Utilities.RemoveEndString(Convert.ToString(DateTime.Today.AddDays(1) - user.CreationDate.Date), ".00:00:00"))), 2));
lblLocation.Text = userprofile.Personal.Country;
if (userprofile.Homepage != "")
{
hplHomepage.Visible = true;
hplHomepage.NavigateUrl = userprofile.Homepage;
hplHomepage.Text = userprofile.Homepage;
}
lblOccupation.Text = userprofile.Occupation;
lblInterests.Text = userprofile.Interests;
}
public HomeController(DataAccessLayer dataService)
{
_dataService = dataService;
}
public static DataTable PS_SelectSchoolYear()
{
DataTable dt = DataAccessLayer.ExecuteTable("PS_SelectSchoolYear", CommandType.StoredProcedure);
return(dt);
}
public void OnPostGetData(string search)
{
DataAccessLayer.GetData(search, out objects);
return;
}
public static DataSet getActiveProducts()
{
return(DataAccessLayer.getActiveProducts());
}
private void txtUrdu_KeyDown(object sender, KeyEventArgs e)
{
try
{
// CTRL + S : Speak shortcut
if (e.Modifiers == Keys.Control && e.KeyCode == Keys.S)
{
synthesizer.SpeakStart(TextProcessing.ToUPSReps(txtUrdu.Text.Trim()));
playing = true;
}
// CTRL + F : Save to file shortcut
else if (e.Modifiers == Keys.Control && e.KeyCode == Keys.F)
{
synthesizer.SaveToFile(TextProcessing.ToUPSReps(txtUrdu.Text.Trim()), Directory.GetCurrentDirectory() + "\\Output Wav\\file.wav");
}
// CTRL + P : Parse/analyse text shortcut
else if (e.Modifiers == Keys.Control && e.KeyCode == Keys.P)
{
IconSync.Visible = true;
analyser = new Thread(new ThreadStart(analyseTextForUnrecognizedWords));
analyser.Start();
}
// CTRL + D : Diacritic suggestion pop-up
else if (e.Modifiers == Keys.Control && e.KeyCode == Keys.D)
{
listDiacriticsSuggestion.Items.Clear();
string selectedWord = txtUrdu.SelectedText.Trim();
// First try, if the selection is a WORD (simple, not with diacritics)
suggestedDiacritics = DataAccessLayer.SearchRecordsByWord(selectedWord);
if (suggestedDiacritics != null)
{
for (int i = 0; i < suggestedDiacritics.Count; i++)
{
listDiacriticsSuggestion.Items.Add(suggestedDiacritics[i].DiacriticRep);
}
}
// Second try, if the selection is a DIACRITICS REPRESENTATION (not simple word)
else
{
suggestedDiacritics = DataAccessLayer.SearchRecordsByWord(DataAccessLayer.UrduWordFromDiacriticRep(selectedWord));
if (suggestedDiacritics != null)
{
for (int i = 0; i < suggestedDiacritics.Count; i++)
{
listDiacriticsSuggestion.Items.Add(suggestedDiacritics[i].DiacriticRep);
}
}
}
// If there are some diacritics to select from
if (listDiacriticsSuggestion.Items.Count > 0)
{
listDiacriticsSuggestion.Visible = true;
listDiacriticsSuggestion.SelectedIndex = 0;
listDiacriticsSuggestion.Focus();
}
}
else
{
listDiacriticsSuggestion.Visible = false;
}
}
catch (Exception ex)
{
playing = false;
MessageBox.Show(ex.Message);
}
}
public DataSet GetMyProfileContent(int UserID)
{
_ds = DataAccessLayer.ExecuteStoredProcedureToRetDataSet(new SqlParameter[] { new SqlParameter("@CityAdminID", UserID) }, "SP_GET_CITYADMINID");
return(_ds);
}
// returns all user transactions
public static DataSet getAllUserTransactions()
{
return(DataAccessLayer.getAllUserTransactions());
}
public static bool updateProduct(ProductItem product)
{
return(DataAccessLayer.updateProduct(product));
}
public UsuariosperfisDal(DataAccessLayer dal)
{
DAL = dal;
}
/// <summary>
/// Get enrolled course info of a specific or all courses, a specific or all classes,
/// in current school or all schools
/// </summary>
/// <param name="courseName">empty string for all courses, or name of the selected course</param>
/// <param name="className">empty string for all classes, or name of the selected class</param>
/// <param name="inCurrentSchool">true for current school, or false for all schools</param>
/// <param name="onlyCurrentlyActive">true for showing only currently active courses, or false for all courses</param>
/// <returns>data of 'DataTable' type containing course name, course code, class name, school name, enrolled date</returns>
public DataTable GetEnrolledCourseInfo(string courseName = "", string className = "",
bool inCurrentSchool = true, bool onlyCurrentlyActive = true)
{
string selectClause = "";
string whereClause = "Teacher_ID = :ID";
List <CommandParameter> commandParameters = new List <CommandParameter>();
commandParameters.Add(new CommandParameter(":ID", ID));
if (courseName != "")
{
whereClause += " AND Course_Name = :courseName";
commandParameters.Add(new CommandParameter(":courseName", courseName));
}
else
{
selectClause = "Course_Name AS \"Course Name\", ";
}
selectClause += "Course_Code AS \"Course Code\"";
if (className != "")
{
whereClause += " AND Class_Name = :className";
commandParameters.Add(new CommandParameter(":className", className));
}
else
{
selectClause += ", Class_Name AS \"Class Name\"";
}
if (inCurrentSchool)
{
DataTable dataTableSchoolID = DataAccessLayer.SelectCommand(
DataAccessLayer.SelectCommandString("School_ID", LoginRole.ToString(), "ID = :ID"),
new CommandParameter(":ID", ID));
int schoolID = 0;
if (!dataTableSchoolID.Rows[0].IsNull(0))
{
schoolID = (int)(decimal)dataTableSchoolID.Rows[0][0];
}
whereClause += " AND School_ID = :schoolID";
commandParameters.Add(new CommandParameter(":schoolID", schoolID));
}
else
{
selectClause += ", School_Name AS \"School Name\"";
}
selectClause += ", (to_char(Enroll_Date, :date_format)) AS \"Enroll Date\"";
commandParameters.Insert(0, new CommandParameter(":date_format", OutputDateFormat));
if (onlyCurrentlyActive)
{
whereClause += " AND End_Date IS NULL";
}
else
{
selectClause += ", (to_char(End_Date, :date_format)) AS \"End Date\"";
commandParameters.Insert(1, new CommandParameter(":date_format", OutputDateFormat));
}
DataTable dataTable = DataAccessLayer.SelectCommand(DataAccessLayer.SelectCommandString(
selectClause, EnrollCourseTableName, whereClause,
orderByClause: "Course_Code, (to_char(Enroll_Date, 'yyyy/MM/dd'))"),
commandParameters.ToArray());
return(dataTable);
}
public JsonResult SearchUser(string username)
{
bool result = DataAccessLayer.isUserAvailable(username);
return(Json(result, JsonRequestBehavior.AllowGet));
}
public void AddPBI()
{
using (DataAccessLayer dbAccessLayer = new DataAccessLayer())
{
}
}
public void getAllTableList()
{
AllTablelist = new List <TableList>();
_dbLayerObj = new DataAccessLayer();
AllTablelist = _dbLayerObj.getTableList().Where(p => p.BookingStatus == "Booked").ToList();
}
public void GetPBIS()
{
using (DataAccessLayer dbAccessLayer = new DataAccessLayer())
{
}
}
// returns user tranactions from a certain user
public static DataSet getUserTransactions(Accounts userAccount)
{
return(DataAccessLayer.getUserTransactions(userAccount));
}
public void getFoodList()
{
_dbLayerObj = new DataAccessLayer();
Foodlist = _dbLayerObj.GetFoodItems();
}
public DataController()
{
objdata = new DataAccessLayer();
}
