public int CopyAndUpdateFields(int SourceID, int? NguoiDungID, string HovaTenNguoiNhan, string DiaChiNguoiNhan,
string EmailNguoiNhan, string DTDDNguoiNhan, string CMTND)
{
DataAccess objDataAccess = new DataAccess();
using (SqlCommand sqlCmd = new SqlCommand())
{
int iID = 0;
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.CommandText = "CopyAndUpdateFieldsDonHang";
sqlCmd.Parameters.Add("@SourceID", SqlDbType.Int).Value = SourceID;
sqlCmd.Parameters.Add("@NguoiDungID", SqlDbType.Int).Value = NguoiDungID;
sqlCmd.Parameters.Add("@HovaTenNguoiNhan", SqlDbType.NVarChar, 50).Value = HovaTenNguoiNhan;
sqlCmd.Parameters.Add("@DiaChiNguoiNhan", SqlDbType.NVarChar, 1000).Value = DiaChiNguoiNhan;
sqlCmd.Parameters.Add("@EmailNguoiNhan", SqlDbType.NVarChar, 50).Value = EmailNguoiNhan;
sqlCmd.Parameters.Add("@DTDDNguoiNhan", SqlDbType.NVarChar, 50).Value = DTDDNguoiNhan;
sqlCmd.Parameters.Add("@CMTND", SqlDbType.VarChar, 9).Value = CMTND;
iID = objDataAccess.ExecuteScalar(sqlCmd);
return iID;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
DataAccess dataaccess = new DataAccess();
using (SqlConnection Sqlcon = dataaccess.OpenConnection())
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = Sqlcon;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "InsertITJob";
cmd.Parameters.Add(new SqlParameter("@Exists", SqlDbType.Int));
cmd.Parameters.Add(new SqlParameter("@ITJobHeading", SqlDbType.VarChar, 100));
cmd.Parameters.Add(new SqlParameter("@ITJobDesc", SqlDbType.NVarChar, 50));
cmd.Parameters.Add(new SqlParameter("@ITJobDate", SqlDbType.DateTime));
cmd.Parameters["@ITJobHeading"].Value = txtITJob.Text;
cmd.Parameters["@ITJobDesc"].Value = txtITDesc.Text;
cmd.Parameters["@ITJobDate"].Value = System.DateTime.Now;
cmd.Parameters["@Exists"].Value = 0;
cmd.ExecuteNonQuery();
int retVal = (int)cmd.Parameters["@Exists"].Value;
}
}
LoadData();
PanelShow.Visible = true;
PanelAdd.Visible = false;
txtITJob.Text = "";
txtITDesc.Text = "";
}
protected void PopulateControls(DataAccess.Classes.Product pr)
{
ltrTenSanPham.Text = pr.ProductName;
ltrMaSanPham.Text = pr.ProductCode;
ltrOldPrice.Text = showMoney(pr.OldPrice).ToString();
ltrNewPrice.Text = showMoney(pr.NewPrice).ToString();
ltrDiscount.Text = pr.Discount.ToString();
ltrMoTa.Text = pr.Description;
ltrChiTietSanPham.Text = pr.Detail;
ltrXuatXu.Text = pr.Origin;
ltrBaoHanh.Text = pr.Guarantee;
List<Img> album = new List<Img>();
int idimg = 0;
string listimg = pr.Image;
string[] str = listimg.Split('\'');
foreach (var item in str)
{
if (item.ToString() != "")
{
Img dataimg = new Img();
dataimg.ID = idimg;
dataimg.Ten = pr.ProductName;
dataimg.HinhAnh = item.ToString();
album.Add(dataimg);
idimg++;
}
}
rptListImg.DataSource = album;
rptListImg.DataBind();
figureLarge.HRef = str.First().Trim().ToString();
//figureLarge.Title = pr.ProductName;
figureThumb.Src = ToThumb(str.First().Trim().ToString());
}
protected void btn_Save_Click1(object sender, EventArgs e)
{
DataAccess da = new DataAccess();
String res = da.updateAccountabilityInfo(Convert.ToInt32(hf_Accountability_Id.Value),
Convert.ToInt32(ddl_Acct_Next_Level.SelectedValue),
txt_Note.Text);
}
public void LoadPostedJob()
{
DataAccess dataaccess = new DataAccess();
using (SqlConnection Sqlcon = dataaccess.OpenConnection())
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = Sqlcon;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "getPostJob";
cmd.Parameters.Add(new SqlParameter("@Action", SqlDbType.VarChar, 50));
cmd.Parameters.Add(new SqlParameter("@CompanyId", SqlDbType.Int));
cmd.Parameters["@CompanyId"].Value = int.Parse(CompanyId);
cmd.Parameters["@Action"].Value = "select";
cmd.Parameters.Add("@Exists", SqlDbType.Int).Direction = ParameterDirection.Output;
SqlAda = new SqlDataAdapter(cmd);
ds = new DataSet();
SqlAda.Fill(ds);
GrdLoadJobCompany.DataSource = ds;
GrdLoadJobCompany.DataBind();
}
}
}
public void LoadQuali()
{
DataAccess dataaccess = new DataAccess();
using (SqlConnection Sqlcon = dataaccess.OpenConnection())
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = Sqlcon;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "GetQualification";
cmd.Parameters.Add(new SqlParameter("@Action", SqlDbType.VarChar, 50));
cmd.Parameters["@Action"].Value = "select";
cmd.Parameters.Add("@Exists", SqlDbType.Int).Direction = ParameterDirection.Output;
SqlAda = new SqlDataAdapter(cmd);
ds = new DataSet();
SqlAda.Fill(ds);
ddlQul.DataSource = ds;
ddlQul.DataTextField = "QualificationName";
ddlQul.DataValueField = "QualificationId";
ddlQul.DataBind();
if (ddlQul.Items.Count >= 1)
{
ListItem lstitem = new ListItem();
lstitem.Text = "[Select]";
lstitem.Value = "0";
ddlQul.Items.Insert(0, lstitem);
}
}
}
}
public void Assignment_SelectAddSelectDeleteSelect_OK()
{
using (System.Transactions.TransactionScope updateTransaction =
new System.Transactions.TransactionScope())
{
string connectionString = GetConnectionstring();
DataAccess d2 = new DataAccess(connectionString);
List<Assignment> assignmentsBefore = d2.GetAssignments();
Assignment assignment = new Assignment();
assignment.AssignmentId = -1;
assignment.AssignmentName = "asfdasfasdfsaf";
Assignment assignmentAfterSave = d2.SaveAssignment(assignment);
Assignment assignmentGetById = d2.GetAssignmentByID(assignment.AssignmentId);
Assert.AreNotEqual(assignment.AssignmentId, -1);
Assert.AreEqual(assignment.AssignmentName, assignmentGetById.AssignmentName);
List<Assignment> assignmentsAfterSave = d2.GetAssignments();
Assert.AreEqual(assignmentsAfterSave.Count, assignmentsBefore.Count + 1);
d2.DeleteAssignment(assignment.AssignmentId);
List<Assignment> assignmentsAfterDelete = d2.GetAssignments();
Assert.AreEqual(assignmentsBefore.Count, assignmentsAfterDelete.Count);
}
}
public void LoadStatus()
{
string StudentId = Session["StudentId"].ToString();
DataAccess dataaccess = new DataAccess();
using (SqlConnection Sqlcon = dataaccess.OpenConnection())
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = Sqlcon;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "getStatus";
cmd.Parameters.Add(new SqlParameter("@StudentId",SqlDbType.Int));
cmd.Parameters.Add(new SqlParameter("@Action", SqlDbType.VarChar, 50));
cmd.Parameters["@Action"].Value = "select";
cmd.Parameters["@StudentId"].Value = StudentId;
cmd.Parameters.Add("@Exists", SqlDbType.Int).Direction = ParameterDirection.Output;
SqlAda = new SqlDataAdapter(cmd);
ds = new DataSet();
SqlAda.Fill(ds);
GrdLoadJobCompany.DataSource = ds;
GrdLoadJobCompany.DataBind();
}
}
}
public void LoadRejectedCompany()
{
DataAccess dataaccess = new DataAccess();
using (SqlConnection Sqlcon = dataaccess.OpenConnection())
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = Sqlcon;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "getCompany";
cmd.Parameters.Add(new SqlParameter("@Action", SqlDbType.VarChar, 50));
cmd.Parameters.Add(new SqlParameter("@Active", SqlDbType.Int));
cmd.Parameters["@Active"].Value = 2;
cmd.Parameters["@Action"].Value = "select";
cmd.Parameters.Add("@Exists", SqlDbType.Int).Direction = ParameterDirection.Output;
SqlAda = new SqlDataAdapter(cmd);
ds = new DataSet();
SqlAda.Fill(ds);
grdRejected.DataSource = ds;
grdRejected.DataBind();
}
}
}
public Risk(DataAccess.Risk risk)
{
Id = risk.RiskId;
ProjectId = risk.ProjectId;
Title = risk.Title;
Description = risk.Description;
}
protected void btnEmployee_Click(object sender, EventArgs e)
{
Response.Write("{\"employees\": [");
string connectionstring = System.Configuration.ConfigurationManager.ConnectionStrings["OrtegaGoDaddy"].ConnectionString;
DataAccess da = new DataAccess();
System.Data.DataSet ds = da.getDataSet(connectionstring, "select employeeId, employeeFname, employeeLname from Ortega_Employees");
if (ds.Tables.Count <= 0 || ds.Tables[0].Rows.Count <= 0)
{
Response.Write("{}");
}
else
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
Response.Write("{\"employeeid\": \"" +
ds.Tables[0].Rows[i].ItemArray[0].ToString() + "\",\"firstname\":" + "\"" + ds.Tables[0].Rows[i].ItemArray[1].ToString() + "\"}");
if (i < ds.Tables[0].Rows.Count - 1)
{
Response.Write(",");
}
}
}
Response.Write("]}");
}
protected static void Copy(DataAccess.Semester obj, Semester newObj)
{
newObj.ID = obj.ID;
newObj.Begin = obj.Begin;
newObj.End = obj.End;
newObj.Name = obj.Name;
}
public int CopyAndUpdateFields(int SourceID, int? NguoiDungID, int? DauGiaID, decimal? TraGia,
DateTime? ThoiGianTraGia, string Bak1, string Bak2, int? Bak3, bool? Bak4)
{
DataAccess objDataAccess = new DataAccess();
using (SqlCommand sqlCmd = new SqlCommand())
{
int iID = 0;
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.CommandText = "CopyAndUpdateFieldsTraGia";
sqlCmd.Parameters.Add("@SourceID", SqlDbType.Int).Value = SourceID;
sqlCmd.Parameters.Add("@NguoiDungID", SqlDbType.Int).Value = NguoiDungID;
sqlCmd.Parameters.Add("@DauGiaID", SqlDbType.Int).Value = DauGiaID;
sqlCmd.Parameters.Add("@TraGia", SqlDbType.Money).Value = TraGia;
sqlCmd.Parameters.Add("@ThoiGianTraGia", SqlDbType.DateTime).Value = ThoiGianTraGia;
sqlCmd.Parameters.Add("@Bak1", SqlDbType.NVarChar, 50).Value = Bak1;
sqlCmd.Parameters.Add("@Bak2", SqlDbType.NVarChar, 50).Value = Bak2;
sqlCmd.Parameters.Add("@Bak3", SqlDbType.Int).Value = Bak3;
sqlCmd.Parameters.Add("@Bak4", SqlDbType.Bit).Value = Bak4;
iID = objDataAccess.ExecuteScalar(sqlCmd);
return iID;
}
}
internal IPassthroughAction CreateJobHistoryAction(Uri requestUri, DataAccess.Context.ClusterContainer container,
string subscriptionId)
{
Contract.AssertArgNotNull(requestUri, "requestUri");
Contract.AssertArgNotNull(requestUri.Segments, "requestUri.Segments");
var lastSegs =
requestUri.Segments.SkipWhile(i => i.ToLowerInvariant().Trim('/') != JobSubmissionConstants.ResourceExtentionName)
.ToList();
Contract.AssertArgNotNull(lastSegs, "lastSegs");
//If there is one segment, then we know that no JobId was passed, and we should list job history.
if (lastSegs.Count() == 1)
{
return new ListJobsPassthroughAction(container, subscriptionId);
}
//If there are two segments, then an jobId was passed, and we should get job details.
if (lastSegs.Count() == 2)
{
return new JobDetailsPassthroughAction(lastSegs.Last().Trim('/'), container, subscriptionId);
}
//If zero or more then two segments are present, then the request is invalid, and an action cannot be found to support it.
throw new PassthroughActionProcessingException(string.Format(JobSubmissionConstants.JobHistoryRequestActionNotFound, container.DnsName, requestUri));
}
public DataAccess.DataContracts.IPerson AddPerson(DataAccess.DataContracts.IPerson person)
{
_people.Add(person);
person.PersonId = _people.Count();
return person;
}
private bool YourValidationFunction(string UserName, string Password, int Active)
{
DataAccess dataaccess = new DataAccess();
SqlConnection Sqlcon = dataaccess.OpenConnection();
bool boolReturnValue = false;
String SQLQuery = "SELECT CompanyId, CompanyEmail, Password, Active FROM CompanyMaster where CompanyEmail='"+Login1.UserName+"' and Password='******' and Active='"+Active+"'";
SqlCommand command = new SqlCommand(SQLQuery, Sqlcon);
SqlDataReader Dr;
Dr = command.ExecuteReader();
while (Dr.Read())
{
if ((UserName == Dr["CompanyEmail"].ToString()) & (Password == Dr["Password"].ToString()) )
{
Session["CompanyId"] = Dr["CompanyId"].ToString();
boolReturnValue = true;
}
Dr.Close();
return boolReturnValue;
}
return boolReturnValue;
}
/// <summary>
/// Map an ORM Show to a contract Show
/// </summary>
/// <param name="_show"></param>
/// <returns></returns>
internal static Contracts.Show MapShow(DataAccess.Show _show)
{
var result = new Contracts.Show()
{
ShowID = _show.ID,
Title = _show.Title,
Category = _show.Category,
Description = _show.Description,
Cast = _show.Cast,
Duration = new TimeSpan(0, (_show.Duration ?? 0), 0),
DetailsLink = new Uri("http://empty.com"),
Preview = new Uri("http://empty.com"),
Logo = _show.Logo
};
if (!string.IsNullOrEmpty(_show.Url))
result.DetailsLink = new Uri(_show.Url);
if (!string.IsNullOrEmpty(_show.Preview))
result.Preview = new Uri(_show.Preview);
result.Events = _show.Events.Select(e => CreateEventForShow(e, result)).ToArray();
return result;
}
public int CopyAndUpdateFields(int SourceID, int? DonHangID, int? SanPhamID, string TenSanPham,
decimal? GiaSanPham, int? SoLuong, decimal? TongTien, int? CuaHangID,
string TenCuaHang)
{
DataAccess objDataAccess = new DataAccess();
using (SqlCommand sqlCmd = new SqlCommand())
{
int iID = 0;
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.CommandText = "CopyAndUpdateFieldsChiTietDonHang";
sqlCmd.Parameters.Add("@SourceID", SqlDbType.Int).Value = SourceID;
sqlCmd.Parameters.Add("@DonHangID", SqlDbType.Int).Value = DonHangID;
sqlCmd.Parameters.Add("@SanPhamID", SqlDbType.Int).Value = SanPhamID;
sqlCmd.Parameters.Add("@TenSanPham", SqlDbType.NVarChar, 50).Value = TenSanPham;
sqlCmd.Parameters.Add("@GiaSanPham", SqlDbType.Money).Value = GiaSanPham;
sqlCmd.Parameters.Add("@SoLuong", SqlDbType.Int).Value = SoLuong;
sqlCmd.Parameters.Add("@TongTien", SqlDbType.Money).Value = TongTien;
sqlCmd.Parameters.Add("@CuaHangID", SqlDbType.Int).Value = CuaHangID;
sqlCmd.Parameters.Add("@TenCuaHang", SqlDbType.NVarChar, 100).Value = TenCuaHang;
iID = objDataAccess.ExecuteScalar(sqlCmd);
return iID;
}
}
public Donation CreateDonation(Donation donation)
{
using (var db = new DataAccess())
{
db.CreateStoredProcCommand("dbo.CreateDonation");
db.AddInputParameter("@DonationProviderId", donation.DonationProviderId);
db.AddInputParameter("@UserId", donation.UserId);
db.AddInputParameter("@ExternalId", donation.ExternalId);
db.AddInputParameter("@ExternalStatus", donation.ExternalStatus);
db.AddInputParameter("@IsCompleted", donation.IsCompleted);
db.AddInputParameter("@CountryId", donation.CountryId);
db.AddInputParameter("@StateId", donation.StateId);
db.AddInputParameter("@CityId", donation.CityId);
db.AddInputParameter("@Amount", donation.Amount);
db.AddInputParameter("@Currency", donation.Currency);
db.AddInputParameter("@UserMessage", donation.UserMessage);
db.AddInputParameter("@ProviderData", donation.ProviderXml);
db.AddInputParameter("@DonationSubscriptionId", donation.DonationSubscriptionId);
db.AddInputParameter("@TransactionType", donation.TransactionType);
db.AddOutputParameter("@DonationId", DbType.Int32);
try
{
db.ExecuteNonQuery();
donation.DonationId = db.GetParameterValue<int>("@DonationId");
}
catch (Exception ex)
{
Log.Error("Error while creating donation.", ex);
throw;
}
}
return donation;
}
public int CopyAndUpdateFields(int SourceID, int? QuangCaoID, int? ViTriQuangCao, int? NhomSanPhamID,
int? khuvucid, int? bak)
{
DataAccess objDataAccess = new DataAccess();
using (SqlCommand sqlCmd = new SqlCommand())
{
int iID = 0;
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.CommandText = "CopyAndUpdateFieldsViTriQuangCao";
sqlCmd.Parameters.Add("@SourceID", SqlDbType.Int).Value = SourceID;
sqlCmd.Parameters.Add("@QuangCaoID", SqlDbType.Int).Value = QuangCaoID;
sqlCmd.Parameters.Add("@ViTriQuangCao", SqlDbType.Int).Value = ViTriQuangCao;
sqlCmd.Parameters.Add("@NhomSanPhamID", SqlDbType.Int).Value = NhomSanPhamID;
sqlCmd.Parameters.Add("@khuvucid", SqlDbType.Int).Value = khuvucid;
sqlCmd.Parameters.Add("@bak", SqlDbType.Int).Value = bak;
iID = objDataAccess.ExecuteScalar(sqlCmd);
return iID;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if(!IsPostBack)
{
DataAccess data = new DataAccess();
ddChuyenMuc.DataSource = data.GetAllChuyenMuc();
ddChuyenMuc.DataValueField = "id";
ddChuyenMuc.DataTextField = "tenCM";
ddChuyenMuc.DataBind();
BaiViet bv = new BaiViet();
bv = data.GetABaiViet(Convert.ToInt32(Request.QueryString["id"]));
txtTieuDe.Text = bv.tieuDe.ToString();
ddChuyenMuc.Text = bv.id_cm.ToString();
oldHinhAnh.ImageUrl = bv.hinhAnh.ToString();
txtNoiDung.Text = bv.noiDung;
txtMota.Text = bv.moTa;
txtTuKhoa.Text = bv.tuKhoa;
if (bv.trangThai == 1) rd1.Checked = true;
else rd0.Checked = true;
//if (rdv.Equals(1)
//{
// rdtrangThai.Items.FindByValue("1").Selected = true;
// rdtrangThai.Items.FindByValue("0").Selected = false;
//}
//else
//{
// rdtrangThai.Items.FindByValue("0").Selected = true;
// rdtrangThai.Items.FindByValue("1").Selected = false;
//}
}
}
public void LoadJobDetails()
{
DataAccess dataaccess = new DataAccess();
SqlConnection Sqlcon = dataaccess.OpenConnection();
String SQLQuery = "SELECT p.PostJobId, p.JobTitle,p.JobDesc,p.QulificationId,p.SpecificationId,p.ExpInYear,p.ExpInMonth,p.JobTypeId,p.CompanyId,p.Active,p.Location,C.CompanyName,C.CompanyLogo,Q.QualificationName from PostJobMaster as p inner join CompanyMaster as C on C.CompanyId = p.CompanyId inner join QualificationMaster as Q on Q.QualificationId=p.QulificationId where p.CompanyId =" + PostJobId + "";
SqlCommand command = new SqlCommand(SQLQuery, Sqlcon);
SqlDataReader Dr;
Dr = command.ExecuteReader();
while (Dr.Read())
{
lblJobTitle.Text = Dr["JobTitle"].ToString();
lblCompName.Text = Dr["CompanyName"].ToString();
imgCompLogo.ImageUrl = "~/CompanyLogo/" + Dr["CompanyLogo"].ToString();
lblQuil.Text = Dr["QualificationName"].ToString();
lblExpYear.Text = Dr["ExpInYear"].ToString();
lblExpMonths.Text = Dr["ExpInMonth"].ToString();
lblLocation.Text = Dr["Location"].ToString();
lblJobDesc.Text = Dr["JobDesc"].ToString();
}
Dr.Close();
}
/// <summary>
/// Method that get the correct passthrough action based on the given request.
/// </summary>
/// <param name="resourceExtension">The resource extention that was requested (ie. "/jobs").</param>
/// <param name="request">The actual http request.</param>
/// <param name="container">The container that action should be preformed on.</param>
/// <param name="subscriptionId">The subscription Id that made the request.</param>
/// <returns></returns>
public IPassthroughAction GetPassthroughAction(string resourceExtension, HttpRequestMessage request,
DataAccess.Context.ClusterContainer container, string subscriptionId)
{
Contract.AssertArgNotNull(request,"request");
Contract.AssertArgNotNull(request.RequestUri,"request.RequestUri");
switch (resourceExtension.ToLowerInvariant())
{
case "jobs":
switch (request.Method.ToString().ToLowerInvariant())
{
case "put":
var requestPayload = GetRequestPayload(request);
var jobRequest = jobRequestFactory.CreateJobRequest(requestPayload);
if (jobRequest == null)
{
throw new PassthroughActionProcessingException(string.Format(JobSubmissionConstants.InvalidJobRequestLogMessage, requestPayload));
}
return CreateJobRequestAction(jobRequest, container, subscriptionId);
case "get":
return CreateJobHistoryAction(request.RequestUri, container, subscriptionId);
}
break;
}
throw new PassthroughActionProcessingException(string.Format(JobSubmissionConstants.PassThroughActionCreationFailedLogMessage, resourceExtension,request.Method));
}
public int CopyAndUpdateFields(int SourceID, int? SanPhamID, string DuongDan, string Bak1, string Bak2,
int? Bak3, int? SanPhamMauID)
{
DataAccess objDataAccess = new DataAccess();
using (SqlCommand sqlCmd = new SqlCommand())
{
int iID = 0;
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.CommandText = "CopyAndUpdateFieldsAnh";
sqlCmd.Parameters.Add("@SourceID", SqlDbType.Int).Value = SourceID;
sqlCmd.Parameters.Add("@SanPhamID", SqlDbType.Int).Value = SanPhamID;
sqlCmd.Parameters.Add("@DuongDan", SqlDbType.NVarChar, 100).Value = DuongDan;
sqlCmd.Parameters.Add("@Bak1", SqlDbType.NVarChar, 50).Value = Bak1;
sqlCmd.Parameters.Add("@Bak2", SqlDbType.NVarChar, 50).Value = Bak2;
sqlCmd.Parameters.Add("@Bak3", SqlDbType.Int).Value = Bak3;
sqlCmd.Parameters.Add("@SanPhamMauID", SqlDbType.Int).Value = SanPhamMauID;
iID = objDataAccess.ExecuteScalar(sqlCmd);
return iID;
}
}
/// <summary>
/// Constructor (Solo para uso Externo) de la Clase BaseClass.
/// </summary>
/// <param name="bizSrv"></param>
/// <param name="callingAssembly"></param>
/// <param name="creteDBConnection"></param>
protected BaseClass(BizServer bizSrv, string callingAssembly, bool createDBConnection)
{
if (callingAssembly == Assembly.GetExecutingAssembly().GetName().Name)
throw new Exception("This constructor must be used only from external assembly.");
try
{
if (bizSrv == null)
throw new ArgumentNullException("BizServer");
_oBizServer = bizSrv;
if (createDBConnection)
{
_oDataAccess = EstudioDelFutbol.Data.ADONETDataAccess.DataAccess.GetSqlClientWrapper(bizSrv.DataBase.ConnectionString, new CacheHelper(), bizSrv.Log);
if (bizSrv.Usuario != null)
_oDataAccess.TrackingInfo = bizSrv.Usuario.RemoteEndpoint;
}
}
catch (Exception ex)
{
throw ex;
}
}
public static string CalculateQRests(int SpareID)
{
SpareView spare = SpareContainer.Instance.GetSpare(SpareID);
DataAccess da = new DataAccess();
string xml = "";
List<warehouse> warehouses = da.GetWarehouses();
List<double> Qs = new List<double>();
xml += "<r>";
// Q total
double q0 = spare.QRest.HasValue ? spare.QRest.Value : 0;
Qs.Add(q0);
// all actual incomes
List<SpareInSpareIncomeView> incomes = da.GetActualIncomes();
// Q by warehouses
foreach (warehouse w in warehouses)
{
// incomes by warehouse
decimal? q = incomes.Where(i => (i.WarehouseID == w.id && i.SpareID == SpareID)).Sum(i => i.QRest);
if (q.HasValue)
Qs.Add((double)q.Value);
else
Qs.Add(0);
}
foreach (double q in Qs)
xml += "<w q=\"" + q.ToString() + "\"/>";
xml += @"</r>";
// save sml to db
da.SpareEdit(SpareID, xml);
return xml;
}
public int CopyAndUpdateFields(int SourceID, string LoaiNguoiDung, int? SapXep, string Bak1, string Bak2,
int? Bak3)
{
DataAccess objDataAccess = new DataAccess();
using (SqlCommand sqlCmd = new SqlCommand())
{
int iID = 0;
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.CommandText = "CopyAndUpdateFieldsLoaiNguoiDung";
sqlCmd.Parameters.Add("@SourceID", SqlDbType.Int).Value = SourceID;
sqlCmd.Parameters.Add("@LoaiNguoiDung", SqlDbType.NVarChar, 50).Value = LoaiNguoiDung;
sqlCmd.Parameters.Add("@SapXep", SqlDbType.Int).Value = SapXep;
sqlCmd.Parameters.Add("@Bak1", SqlDbType.NVarChar, 50).Value = Bak1;
sqlCmd.Parameters.Add("@Bak2", SqlDbType.NVarChar, 50).Value = Bak2;
sqlCmd.Parameters.Add("@Bak3", SqlDbType.Int).Value = Bak3;
iID = objDataAccess.ExecuteScalar(sqlCmd);
return iID;
}
}
public int CopyAndUpdateFields(int SourceID, string TenKhuVuc, string GhiChu, int? SapXep, bool? HienThi,
string Bak1, string Bak2, int? Bak3)
{
DataAccess objDataAccess = new DataAccess();
using (SqlCommand sqlCmd = new SqlCommand())
{
int iID = 0;
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.CommandText = "CopyAndUpdateFieldsKhuVuc";
sqlCmd.Parameters.Add("@SourceID", SqlDbType.Int).Value = SourceID;
sqlCmd.Parameters.Add("@TenKhuVuc", SqlDbType.NVarChar, 50).Value = TenKhuVuc;
sqlCmd.Parameters.Add("@GhiChu", SqlDbType.NVarChar, 1000).Value = GhiChu;
sqlCmd.Parameters.Add("@SapXep", SqlDbType.Int).Value = SapXep;
sqlCmd.Parameters.Add("@HienThi", SqlDbType.Bit).Value = HienThi;
sqlCmd.Parameters.Add("@Bak1", SqlDbType.NVarChar, 50).Value = Bak1;
sqlCmd.Parameters.Add("@Bak2", SqlDbType.NVarChar, 50).Value = Bak2;
sqlCmd.Parameters.Add("@Bak3", SqlDbType.Int).Value = Bak3;
iID = objDataAccess.ExecuteScalar(sqlCmd);
return iID;
}
}
protected void Page_Load(object sender, EventArgs e)
{
Response.Write("{\"employees\": [");
string connectionstring =
System.Configuration.ConfigurationManager.ConnectionStrings["HuberGoDaddy"].ConnectionString;
DataAccess da = new DataAccess();
System.Data.DataSet ds = da.getDataSet(connectionstring,
"select employeeid, firstname, lastname from huber_employees");
//if there are no employees returned
if (ds.Tables.Count <= 0 || ds.Tables[0].Rows.Count <= 0)
{
Response.Write("{}");
}
else
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
Response.Write("{\"employeeid\": \"" +
ds.Tables[0].Rows[i].ItemArray[0].ToString() +
"\",\"firstname\":" +
"\"" + ds.Tables[0].Rows[i].ItemArray[1].ToString() + "\"}");
if (i<ds.Tables[0].Rows.Count-1)
{
Response.Write(",");
}
}
}
Response.Write("]}");
}
protected void Unnamed_ServerClick(object sender, EventArgs e)
{
String top = ettop.Value;
String year = etyear.Value;
int igender = gender.SelectedIndex;
String sgender = null;
switch (igender)
{
case 0:
sgender = "both";
break;
case 1:
sgender = "male";
break;
case 2:
sgender = "female";
break;
}
DataAccess da = new DataAccess();
resulttop = da.SelectTop(year, top, sgender);
topranking = new List<List<Name>>();
topranking.Add(da.SelectTop(year, "10", sgender));
topranking.Add(da.SelectTop(year, "50", sgender));
topranking.Add(da.SelectTop(year, "100", sgender));
topranking.Add(da.SelectTop(year, "250", sgender));
}
public DataTable getList()
{
string sql = "select * from std_parent";
return(DataAccess.ExecuteSQLQuery(sql));
}
public ICollection <ErrorHandler> BulkInsert(string argExcelPath, string argQuery, string strTableName, string argFileExt, string argUserName, string argClientCode)
{
DataTable dtExcel = null;
VendorGroup ObjVendorGroup = null;
string xConnStr = "";
string strSheetName = "";
DataSet dsExcel = new DataSet();
DataTable dtTableSchema = new DataTable();
OleDbConnection objXConn = null;
OleDbDataAdapter objDataAdapter = new OleDbDataAdapter();
List <ErrorHandler> lstErr = new List <ErrorHandler>();
if (argFileExt.ToString() == ".xls")
{
xConnStr = "Provider=Microsoft.Jet.OLEDB.4.0;" +
"Data Source=" + argExcelPath.Trim() + ";" +
"Extended Properties=Excel 8.0";
}
else
{
xConnStr = "Provider=Microsoft.ACE.OLEDB.12.0;" +
"Data Source=" + argExcelPath.Trim() + ";" +
"Extended Properties=Excel 12.0";
}
try
{
objXConn = new OleDbConnection(xConnStr);
objXConn.Open();
dtTableSchema = objXConn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
if (argFileExt.ToString() == ".xls")
{
strSheetName = Convert.ToString(dtTableSchema.Rows[0]["TABLE_NAME"]);
}
else
{
strSheetName = Convert.ToString(dtTableSchema.Rows[0]["TABLE_NAME"]);
if (strSheetName.IndexOf(@"_xlnm#_FilterDatabase") >= 0)
{
strSheetName = Convert.ToString(dtTableSchema.Rows[1]["TABLE_NAME"]);
}
}
argQuery = argQuery + " [" + strSheetName + "]";
OleDbCommand objCommand = new OleDbCommand(argQuery, objXConn);
objDataAdapter.SelectCommand = objCommand;
objDataAdapter.Fill(dsExcel);
dtExcel = dsExcel.Tables[0];
/*****************************************/
DataAccess da = new DataAccess();
da.Open_Connection();
da.BEGIN_TRANSACTION();
try
{
foreach (DataRow drExcel in dtExcel.Rows)
{
ObjVendorGroup = new VendorGroup();
ObjVendorGroup.VendGroupCode = Convert.ToString(drExcel["VendGroupCode"]).Trim();
ObjVendorGroup.VendGroupDesc = Convert.ToString(drExcel["VendGroupDesc"]).Trim();
ObjVendorGroup.CreatedBy = Convert.ToString(argUserName);
ObjVendorGroup.ModifiedBy = Convert.ToString(argUserName);
ObjVendorGroup.ClientCode = Convert.ToString(argClientCode);
SaveVendorGroup(ObjVendorGroup, da, lstErr);
foreach (ErrorHandler objerr in lstErr)
{
if (objerr.Type == "E")
{
da.ROLLBACK_TRANSACTION();
break;
}
}
}
da.COMMIT_TRANSACTION();
}
catch (Exception ex)
{
if (da != null)
{
da.ROLLBACK_TRANSACTION();
}
objErrorHandler.Type = ErrorConstant.strAboartType;
objErrorHandler.MsgId = 0;
objErrorHandler.Module = ErrorConstant.strInsertModule;
objErrorHandler.ModulePart = ErrorConstant.strMasterModule;
objErrorHandler.Message = ex.Message.ToString();
objErrorHandler.RowNo = 0;
objErrorHandler.FieldName = "";
objErrorHandler.LogCode = "";
lstErr.Add(objErrorHandler);
}
finally
{
if (da != null)
{
da.Close_Connection();
da = null;
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
objXConn.Close();
}
return(lstErr);
}
public userController()
{
this._objAuthtication = new DataAccess();
}
private void btnConfirm_Click(object sender, EventArgs e)
{
string currentPassword;
string newPassword;
string newPasswordConfirm;
if (string.Equals(currentItem.Username, Program.username))
{
// Check current password
currentPassword = txtPassword.Text;
if (currentPassword == "")
{
//lblMessPassword.Text = "Nhập mật khẩu hiện tại";
MessageBox.Show("Nhập mật khẩu hiện tại",
"Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtPassword.Focus();
return;
}
else
{
DataAccess da = new DataAccess();
Nhanvien employee = da.getNhanvienbyUserName(currentItem.Username);
if (!string.Equals(currentPassword, employee.Password))
{
//lblMessPassword.Text = "Mật khẩu không đúng!";
MessageBox.Show("Mật khẩu không đúng!",
"Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtPassword.Focus();
txtPassword.SelectAll();
txtNewPassword.Text = "";
txtNewPasswordConfirm.Text = "";
return;
}
}
}
// Check new password
newPassword = txtNewPassword.Text;
newPasswordConfirm = txtNewPasswordConfirm.Text;
if (newPassword == "")
{
//lblMessPassword.Text = "Nhập mật khẩu hiện tại";
MessageBox.Show("Vui lòng nhập Mật khẩu mới",
"Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
txtNewPassword.Focus();
return;
}
if (newPasswordConfirm == "")
{
//lblMessPassword.Text = "Nhập mật khẩu hiện tại";
MessageBox.Show("Vui lòng nhập Xác nhận lại Mật khẩu mới",
"Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
txtNewPasswordConfirm.Focus();
return;
}
if (String.Equals(newPassword, newPasswordConfirm))
{
DataAccess da = new DataAccess();
Nhanvien employee = da.getNhanvienbyUserName(currentItem.Username);
employee.Password = newPassword;
//employee.PasswordHint = txtPasswordHint.Text;
if (da.updateNhanvien(employee))
{
MessageBox.Show("Thay đổi mật khẩu thành công",
"Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
txtPassword.Text = "";
txtNewPassword.Text = "";
txtNewPasswordConfirm.Text = "";
txtPasswordHint.Text = "";
}
else
{
MessageBox.Show("Mật khẩu mới và Mật khẩu xác nhận phải giống nhau!",
"Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
//lblMessPasswordRetype.Text = "Mật khẩu mới và Mật khẩu xác nhận phải giống nhau!";
txtNewPasswordConfirm.Text = "";
txtNewPassword.Focus();
txtNewPassword.SelectAll();
}
}
public bool blnIsVendorGroupExists(string argVendGroupCode, string argClientCode, DataAccess da)
{
bool IsVendorGroupExists = false;
DataSet ds = new DataSet();
ds = GetVendorGroup(argVendGroupCode, argClientCode, da);
if (ds.Tables[0].Rows.Count > 0)
{
IsVendorGroupExists = true;
}
else
{
IsVendorGroupExists = false;
}
return(IsVendorGroupExists);
}
public Meta_reductionruledetailview(DataAccess Conn, MetaDataDispatcher Dispatcher)
:
base(Conn, Dispatcher, "reductionruledetailview")
{
ListingTypes.Add("default");
}
public ICollection <ErrorHandler> SaveVendorGroup(VendorGroup argVendorGroup)
{
List <ErrorHandler> lstErr = new List <ErrorHandler>();
DataAccess da = new DataAccess();
try
{
if (blnIsVendorGroupExists(argVendorGroup.VendGroupCode, argVendorGroup.ClientCode) == false)
{
da.Open_Connection();
da.BEGIN_TRANSACTION();
InsertVendorGroup(argVendorGroup, da, lstErr);
foreach (ErrorHandler objerr in lstErr)
{
if (objerr.Type == "E")
{
da.ROLLBACK_TRANSACTION();
return(lstErr);
}
}
da.COMMIT_TRANSACTION();
}
else
{
da.Open_Connection();
da.BEGIN_TRANSACTION();
UpdateVendorGroup(argVendorGroup, da, lstErr);
foreach (ErrorHandler objerr in lstErr)
{
if (objerr.Type == "E")
{
da.ROLLBACK_TRANSACTION();
return(lstErr);
}
}
da.COMMIT_TRANSACTION();
}
}
catch (Exception ex)
{
if (da != null)
{
da.ROLLBACK_TRANSACTION();
}
objErrorHandler.Type = ErrorConstant.strAboartType;
objErrorHandler.MsgId = 0;
objErrorHandler.Module = ErrorConstant.strInsertModule;
objErrorHandler.ModulePart = ErrorConstant.strMasterModule;
objErrorHandler.Message = ex.Message.ToString();
objErrorHandler.RowNo = 0;
objErrorHandler.FieldName = "";
objErrorHandler.LogCode = "";
lstErr.Add(objErrorHandler);
}
finally
{
if (da != null)
{
da.Close_Connection();
da = null;
}
}
return(lstErr);
}
public Meta_accountvar(DataAccess Conn, MetaDataDispatcher Dispatcher) :
base(Conn, Dispatcher, "accountvar")
{
EditTypes.Add("default");
ListingTypes.Add("default");
}
public void contactDetailsSetter(int id)
{
contactDetails.Visibility = Visibility.Visible;
newContact.Visibility = Visibility.Hidden;
DataAccess da = new DataAccess();
ContactViewModel cvm = da.contactDetailsList(id);
if (!cvm.image.Equals(""))
{
try
{
ImageBrush brush = new ImageBrush(new BitmapImage(new Uri(cvm.image, UriKind.Absolute)));
image.Background = brush;
}
catch (Exception e)
{
MessageBox.Show(e.Message);
}
}
else
{
ImageBrush brush = new ImageBrush(new BitmapImage(new Uri("pack://application:,,,/PhoneBook;component/Image/Icon/uid.jpg", UriKind.Absolute)));
image.Background = brush;
}
lblContactName.Content = cvm.name;
Number1.Text = cvm.num1;
if (cvm.num2.Equals(""))
{
Number2.Visibility = Visibility.Collapsed;
}
else
{
Number2.Text = cvm.num2;
Number2.Visibility = Visibility.Visible;
}
if (cvm.num3.Equals(""))
{
Number3.Visibility = Visibility.Collapsed;
}
else
{
Number3.Text = cvm.num3;
Number3.Visibility = Visibility.Visible;
}
if (cvm.num4.Equals(""))
{
Number4.Visibility = Visibility.Collapsed;
}
else
{
Number4.Text = cvm.num4;
Number4.Visibility = Visibility.Visible;
}
if (cvm.num5.Equals(""))
{
Number5.Visibility = Visibility.Collapsed;
}
else
{
Number5.Text = cvm.num5;
Number5.Visibility = Visibility.Visible;
}
if (cvm.num6.Equals(""))
{
Number6.Visibility = Visibility.Collapsed;
}
else
{
Number6.Text = cvm.num6;
Number6.Visibility = Visibility.Visible;
}
if (cvm.email.Equals(""))
{
email.Visibility = Visibility.Collapsed;
lblemail.Visibility = Visibility.Collapsed;
}
else
{
email.Text = cvm.email;
email.Visibility = Visibility.Visible;
lblemail.Visibility = Visibility.Visible;
}
if (cvm.street.Equals(""))
{
street.Visibility = Visibility.Collapsed;
lblstreet.Visibility = Visibility.Collapsed;
}
else
{
street.Text = cvm.street;
street.Visibility = Visibility.Visible;
lblstreet.Visibility = Visibility.Visible;
}
if (cvm.city.Equals(""))
{
city.Visibility = Visibility.Collapsed;
lblcity.Visibility = Visibility.Collapsed;
}
else
{
city.Text = cvm.city;
city.Visibility = Visibility.Visible;
lblcity.Visibility = Visibility.Visible;
}
if (cvm.zip.Equals(""))
{
zip.Visibility = Visibility.Collapsed;
lblzip.Visibility = Visibility.Collapsed;
}
else
{
zip.Text = cvm.zip;
zip.Visibility = Visibility.Visible;
lblzip.Visibility = Visibility.Visible;
}
if (cvm.state.Equals(""))
{
state.Visibility = Visibility.Collapsed;
lblstate.Visibility = Visibility.Collapsed;
}
else
{
state.Text = cvm.state;
state.Visibility = Visibility.Visible;
lblstate.Visibility = Visibility.Visible;
}
if (cvm.country.Equals(""))
{
country.Visibility = Visibility.Collapsed;
lblcountry.Visibility = Visibility.Collapsed;
}
else
{
country.Text = cvm.country;
country.Visibility = Visibility.Visible;
lblcountry.Visibility = Visibility.Visible;
}
if (cvm.group.Equals(""))
{
group.Visibility = Visibility.Collapsed;
lblgroup.Visibility = Visibility.Collapsed;
}
else
{
group.Text = cvm.group;
group.Visibility = Visibility.Visible;
lblgroup.Visibility = Visibility.Visible;
}
if (cvm.about.Equals("null"))
{
about.Visibility = Visibility.Collapsed;
lblabout.Visibility = Visibility.Collapsed;
}
else
{
about.Document.Blocks.Clear();
about.Document.Blocks.Add(new Paragraph(new Run(cvm.about)));
about.Visibility = Visibility.Visible;
lblabout.Visibility = Visibility.Visible;
}
}
static TaskController()
{
secret = "xxOvertimexx";
dataAccess = new DataAccess();
}
public IdentityUserDataGridHandler(Pages.ModelPage modelPage, DataAccess <TContract> dataAccess) : base(modelPage, dataAccess)
{
}
public override IBase <VideoComment> GetDal()
{
return(DataAccess.CreateVideoComment());
}
protected void brnAdd_Click(object sender, EventArgs e)
{
if (Session["SysPasswordOk"] == null)
{
lblmessages.Text =
"Prima di procedere alla configurazione, inserire la Password di abilitazione alla configurazione.";
return;
}
string error = "";
DataAccess sys = GetVars.GetSystemDataAccess(this, out error);
if (sys == null)
{
lblmessages.Text = "Servizio Web non installato correttamente.";
if (error != null)
{
lblmessages.Text += error;
}
return;
}
string dip = txtDip.Text;
string codice = txtCodice.Text;
string ip = txtIP.Text;
string db = txtDB.Text;
string user = txtUser.Text;
string pwd = txtPWD.Text;
Easy_DataAccess Conn = new Easy_DataAccess(
"mydsn", ip, db, user, pwd, user, pwd, DateTime.Now.Year, DateTime.Now);
if (Conn == null)
{
lblmessages.Text = "Non è stato possibile collegarsi al server.";
return;
}
Conn.Open();
if (Conn.OpenError)
{
lblmessages.Text = "Non è stato possibile collegarsi al server.";
return;
}
Conn.Close();
DataSet DS = new Dipartimenti();
if (sys.RUN_SELECT_COUNT("CodiciDipartimenti",
"(CodiceDipartimento=" +
QueryCreator.quotedstrvalue(codice, true) + ")", true) > 0)
{
lblmessages.Text = "Codice dipartimento già esistente.";
return;
}
DataTable T = DS.Tables[0];
DataRow R = T.NewRow();
R["CodiceDipartimento"] = codice;
R["dipartimento"] = dip;
R["IPserver"] = GetVars.CryptPassword(ip);
R["NomeDB"] = GetVars.CryptPassword(db);
R["UserDB"] = GetVars.CryptPassword(user);
R["PassDB"] = GetVars.CryptPassword(pwd);
T.Rows.Add(R);
PostData CP = new PostData();
CP.InitClass(DS, sys);
ProcedureMessageCollection MCOLL = CP.DO_POST_SERVICE();
if (!MCOLL.CanIgnore)
{
lblmessages.Text = "Delle regole di sicurezza hanno impedito l'update del db di sistema!!";
return;
}
else
{
if (MCOLL.Count > 0)
{
CP.DO_POST_SERVICE();
}
}
lblmessages.Text = "DB DI SISTEMA Aggiornato correttamente.";
}
protected void Page_Load(object sender, EventArgs e)
{
da = new DataAccess("NA");
}
public Meta_colname(DataAccess Conn, MetaDataDispatcher Dispatcher) :
base(Conn, Dispatcher, "colname")
{
EditTypes.Add("default");
Name = "colname";
}
private void ReloadList()
{
DataAccess da = new DataAccess();
dgList.DataContext = da.GetUnits();
}
public Meta_creditproceedsview(DataAccess Conn, MetaDataDispatcher Dispatcher) :
base(Conn, Dispatcher, "creditproceedsview")
{
Name = "Crediti e cassa assegnati ";
ListingTypes.Add("lista");
}
