private T GetSelectedItem <T>() where T : class
{
int i = Gridview.GetSelectedRows().FirstOrDefault();
T obj = Gridview.GetRow(i) as T;
return(obj);
}
public void UpdateRow <T>(T entry)
{
var row = Gridview.GetSelectedRows().FirstOrDefault();
foreach (GridColumn col in Gridview.Columns)
{
var props = col.FieldName.Split('.');
{
var propInfo = entry.GetType().GetProperty(props[0]);
if (propInfo != null)
{
var val = propInfo.GetValue(entry, null);
if (val != null)
{
for (var i = 1; i < props.Length; i++)
{
propInfo = val.GetType().GetProperty(props[i]);
val = propInfo.GetValue(val, null);
}
Gridview.SetRowCellValue(row, col, val);
}
}
}
}
}
public ActionResult productsGrid()
{
try
{
var grid = new Gridview("gridProduct", "Ürünler Tablosu");
var data = InstanceFactory.GetInstance <IProductService>().GetWithCategories();
grid.CellPreparing += new CustomControl.CellPreparingEventHandler(grid_CellPreparing);
grid.AddColumns(new GridviewColumn("Düzenle", "Edit"),
new GridviewColumn("Sil", "Delete"),
new GridviewColumn("Id", "ProductID"),
new GridviewColumn("Ürün Adı", "ProductName"),
new GridviewColumn("Kategori", "CategoryID"),
new GridviewColumn("Kategori Adı", "Category.CategoryName"),
new GridviewColumn("Birim Adeti", "QuantityPerUnit"),
new GridviewColumn("Ürün Fiyatı", "UnitPrice"),
new GridviewColumn("Stok", "UnitsInStock")).DataBind(data);
return(Content(grid.RenderControl().ToString()));
}
catch (Exception ex)
{
return(Content(ex.Message.ToString()));
}
}
protected void DataList3_ItemCommand(object source, DataListCommandEventArgs e)
{
if (e.CommandName == "PageNumber")
{
CurrentPage = Convert.ToInt32(e.CommandArgument);
//int id = Convert.ToInt32(DropDownList1.SelectedValue);
int id = Convert.ToInt32(Session["CateID"]);
GetListPage(DAO.GetTotalRows(id));
DataList1.DataSource = DAO.getAllCategories();
DataList1.DataBind();
DataList3.DataSource = listPage;
DataList3.DataBind();
Gridview.DataSource = DAO.getProductPaging(id, CurrentPage);
Gridview.DataBind();
}
//if (e.CommandName == "Category")
//{
// Session["CateID"] = Convert.ToInt32(e.CommandArgument);
// GetListPage(DAO.GetTotalRows(Convert.ToInt32(Session["CateID"])));
// DataList1.DataSource = DAO.getAllCategories();
// DataList1.DataBind();
// DataList3.DataSource = listPage;
// DataList3.DataBind();
// Gridview.DataSource = DAO.getProductPaging(Convert.ToInt32(Session["CateID"]), CurrentPage);
// Gridview.DataBind();
//}
}
protected void btnSendMail_Click(object sender, EventArgs e)
{
if (!Page.IsValid)
{
return;
}
try
{
IncentiveBusiness b = new IncentiveBusiness();
EmailDetails details = new EmailDetails();
SendMailObject obj = new SendMailObject();
details.FromEmail = ConfigurationManager.AppSettings["FromAddress"].ToString();
string finance_emailid = Session["emailId"].ToString();
string employeeid = Session["MemberId"].ToString();
string referenceid = Session["referenceid"].ToString();
string toemail = txtTo.Text;
string ccmail = txtCC.Text;
details.ToEmail = toemail.ToString();
details.CCEmail = ccmail.ToString();
details.Type = referenceid;
details.Id = "";
details.Module = Session["transctiontype"].ToString();
string FooterText = ConfigurationManager.AppSettings["FooterText"].ToString();
details.EmailSubject = txtSubject.Text;
details.MsgBody = "<span style=\"font-size: 10pt; color: #3300cc; font-family: Verdana\"> <br>" +
"<b> '" + txtMsgContent.Text + "' <br> " +
"<br>" + "<br>" + "<br>" + "<br>" + FooterText +
" </b><br><b> </b></span>";
bool resultv = obj.InsertIntoEmailQueue(details);
if (resultv == true)
{
bool flag = b.UpdateUtilizationMailFlag(employeeid, referenceid, Session["transctiontype"].ToString());
Gridview.DataBind();
Gridview.Visible = true;
PanelSendMail.Visible = false;
txtTo.Text = "";
txtCC.Text = "";
txtSubject.Text = "";
txtMsgContent.Text = "";
string CloseWindow1 = "alert('Mail Sent successfully')";
ScriptManager.RegisterStartupScript(this, this.GetType(), "newWindow", CloseWindow1, true);
}
else
{
PanelSendMail.Visible = true;
string CloseWindow1 = "alert('Problem while sending mail')";
ScriptManager.RegisterStartupScript(this, this.GetType(), "newWindow", CloseWindow1, true);
}
}
catch (Exception ex)
{
log.Error(ex.StackTrace);
log.Error(ex.Message);
}
}
protected void DataList1_ItemCommand(object source, DataListCommandEventArgs e)
{
int catID = Convert.ToInt32(e.CommandArgument);
//Gridview.DataSource = DAO.getAllProductsByCatID(catID);
if (DAO.getProductPaging(catID, 1).Rows.Count > 0)
{
Gridview.DataSource = DAO.getProductPaging(catID, 1);
Session["CateID"] = "";
Session["CateID"] = catID;
GetListPage(DAO.GetTotalRows(catID));
DataList3.DataSource = listPage;
DataList3.DataBind();
Gridview.DataBind();
Label1.Text = "";
}
else
{
Label1.Text = "Not found Data of this Category!";
Gridview.DataSource = null;
Gridview.DataBind();
Session["CateID"] = null;
DataList3.DataSource = null;
DataList3.DataBind();
}
}
private void mavtLUE_EditValueChanged(object sender, EventArgs e)
{
DataRowView s = (DataRowView)mavtLUE.GetSelectedDataRow();
vtLB.Text = s["Ma_Vt"].ToString();
if (Gridview.LocateByValue("Ma_Vt", mavtLUE.EditValue) < 0)
{
ewErrorProvider1.SetError(mavtLUE, "", ErrorType.Information);
}
else
{
if (isAdd)
{
ewErrorProvider1.SetError(mavtLUE, "Giá trị này đã có trong Danh Mục Bảng Giá", ErrorType.Information);
}
else
{
if (mavtLUE.EditValue.ToString() == mavtLUE.Tag.ToString())
{
ewErrorProvider1.SetError(mavtLUE, "", ErrorType.Information);
}
else
{
ewErrorProvider1.SetError(mavtLUE, "Giá trị này đã có trong Danh Mục Bảng Giá", ErrorType.Information);
}
}
}
}
private void madtTE_EditValueChanged(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(madtTE.Text.ToString()))
{
ewErrorProvider1.SetError(madtTE, "Mã đối tượng không bỏ trống", ErrorType.Information);
}
else
{
if (Gridview.LocateByValue("Ma_Dt", madtTE.EditValue) < 0)
{
ewErrorProvider1.SetError(madtTE, "", ErrorType.Information);
}
else
{
if (isAdd)
{
ewErrorProvider1.SetError(madtTE, "Giá trị này đã có trong Danh Mục Đối Tượng", ErrorType.Information);
}
else
{
if (madtTE.EditValue.ToString() == madtTE.Tag.ToString())
{
ewErrorProvider1.SetError(madtTE, "", ErrorType.Information);
}
else
{
ewErrorProvider1.SetError(madtTE, "Giá trị này đã có trong Danh Mục Đối Tượng", ErrorType.Information);
}
}
}
}
}
private void makhoTE_EditValueChanged(object sender, EventArgs e)
{
if (Gridview.LocateByValue("Ma_Kho", makhoTE.Text) < 0)
{
ewErrorProvider1.SetError(makhoTE, "", ErrorType.Information);
}
else
{
if (isAdd)
{
ewErrorProvider1.SetError(makhoTE, "Giá trị này đã có trong Danh Mục Bảng Giá", ErrorType.Information);
}
else
{
if (makhoTE.EditValue.ToString() == makhoTE.Tag.ToString())
{
ewErrorProvider1.SetError(makhoTE, "", ErrorType.Information);
}
else
{
ewErrorProvider1.SetError(makhoTE, "Giá trị này đã có trong Danh Mục Bảng Giá", ErrorType.Information);
}
}
}
}
private void acceptBtn_Click(object sender, EventArgs e)
{
Gridview.GetDataRow(Gridview.FocusedRowHandle)["Ma_Vt"] = this.mavtLUE.Text;
Gridview.GetDataRow(Gridview.FocusedRowHandle)["Gia"] = this.giaTE.Text;
if (isAdd)
{
Gridview.UpdateCurrentRow();
}
this.Close();
}
public void AddNewRow <T>(T obj) where T : class
{
Gridview.AddNewRow();
var rowHandle = Gridview.GetRowHandle(Gridview.DataRowCount);
if (Gridview.IsNewItemRow(rowHandle))
{
UpdateRow(rowHandle, obj);
}
}
private void acceptBtn_Click(object sender, EventArgs e)
{
Gridview.GetDataRow(Gridview.FocusedRowHandle)["Ten_kho"] = tenkhoTE.Text;
Gridview.GetDataRow(Gridview.FocusedRowHandle)["Ma_Kho"] = makhoTE.Text;
Gridview.GetDataRow(Gridview.FocusedRowHandle)["Stt"] = sttTE.Text;
if (isAdd)
{
Gridview.UpdateCurrentRow();
}
Close();
}
//────────────────────────────────────────
/// <summary>
/// コンストラクター。
/// </summary>
public UsercontrolXenonGridPanel()
{
InitializeComponent();
// 画面のちらつきをなくすために、ダブル・バッファーを真にします。
this.DoubleBuffered = true;
// 初期設定
this.bPrepainted_Grid = true;
this.gridView = new GridviewImpl();
}
private void acceptBtn_Click(object sender, EventArgs e)
{
//Gridview.GetDataRow(Gridview.FocusedRowHandle)["Ma_Nvu"] = this.manvuTE.Text;
//Gridview.GetDataRow(Gridview.FocusedRowHandle)["Ten_Nvu"] = this.tennvuTE.Text;
//Gridview.GetDataRow(Gridview.FocusedRowHandle)["Ma_Ct"] = this.mactTE.Text;
//Gridview.GetDataRow(Gridview.FocusedRowHandle)["Ma_Ct_Rule"] = this.mactruleTE.Text;
//Gridview.GetDataRow(Gridview.FocusedRowHandle)["Tk_No"] = this.tknoTE.Text;
//Gridview.GetDataRow(Gridview.FocusedRowHandle)["Tk_No_Rule"] = this.tknoruleTE.Text;
//Gridview.GetDataRow(Gridview.FocusedRowHandle)["Tk_Co"] = this.tkcoTE.Text;
//Gridview.GetDataRow(Gridview.FocusedRowHandle)["Tk_Co_Rule"] = this.tkcoruleTE.Text;
if (isAdd)
{
Gridview.UpdateCurrentRow();
}
this.Close();
}
private void acceptBtn_Click(object sender, EventArgs e)
{
Gridview.GetDataRow(Gridview.FocusedRowHandle)["Ma_Dt"] = this.madtTE.Text;
Gridview.GetDataRow(Gridview.FocusedRowHandle)["Ten_Dt"] = this.tenTE.Text;
Gridview.GetDataRow(Gridview.FocusedRowHandle)["Ma_Nh_Dt"] = this.manhdtLUE.EditValue;
Gridview.GetDataRow(Gridview.FocusedRowHandle)["Cong_Ty"] = this.ctyTB.Text;
Gridview.GetDataRow(Gridview.FocusedRowHandle)["Dia_Chi"] = this.diachiTB.Text;
Gridview.GetDataRow(Gridview.FocusedRowHandle)["Ma_So_Thue"] = this.msthueTE.Text;
Gridview.GetDataRow(Gridview.FocusedRowHandle)["So_Tk_NH"] = this.tknhTE.Text;
Gridview.GetDataRow(Gridview.FocusedRowHandle)["Ten_NH"] = this.tennhTB.Text;
Gridview.GetDataRow(Gridview.FocusedRowHandle)["So_Phone"] = this.sdtTE.Text;
if (isAdd)
{
Gridview.UpdateCurrentRow();
}
this.Close();
}
private void acceptBtn_Click(object sender, EventArgs e)
{
this.Gridview.GetDataRow(Gridview.FocusedRowHandle)["Ma_Vt"] = this.txtMaVT.Text;
this.Gridview.GetDataRow(Gridview.FocusedRowHandle)["Ten_Vt"] = this.txtTenVT.Text;
this.Gridview.GetDataRow(Gridview.FocusedRowHandle)["Ma_Nh_Vt"] = this.manhdtLB.Text;
this.Gridview.GetDataRow(Gridview.FocusedRowHandle)["Ma_Kho"] = this.txtDmaKho.Text;
this.Gridview.GetDataRow(Gridview.FocusedRowHandle)["Dvt"] = this.txtDonVi.Text;
this.Gridview.GetDataRow(Gridview.FocusedRowHandle)["Tk"] = this.txtTkVT.Text;
//this.Gridview.GetDataRow(Gridview.FocusedRowHandle)["Ngay_Begin"] = this.txtBdate.Text;
//this.Gridview.GetDataRow(Gridview.FocusedRowHandle)["Ngay_End"] = this.txtEdate.Text;
this.Gridview.GetDataRow(Gridview.FocusedRowHandle)["Create_Log"] = this.txtCreateLog.Text;
this.Gridview.GetDataRow(Gridview.FocusedRowHandle)["LastModify_Log"] = this.txtLstModify.Text;
this.Gridview.GetDataRow(Gridview.FocusedRowHandle)["Ghi_Chu"] = this.txtGhichu.Text;
if (isAdd)
{
Gridview.UpdateCurrentRow();
}
this.Close();
}
private void DatagridviewMain_ProcessGridKey(object sender, KeyEventArgs e)
{
if (e.KeyData == Keys.Delete)
{
DialogResult result = FormUtility.MsgDelete();
if (result == DialogResult.Yes)
{
int i = Gridview.GetSelectedRows().FirstOrDefault();
object obj = Gridview.GetRow(i) as object;
if (obj == null)
{
return;
}
DeleteRow <object>(obj);
Gridview.DeleteRow(i);
}
}
e.Handled = true;
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
GetListPage(DAO.GetTotalRows(1));
if (Session["Cart"] == null)
{
Session["Cart"] = new Dictionary <int, int>();
}
if (Session["CateID"] == null)
{
Session["CateID"] = 1;
}
Cart = (Dictionary <int, int>)Session["Cart"];
DataList1.DataSource = DAO.getAllCategories();
DataList1.DataBind();
//Gridview.DataSource = DAO.getAllProductsByCatID(1);
Gridview.DataSource = DAO.getProductPaging(1, 1);
Gridview.DataBind();
DataList3.DataSource = listPage;
DataList3.DataBind();
LoadCart();
}
}
public void UpdateRow <T>(int row, T obj) where T : class
{
foreach (GridColumn col in Gridview.Columns)
{
var props = col.FieldName.Split('.');
var propInfo = obj.GetType().GetProperty(props[0]);
if (propInfo == null)
{
continue;
}
var val = propInfo.GetValue(obj, null);
if (val == null)
{
continue;
}
for (var i = 1; i < props.Length; i++)
{
propInfo = val.GetType().GetProperty(props[i]);
val = propInfo.GetValue(val, null);
}
Gridview.SetRowCellValue(row, col, val);
}
Gridview.RefreshRow(row);
}
protected void PerformSearch(object sender, EventArgs e)
{
List <QueryFilter> filters = new List <QueryFilter>();
if (!String.IsNullOrEmpty(inputLogLevel.Value))
{
QueryFilter qf = new QueryFilter();
qf.Key = "@logLevel";
qf.Value = inputLogLevel.Value;
filters.Add(qf);
}
if (!String.IsNullOrEmpty(inputUser.Value))
{
QueryFilter qf = new QueryFilter();
qf.Key = "@userName";
qf.Value = inputUser.Value;
filters.Add(qf);
}
if (!String.IsNullOrEmpty(inputAction.Value))
{
QueryFilter qf = new QueryFilter();
qf.Key = "@action";
qf.Value = inputAction.Value;
filters.Add(qf);
}
if (!String.IsNullOrEmpty(inputEntity.Value))
{
QueryFilter qf = new QueryFilter();
qf.Key = "@entity";
qf.Value = inputEntity.Value;
filters.Add(qf);
}
if (!String.IsNullOrEmpty(inputDescription.Value))
{
QueryFilter qf = new QueryFilter();
qf.Key = "@description";
qf.Value = inputDescription.Value;
filters.Add(qf);
}
string since = dateSince.Date;
string until = dateUntil.Date;
if (!String.IsNullOrEmpty(since) && !String.IsNullOrEmpty(until))
{
if (Convert.ToDateTime(since) > Convert.ToDateTime(until))
{
dateUntil.Date = since;
dateSince.Date = until;
}
}
if (!String.IsNullOrEmpty(dateSince.Date))
{
QueryFilter qf = new QueryFilter();
qf.Key = "@since";
qf.Value = dateSince.Date;
filters.Add(qf);
}
if (!String.IsNullOrEmpty(dateUntil.Date))
{
QueryFilter qf = new QueryFilter();
qf.Key = "@until";
qf.Value = dateUntil.Date;
filters.Add(qf);
}
LogManager logManager = new LogManager();
List <LogEntry> logs = logManager.Get(filters);
Gridview.ColumnsToShow = ColumnsToShowAndTranslate();
Gridview.LoadGrid(logs);
}
protected void Btnsearch_Click(object sender, EventArgs e)
{
PublishData v = new PublishData();
string Pid = txtPublicationId.Text.Trim();
Business obj = new Business();
IncentiveBusiness ince_obj = new IncentiveBusiness();
string TypeEntry = "JA";
v = obj.fnfindjid(Pid, TypeEntry);
TextBoxPubId.Text = Pid;
txtboxTitleOfWrkItem.Text = v.TitleWorkItem;
TextBoxPubJournal.Text = v.PublisherOfJournal;
TextBoxNameJournal.Text = v.PublisherOfJournalName;
DropDownListMuCategory.SelectedValue = v.MUCategorization;
DropDownListMonthJA.SelectedValue = v.PublishJAMonth.ToString();
string PublicationYearwebConfig = ConfigurationManager.AppSettings["PublicationYear"];
int currenntYear = DateTime.Now.Year;
int year = Convert.ToInt32(PublicationYearwebConfig);
int yeardiff = currenntYear - year;
if (yeardiff < 0)
{
yeardiff = -(yeardiff);
}
for (int i = 0; i <= yeardiff; i++)
{
int yeatAppend = year + i;
TextBoxYearJA.Items.Add(new ListItem(yeatAppend.ToString(), yeatAppend.ToString(), true));
}
TextBoxYearJA.DataBind();
TextBoxYearJA.SelectedValue = v.PublishJAYear;
int pubyear = Convert.ToInt32(TextBoxYearJA.SelectedValue);
int pubmonth = 0;
pubmonth = Convert.ToInt32(DropDownListMonthJA.SelectedValue);
if (pubyear >= 2018 && pubmonth >= 7)
{
string quartileid = v.QuartileOnIncentivize;
lblQuartile.Visible = true;
txtquartile.Visible = true;
txtquartileid.Text = quartileid.ToString();
//Session["Quartile"] = txtquartileid.Text;
//txtquartileid.Text = Session["Quartile"].ToString();
PublishData v2 = new PublishData();
if (txtquartileid.Text != "" && txtquartileid.Text != "0")
{
v2 = ince_obj.getquartileName(txtquartileid.Text);
txtquartile.Text = v2.Name;
if (Convert.ToInt16(v.PublishJAYear) >= 2018 && Convert.ToInt16(v.PublishJAMonth) >= 7)
{
v.ImpactFactor = txtquartileid.Text;
}
}
}
else
{
lblQuartile.Visible = false;
txtquartile.Visible = false;
}
if (v.IncentivePointSatatus == "CAN" && v.Status == "CAN")
{
PanelCancel.Visible = true;
txtcancelRemarks.Text = v.PubCancelRemarks;
Gridview.Visible = true;
Gridview.DataSourceID = "SqlDataSource3";
Gridview.DataBind();
if (Gridview.Rows.Count == 0)
{
}
}
else
{
PanelCancel.Visible = false;
Gridview.Visible = true;
Gridview.DataSourceID = "SqlDataSource2";
Gridview.DataBind();
if (Gridview.Rows.Count == 0)
{
}
}
TextBoxImpFact.Text = v.ImpactFactor;
TextBoxImpFact5.Text = v.ImpactFactor5;
if (v.IFApplicableYear != 0)
{
txtIFApplicableYear.Text = v.IFApplicableYear.ToString();
}
TextBoxPageFrom.Text = v.PageFrom;
TextBoxPageTo.Text = v.PageTo;
TextBoxVolume.Text = v.Volume;
TextBoxIssue.Text = v.Issue;
DropDownListPubType.SelectedValue = v.Publicationtype;
//Gridview.Visible = true;
//Gridview.DataSourceID = "SqlDataSource2";
//Gridview.DataBind();
//if (Gridview.Rows.Count==0)
//{
//}
}
protected void BtnSearch_Click(object sender, EventArgs e)
{
Gridview.DataBind();
Gridview.Visible = true;
}
protected void Load_content()
{
Gridview.DataSource = _businesscode.GetCRAs(sortingPar);
Gridview.DataBind();
}
