protected void RadGrid1_InsertCommand(object sender, GridCommandEventArgs e)
{
GridEditableItem item = e.Item as GridEditableItem;
Hashtable values = new Hashtable();
item.ExtractValues(values);
roles.Insert(values);
}
protected void grid_OnDeleteCommand(object sender, GridCommandEventArgs e)
{
try
{
var item = (e.Item as GridEditableItem);
// ReSharper disable PossibleNullReferenceException
var roleId = Guid.Parse(item.GetDataKeyValue("RoleId").ToString());
// ReSharper restore PossibleNullReferenceException
var userId = Guid.Parse(item.GetDataKeyValue("UserId").ToString());
var ur = new UserRole
{
UserId = userId,
RoleId = roleId,
State = State.删除
};
HomoryContext.Value.UserRole.AddOrUpdate(ur);
HomoryContext.Value.SaveChanges();
LogOp(OperationType.删除);
grid.Rebind();
Notify(panel, "操作成功", "success");
}
// ReSharper disable EmptyGeneralCatchClause
catch
// ReSharper restore EmptyGeneralCatchClause
{
}
}
protected void MenuGrid_ItemCommand(Object sender, GridCommandEventArgs e)
{
try
{
GridEditableItem item = (GridEditableItem)e.Item;
Int32 id = (Int32)item.GetDataKeyValue("ID");
if (e.CommandName == "Delete")
{
try
{
if (MenuManager.Current.Delete(id))
MenuManager.Current.Save();
else
ShowMessage("Item cannot be removed: menu contains a child items.");
}
finally
{
MenuManager.Current.Reset();
}
}
}
catch (Exception ex)
{
ShowMessage("Activity cannot be deleted. Reason: " + ex.Message);
e.Canceled = true;
}
finally
{
MenuGrid.Rebind();
}
}
protected void rgAdminListDepartment_InsertCommand(object source, GridCommandEventArgs e)
{
GridEditableItem dataItem = (GridEditableItem)e.Item;
int departmentId = 0;
TextBox txtDepartmentName = (TextBox)dataItem["DepartmentName"].Controls[0];
TextBox txtDescription = (TextBox)dataItem["Description"].Controls[0];
if (txtDepartmentName.Text == string.Empty || txtDescription.Text == string.Empty)
{
ShowAlertMessage("Please enter the department and description to add!");
}
else
{
int IsSaved = new AdministrationBAL().InsertDepartment(departmentId, txtDepartmentName.Text, txtDescription.Text);
if (IsSaved < 0)
ShowAlertMessage("Entered Department is already exists!");
else
{
ShowAlertMessage("New Department Saved successfully!");
}
}
BindDepartment(false);
}
void pGrid_ItemCommand(object sender, GridCommandEventArgs e)
{
Int64 Key = 0;
// Get the ID for the row to select or delete
if (e.CommandName.ToUpper() == "SELECT" || e.CommandName.ToUpper() == "DELETE")
{
//Key = Methods.Convert_Int64(this.UserGrid.pGrid.MasterTableView.Items[e.Item.ItemIndex].GetDataKeyValue("RecruitmentTestUserID").ToString());
Key = this.UserGrid.GetKey(e.Item.ItemIndex);
}
switch (e.CommandName)
{
case "Select":
this.Response.Redirect(@"~/Page/User_Details.aspx?ID=" + Key);
break;
case "Delete":
ClsKeys ClsKey = new ClsKeys();
ClsKey.Add("RecruitmentTestUserID", Convert.ToInt64(Key));
this.ClsUser.Load(ClsKey);
this.ClsUser.Delete();
this.UserGrid.RebindGrid();
break;
}
}
protected void RadGrid1_OnItemCommand(object sender, GridCommandEventArgs e)
{
try
{
GridDataItem item = (GridDataItem)e.Item;
string id = item["colId"].Text;
switch (e.CommandName)
{
case "btnSelect":
Response.Redirect("ChartOfAccounting.aspx?id=" + id, true);
break;
case "btnDelete":
//int delete = new Bank().DeleteBankByBankId(int.Parse(id));
int delete = new ChartOfAccount().DeleteChartOfAccountByCoaId(int.Parse(id));
if (delete == 0)
{
Alert.Show("Data was not delete..");
}
else
LoadChartOfAccountTable();
break;
}
}
catch (Exception ex)
{
Alert.Show(ex.Message);
}
}
protected void RadGrid1_ItemCommand(object source, GridCommandEventArgs e)
{
if (e.CommandName == "btntradedetails")
{
GridDataItem item = (GridDataItem)e.Item;
int paymentkey = Convert.ToInt32(item["payments_key"].Text);
LoadTradeDetails(paymentkey);
pnltradedetails.Visible = true;
}
if (e.CommandName == "btnWithdraw")
{
GridDataItem item = (GridDataItem)e.Item;
int paymentkey = Convert.ToInt32(item["payments_key"].Text);
Payment paymenttemp = sitetemp.getPayment(paymentkey);
Int64 payment_payment_object_key = sitetemp.getpaymentobject(6, paymentkey);
Users user_requestor = sitetemp.get_user_info(paymenttemp.Requestor_user_key);
sitetemp.InternalTransaction(paymenttemp.Buy_currency, paymenttemp.Buy_amount, payment_payment_object_key, paymenttemp.Payment_object_receiver, currentuser.User_key, "From Payment object to Withdrawl Bank Account", 1, paymentkey);
Peerfx_DB.SPs.UpdatePaymentStatus(paymentkey, 5).Execute(); //payment delivered
//payment completed, send email
Peerfx.External_APIs.SendGrid sg = new Peerfx.External_APIs.SendGrid();
sg.Send_Email_Payment_Completed(paymenttemp.Payments_Key, user_requestor);
RadGrid1.Rebind();
}
}
protected void rgAdminListSymptom_InsertCommand(object source, GridCommandEventArgs e)
{
GridEditableItem dataItem = (GridEditableItem)e.Item;
int symptomId = 0;
TextBox txtSymptom = (TextBox)dataItem["Symptom"].Controls[0];
TextBox txtDescription = (TextBox)dataItem["Description"].Controls[0];
if (txtSymptom.Text == string.Empty || txtDescription.Text == string.Empty)
{
ShowAlertMessage("Please enter the symptom and description to add!");
}
else
{
int IsSaved = new AdministrationBAL().InsertSymptom(symptomId, txtSymptom.Text, txtDescription.Text);
if (IsSaved < 0)
ShowAlertMessage("Entered Symptom is already exists!");
else
{
ShowAlertMessage("New Symptom Saved successfully!");
}
}
BindSymptom(false);
}
protected void RadGrid1_ItemCommand(object sender, GridCommandEventArgs e)
{
foreach (GridItem Item in RadGrid1.Items)
{
}
}
protected void RadGrid1_InsertCommand(object source, GridCommandEventArgs e)
{
var editableItem = ((GridEditableItem)e.Item);
Hashtable values = new Hashtable();
editableItem.ExtractValues(values);
try
{
var roleName = values["RoleName"] as string;
if (roleName == null || string.IsNullOrEmpty(roleName.Trim()))
{
ShowErrorMessage(Pharma.Administrator_Default_RadGrid1_InsertCommand_Please_provide_role_name_to_add);
e.Canceled = true;
}
else
{
var result = repo.Add(roleName.Trim());
if(!result)
{
ShowErrorMessage("Role name must be unique, please try again with the another name");
e.Canceled = true;
}
}
}
catch (System.Exception)
{
ShowErrorMessage(Pharma.Administrator_Default_RadGrid1_InsertCommand_can_not_add__please_try_again_later_or_contact_admnistrator_);
e.Canceled = true;
}
}
protected void rgSchools_UpdateCommand(Object source, GridCommandEventArgs e)
{
var editedItem = e.Item as GridEditableItem;
if (editedItem == null) return;
//Get the new values:
var newValues = new Hashtable();
e.Item.OwnerTableView.ExtractValuesFromItem(newValues, editedItem);
int id = DataIntegrity.ConvertToInt(editedItem.GetDataKeyValue("ID").ToString());
string name = newValues["Name"] == null ? string.Empty : newValues["Name"].ToString();
int? page = DataIntegrity.ConvertToNullableInt(newValues["Page"]);
int district = DataIntegrity.ConvertToInt(newValues["District"]);
string abbreviation = newValues["Abbreviation"] == null ? string.Empty : newValues["Abbreviation"].ToString();
string phone = newValues["Phone"] == null ? string.Empty : newValues["Phone"].ToString();
string cluster = newValues["Cluster"] == null ? string.Empty : newValues["Cluster"].ToString();
string schoolType = newValues["SchoolType"] == null ? string.Empty : newValues["SchoolType"].ToString();
string schoolId = newValues["SchoolID"] == null ? string.Empty : newValues["SchoolID"].ToString();
string portalFlag = newValues["PortalFlag"] == null ? string.Empty : newValues["PortalFlag"].ToString();
if (id < 1) return;
ThinkgateSchool school = new ThinkgateSchool(id, name, page, district, abbreviation, phone, cluster, schoolType, schoolId, portalFlag);
school.UpdateSchool();
LoadSchools();
}
protected void RadGrid1_InsertCommand(object source, GridCommandEventArgs e)
{
var editableItem = ((GridEditableItem)e.Item);
Hashtable values = new Hashtable();
editableItem.ExtractValues(values);
try
{
var posName = values["PositionName"] as string;
if (posName == null || string.IsNullOrEmpty(posName.Trim()))
{
ShowErrorMessage(Pharma.Please_provide_name_to_add);
e.Canceled = true;
}
else
{
var result = repo.Add(posName.Trim());
if (!result)
{
ShowErrorMessage("Position Name is unique, please choose another name.");
e.Canceled = true;
}
}
}
catch (System.Exception ex)
{
ShowErrorMessage(ex.Message);
e.Canceled = true;
}
}
protected void RadGrid1_UpdateCommand(object source, GridCommandEventArgs e)
{
GridEditFormItem gdItem = (e.Item as GridEditFormItem);
var editableItem = ((GridEditableItem)e.Item);
Hashtable values = new Hashtable();
editableItem.ExtractValues(values);
var id = (int)editableItem.GetDataKeyValue("Id");
try
{
var posName = values["PositionName"] as string;
if (posName == null || string.IsNullOrEmpty(posName.Trim()))
{
ShowErrorMessage(Pharma.Please_provide_role_name_to_update);
e.Canceled = true;
}
else
{
var result = repo.Edit(id, posName.Trim());
if (!result)
{
ShowErrorMessage("Position Name is unique, please choose another name.");
e.Canceled = true;
}
}
}
catch (Exception ex)
{
ShowErrorMessage(ex.Message);
e.Canceled = true;
}
}
protected void ucTourists_onTouristUpdated(object sender, GridCommandEventArgs e)
{
this.lblUpdated.Text = "Updated: " + ((GridEditableItem)e.Item).GetDataKeyValue("PolTuristiSaraksts").ToString();
var intTouristId = (int)((GridEditableItem)e.Item).GetDataKeyValue("PolTuristiSaraksts");
var itemTourist = ucTourists.TouristsList.Where(n => n.PolTuristiSaraksts == intTouristId).FirstOrDefault();
itemTourist.Fransize = itemTourist.PolTuristiSaraksts * 5;
}
protected void _grdUserUnit_ItemCommand(object source, GridCommandEventArgs e)
{
if (e.Item.ItemType == GridItemType.AlternatingItem || e.Item.ItemType == GridItemType.Item)
{
GridEditableItem editedItem = e.Item as GridEditableItem;
string _ID = editedItem.OwnerTableView.DataKeyValues[editedItem.ItemIndex]["ID"].ToString();
GridDataItem item = e.Item as GridDataItem;
if (item != null)
{
LinkButton button = item["Disable"].Controls[0] as LinkButton;
if (button.Text == "Enable")
{
if (_rdoUnit.Checked)
EnableUnit(_ID);
}
else if (button.Text == "Disable")
{
if (_rdoUnit.Checked)
DisableUnit(_ID);
//else if (_rdoUser.Checked)
//DisableUser(_ID);
}
}
}
}
/// <summary>
/// rGridAddress_DeleteCommand - Is executed if the 'Delete' command is called
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void rGridAddress_DeleteCommand(object sender, GridCommandEventArgs e)
{
GridEditableItem eeditedItem = e.Item as GridEditableItem;
sp_Sample_Address_Select_DM cSampleAddress = new sp_Sample_Address_Select_DM();
cSampleAddress.AddrID = Convert.ToInt32(eeditedItem.OwnerTableView.DataKeyValues[eeditedItem.ItemIndex]["AddrID"]);
BLL.DeleteSampleAddressContext(cSampleAddress);
}
protected void grdIndexFields_InsertCommand(object sender, GridCommandEventArgs e)
{
var editableItem = ((GridEditableItem)e.Item);
//populate its properties
Hashtable values = new Hashtable();
editableItem.ExtractValues(values);
RadComboBox combo = editableItem.FindControl("ddlFormFields") as RadComboBox;
string ffID = combo.SelectedValue;
GRASPEntities db = new GRASPEntities();
//create new entity
IndexField idx = new IndexField();
idx.FormFieldID = Convert.ToDecimal(ffID);
idx.IndexID = Convert.ToInt32(grdIndex.SelectedValue.ToString());
db.IndexFields.Add(idx);
try
{
//submit chanages to Db
db.SaveChanges();
}
catch(System.Exception ex)
{
SetMessage(ex.Message);
}
}
protected void RadGrid1_OnItemCommand(object sender, GridCommandEventArgs e)
{
try
{
GridDataItem item = (GridDataItem)e.Item;
string id = item["colId"].Text;
switch (e.CommandName)
{
case "btnSelect":
Response.Redirect("CompanyInfo.aspx?id=" + id, true);
break;
case "btnDelete":
int delete = new Company().DeleteCompanyByCompanyId(int.Parse(id));
long addressid = GetAddressID(int.Parse(id));
int deleteAddress = new Addresses().DeleteAddressesByAddressId(addressid);
if (delete == 0)
Alert.Show("Data was not deleted");
else
{
this.LoadCompanyListTable();
}
break;
}
}
catch (Exception ex)
{
Alert.Show(ex.Message);
}
}
protected void grdConference_ItemCommand(object sender, GridCommandEventArgs e)
{
if (e.Item != null)
{
string[] commandsToCloseOtherItemsFor = { RadGrid.InitInsertCommandName, RadGrid.EditCommandName };
if (commandsToCloseOtherItemsFor.Contains(e.CommandName))
{
e.Item.OwnerTableView.IsItemInserted = false;
e.Item.OwnerTableView.ClearChildEditItems();
}
if (e.CommandName.Equals(RadGrid.ExpandCollapseCommandName))
{
e.Item.OwnerTableView.IsItemInserted = false;
e.Item.OwnerTableView.ClearChildEditItems();
if (e.Item is GridDataItem)
{
foreach (GridDataItem item in e.Item.OwnerTableView.Items.OfType<GridDataItem>().Where(it => it != e.Item))
{
item.Expanded = false;
}
}
}
if (e.CommandName.Equals(RadGrid.RebindGridCommandName))
{
GridTableView table = e.Item.OwnerTableView;
table.SortExpressions.Clear();
table.Rebind();
e.Canceled = true;
}
}
}
/// <summary>
/// 删除事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void GridUser_DeleteCommand(object sender, GridCommandEventArgs e)
{
//获取Grid的主键值
string GridKey = e.Item.OwnerTableView.DataKeyValues[e.Item.ItemIndex]["UserID"].ToString();
UserBLL UserBLLs = new UserBLL();
string strGetuserID = HttpContext.Current.User.Identity.Name;
if (strGetuserID == GridKey)
{
//当前用户不能删除！ 警告
string strInfo = GetGlobalResourceObject("en_US", "UserManagerForm_lblDesc_DeleteInfo").ToString();
RadWindowManager1.RadAlert(strInfo, 300, 100, "Warn", "");
return;
}
if (GridKey != string.Empty)
{
tblUser UserObjs;
UserObjs = UserBLLs.GetByID(GridKey);
if (UserObjs.UserName == "admin")
{
//管理员不能删除！ 警告Admin Can't delete!
string strInfo = GetGlobalResourceObject("en_US", "UserManagerForm_lblDesc_DeleteInfoAdmin").ToString();
RadWindowManager1.RadAlert(strInfo, 300, 100, "Warn", "");
return;
}
UserBLLs.Delete(GridKey);
RoleUserBLL Role_UserBLLs = new RoleUserBLL();
//删除关系表
Role_UserBLLs.Delete(GridKey);
}
this.GridViewData();
}
protected void RadGrid1_OnItemCommand(object sender, GridCommandEventArgs e)
{
try
{
GridDataItem item = (GridDataItem)e.Item;
string id = item["colId"].Text;
switch (e.CommandName)
{
case "btnSelect":
{
Response.Redirect("DesignationInformation.aspx?id="+id,true);
break;
}
case "btnDelete":
int del = new Designation().DeleteDesignationByDesignationId(int.Parse(id));
if (del == 0)
Alert.Show("Data is not deleted");
else
{
this.LoadDesignationTable();
}
break;
}
}
catch (Exception ex)
{
Alert.Show(ex.Message);
}
}
protected void BlogGrid_ItemCommand(Object sender, GridCommandEventArgs e)
{
try
{
if (e.CommandName == "Delete")
{
GridEditableItem item = (GridEditableItem)e.Item;
Object id = item.GetDataKeyValue("ID");
try
{
BlogManager.Current.Delete(Convert.ToInt32(id));
BlogManager.Current.Save();
}
finally
{
BlogManager.Current.Reset();
}
}
}
catch (Exception ex)
{
SetMessage("Article cannot be deleted. Reason: " + ex.Message);
e.Canceled = true;
}
finally
{
BlogGrid.Rebind();
}
}
protected void rGridAddress_DeleteCommand(object sender, GridCommandEventArgs e)
{
GridEditableItem eeditedItem = e.Item as GridEditableItem;
int iAddrID = 0;
iAddrID = Convert.ToInt32(eeditedItem.OwnerTableView.DataKeyValues[eeditedItem.ItemIndex]["AddrID"]);
BLL.DeleteSampleAddress(iAddrID);
}
protected void RadGrid1_InsertCommand(object sender, GridCommandEventArgs e)
{
var item = e.Item as GridEditableItem;
var values = new Hashtable();
item.ExtractValues(values);
BLL.Users.Insert(values);
}
protected void rgValPermitido_InsertCommand(object sender, GridCommandEventArgs e)
{
UserControl uc = (UserControl)e.Item.FindControl(GridEditFormItem.EditFormUserControlID);
int tipoValor = int.Parse(((RadDropDownList)uc.FindControl("ddlTipoValor")).SelectedValue.ToString());
string valor = ((RadTextBox)uc.FindControl("txtValor")).Text;
string descripcion = ((RadTextBox)uc.FindControl("txtDescripcion")).Text;
if (validarControl(tipoValor, valor, descripcion))
{
Consulta c = new Consulta();
try
{
DatosEstructuraArchivo d = new DatosEstructuraArchivo(0, valor, descripcion);
d.tipoValor = c.consultarTipoValorOBJ(tipoValor);
d.estructuraArchivo = c.consultarEstructuraArchivo(this.ddlTipoArchivo.SelectedValue, int.Parse(this.ddlNumColumna.SelectedValue.ToString()));
guardarDatos(d);
}
catch(Exception ex){
Logger.generarLogError(ex.Message, new System.Diagnostics.StackFrame(true), ex);
this.RadWindowManager1.RadAlert(Utilities.errorMessage(), 400, 200, Utilities.windowTitle(TypeMessage.error_message),
null, Utilities.pathImageMessage(TypeMessage.error_message));
e.Canceled = true;
}
}
else
{
e.Canceled = true;
}
}
protected void InsertUpdateRecord(bool Update, object sender, GridCommandEventArgs e)
{
GridEditableItem items = e.Item as GridEditableItem;
GridEditFormItem editform = (GridEditFormItem)e.Item;
Hashtable values = new Hashtable();
items.ExtractValues(values);
Telerik.Web.UI.RadEditor RadEditor1 = (Telerik.Web.UI.RadEditor)editform.FindControl("RadEditor1");
RadComboBox ddContentType = (RadComboBox)editform.FindControl("ddContentType");
CheckBox chkPublished = (CheckBox)editform.FindControl("chkPublished");
CheckBox chkIsMenu = (CheckBox)editform.FindControl("chkIsMenu");
values["ContentTypeID"] = ddContentType.SelectedValue;
values["ContentText"] = RadEditor1.Content;
values["Published"] = chkPublished.Checked;
values["IsMenu"] = chkIsMenu.Checked;
if (Update == false)
{
EntityKey = int.Parse(items.GetDataKeyValue(RadGridKey).ToString());
BLL.Content.Update(EntityKey, values);
}
else
{
BLL.Content.Create(values);
}
}
protected void grdReviewList_ItemCommand(object sender, GridCommandEventArgs e)
{
DataTable a = GetDataInfo();
switch (e.CommandName)
{
case "DeleteRow":
a.Rows.RemoveAt((e.Item).ItemIndex);
rebindData();
break;
case "EditRow":
var row = a.Rows[(e.Item).ItemIndex];
if (CreditAccountForUpdate.Text != "" && CreditAccountForUpdate.Text == row["WorkingAccId"].ToString())
{
return;
}
var accopen = new SavingAccountDAO().GetAccountOpenByTypeAndCustomerID("P", row["WorkingAccId"].ToString());
if (accopen!=null){
rcbCreditAccount.Items.Add(new RadComboBoxItem(accopen.Title,accopen.AccountCode) );
}
rcbPaymentMethod.SelectedValue = row["PaymentMethod"].ToString();
tbCreditAmount.Value = Convert.ToDouble(row["CreditAmount"].ToString());
rcbCreditAccount.SelectedValue = row["WorkingAccId"].ToString();
CreditAccountForUpdate.Text = row["WorkingAccId"].ToString();
break;
default:
grdReviewList.DataSource = a;
grdReviewList.Rebind();
break;
}
}
protected void gDoc_ItemCommand(object source, GridCommandEventArgs e)
{
//FileUpload fu = e.Item.FindControl("fuPath") as FileUpload;
//HiddenField hf = e.Item.FindControl("hfPath") as HiddenField;
//if (fu != null && fu.HasFile)
// if (fu.PostedFile != null)
// if (fu.PostedFile.ContentLength != 0)
// {
// try
// {
// String destDir = Server.MapPath("Docs");
// String fileName = Path.GetFileName(fu.PostedFile.FileName).Replace(' ', '_');
// String destPath = Path.Combine(destDir, fileName);
// hf.Value = fileName;
// fu.PostedFile.SaveAs(destPath);
// }
// catch (Exception err)
// {
// }
// }
}
protected void RGrid_SubSysCode_ItemCommand(object sender, GridCommandEventArgs e)
{
if (e.CommandName == "Del")
{
string subSysCodeId = Convert.ToString(e.CommandArgument);
bool isDelete = false;
Model.Log logModel = new Model.Log();
logModel.OperationItem = "删除子类";
logModel.Operator = user.UserInfo.UserID;
logModel.OperationTime = DateTime.Now;
try
{
Model.SysCodeDetail scdModel = new Model.SysCodeDetail();
logModel.OperationDetail = "子类编号：" + scdModel.SYSCodeDetialID + " - 子类内容：" + scdModel.SYSCodeDetialContext;
isDelete = scd.Delete(subSysCodeId);
if (isDelete)
{
logModel.Memo = "成功";
}
else
{
logModel.Memo = "失败！";
}
}
catch (Exception ex)
{
logModel.Memo = "异常：" + ex.Message;
}
finally
{
log.Add(logModel);
if (isDelete)
{
int delNo = -1;
List<Model.SysCodeDetail> sysCodeDetailList = (List<Model.SysCodeDetail>)ViewState["SubSysCodeList"];
for(int i =0;i<sysCodeDetailList.Count;i++)
{
string tstr = sysCodeDetailList[i].SYSCodeDetialID;
if (tstr.Equals(subSysCodeId))
{
delNo = i;
break;
}
}
if (delNo != -1)
{
sysCodeDetailList.RemoveAt(delNo);
}
RGrid_SubSysCode.DataSource = sysCodeDetailList;
RGrid_SubSysCode.DataBind();
RadScriptManager.RegisterStartupScript(Page, GetType(), "c1", "OpenAlert('恭喜！删除成功！');", true);
}
else
{
RadScriptManager.RegisterStartupScript(Page, GetType(), "c2", "OpenAlert('抱歉！删除失败！<br />请检查该小类是否存在未移除的关联！');", true);
}
}
}
}
protected void RadGrid1_UpdateCommand(object sender, GridCommandEventArgs e)
{
var item = e.Item as GridEditableItem;
EntityKey = int.Parse(item.GetDataKeyValue(RadGridKey).ToString());
var values = new Hashtable();
item.ExtractValues(values);
BLL.Users.Update(EntityKey, values);
}
protected void radgridDevice_EditCommand(object sender, GridCommandEventArgs e)
{
}
protected void rgPersonal_UpdateCommand(object sender, GridCommandEventArgs e)
{
GrabarActualizar(sender, e, "Edit");
}
protected void GrdApprovedJobs_ItemCommand(object sender, GridCommandEventArgs e)
{
if (e.CommandName == "Select")
{
GridDataItem dataitem = e.Item as GridDataItem;
string ReqID = dataitem["REQUEST_ID"].Text;
OracleConnection conn = new OracleConnection(myConn);
conn.Open();
try
{
OracleCommand cmd_change_management_validation = conn.CreateCommand();
cmd_change_management_validation.CommandText = "SELECT IT.REQUEST_ID, CM.IT_REQUEST_ID, CM.REQUEST_ID, IT.STATUS, IT.JOB_TYPE, IT.SYSTEM_TYPE, CM.STATUS " +
"FROM WF_IT_REQUEST_REGISTER IT, WF_CM_REQUEST_REGISTER CM " +
"WHERE IT.REQUEST_ID = CM.IT_REQUEST_ID AND IT.REQUEST_ID = '" + ReqID + "' AND IT.STATUS = 'APPROVE' ";
OracleDataReader odr_get_matching_recored_count = cmd_change_management_validation.ExecuteReader();
DataTable dt_records = new DataTable();
dt_records.Load(odr_get_matching_recored_count);
if (dt_records.Rows.Count != 0)
{
odr_get_matching_recored_count.Close();
conn.Clone();
Response.Redirect("~/Views/ITWorkflow/IT_WF_Dashboard_New.aspx?ecode=e_01", false);
}
else
{
odr_get_matching_recored_count.Close();
conn.Close();
Response.Redirect("~/Views/ChangeManagement/IntimateChange.aspx?ReqID=" + ReqID, false);
}
}
catch (Exception ex)
{
throw ex;
}
}
if (e.CommandName == "SelectID")
{
GridDataItem dataitem = e.Item as GridDataItem;
string ReqID = dataitem["REQUEST_ID"].Text;
Response.Redirect("HelpDeskView.aspx?ReqID=" + ReqID, false);
OracleConnection conn = new OracleConnection(myConn);
conn.Open();
try
{
OracleCommand cmd_change_management_validation = conn.CreateCommand();
cmd_change_management_validation.CommandText = "SELECT IT.REQUEST_ID, CM.IT_REQUEST_ID, CM.REQUEST_ID, IT.STATUS, IT.JOB_TYPE, IT.SYSTEM_TYPE, CM.STATUS " +
"FROM WF_IT_REQUEST_REGISTER IT, WF_CM_REQUEST_REGISTER CM " +
"WHERE IT.REQUEST_ID = CM.IT_REQUEST_ID AND IT.REQUEST_ID = '" + ReqID + "' AND IT.STATUS = 'APPROVE' ";
OracleDataReader odr_get_matching_recored_count = cmd_change_management_validation.ExecuteReader();
DataTable dt_records = new DataTable();
dt_records.Load(odr_get_matching_recored_count);
if (dt_records.Rows.Count != 0)
{
odr_get_matching_recored_count.Close();
conn.Clone();
Response.Redirect("~/Views/ITWorkflow/IT_WF_Dashboard_New.aspx?ecode=e_02", false);
}
else
{
Response.Redirect("~/Views/ITWorkflow/IT_WF_Dashboard_New.aspx?ecode=e_03", false);
}
}
catch (Exception ex)
{
throw ex;
}
}
}
protected void RadGrid1_ItemCommand(object sender, GridCommandEventArgs e)
{
}
protected void RG_Skills_ItemCommand(object source, GridCommandEventArgs e)
{
try
{
if (Mode == 0)
{
if (e.CommandName == "Edit_Rec")
{
GridDataItem dtItem = (GridDataItem)e.Item;
int index = dtItem.ItemIndex;
Label lblID = new Label();
Label lblLastUsed = new Label();
Label lbl_ExpertID = new Label();
lblID = RG_Skills.Items[index].FindControl("lbl_Skill_ID") as Label;
lblLastUsed = RG_Skills.Items[index].FindControl("lbl_Skill_LastUsed") as Label;
lbl_ExpertID = RG_Skills.Items[index].FindControl("lbl_Skill_Exp_ID") as Label;
rcb_Skill.SelectedIndex = rcb_Skill.FindItemIndexByValue(lblID.Text);
rcb_YearLastUsed.SelectedIndex = rcb_YearLastUsed.FindItemIndexByText(lblLastUsed.Text);
//rcb_ExpertLevel.SelectedItem.Text = Convert.ToString(lbl_ExpertID.Text).Trim();
rcb_ExpertLevel.SelectedIndex = Convert.ToInt32(lbl_ExpertID.Text);
btn_Skill_Add.Visible = false;
if (Convert.ToInt32(Session["WRITEFACILITY"]) == 2)
{
btn_Skill_Correct.Visible = false;
}
else
{
btn_Skill_Correct.Visible = true;
}
rcb_Skill.Enabled = false;
Mode = 1;
}
}
else
{
if (e.CommandName == "Edit_Rec")
{
GridDataItem dtItem = (GridDataItem)e.Item;
int index = dtItem.ItemIndex;
Label lbl_ID = new Label();
Label lblID = new Label();
Label lbl_ExpertID = new Label();
Label lblLastUsed = new Label();
lbl_ID = RG_Skills.Items[index].FindControl("lblID") as Label;
lblID = RG_Skills.Items[index].FindControl("lbl_Skill_ID") as Label;
lblLastUsed = RG_Skills.Items[index].FindControl("lbl_Skill_LastUsed") as Label;
lbl_ExpertID = RG_Skills.Items[index].FindControl("lbl_Skill_Exp_ID") as Label;
rcb_Skill.SelectedIndex = rcb_Skill.FindItemIndexByValue(lblID.Text);
rcb_YearLastUsed.SelectedIndex = rcb_YearLastUsed.FindItemIndexByText(lblLastUsed.Text);
rcb_ExpertLevel.SelectedValue = Convert.ToString(lbl_ExpertID.Text).Trim();
_lbl_ID = lbl_ID.Text;
btn_Skill_Add.Visible = false;
if (Convert.ToInt32(Session["WRITEFACILITY"]) == 2)
{
btn_Skill_Correct.Visible = false;
}
else
{
btn_Skill_Correct.Visible = true;
}
rcb_Skill.Enabled = false;
Mode = 2;
}
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frmEmpSkills", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void RadGrid1_ItemCommand(object sender, GridCommandEventArgs e)
{
//RadGrid2.SelectedIndexes.Clear();
}
protected void RadOtherVaccine_EditCommand(object sender, GridCommandEventArgs e)
{
//GetImmunisationDetaisOther();
RadOtherVaccine.DataSource = (DataTable)ViewState["TblImmunisation"];
RadOtherVaccine.DataBind();
}
protected void OnItemCommand(object sender, GridCommandEventArgs e)
{
if (e.CommandName == "RowClick")
{
}
}
protected void RadGrid1_InsertCommand(object source, GridCommandEventArgs e)
{
try
{
GridEditableItem editedItem = e.Item as GridEditableItem;
GridEditManager editMan = editedItem.EditManager;
int i = 2;
int j = 0;
dt = (DataTable)Session[SessionContents.FPS_AddProspect_DataTable];
dr = dt.NewRow();
foreach (GridColumn column in e.Item.OwnerTableView.RenderColumns)
{
if (column is IGridEditableColumn)
{
IGridEditableColumn editableCol = (column as IGridEditableColumn);
if (editableCol.IsEditable)
{
IGridColumnEditor editor = editMan.GetColumnEditor(editableCol);
string editorType = editor.ToString();
string editorText = "unknown";
object editorValue = null;
if (editor is GridTextColumnEditor)
{
editorText = (editor as GridTextColumnEditor).Text;
editorValue = (editor as GridTextColumnEditor).Text;
}
if (editor is GridBoolColumnEditor)
{
editorText = (editor as GridBoolColumnEditor).Value.ToString();
editorValue = (editor as GridBoolColumnEditor).Value;
}
if (editor is GridDropDownColumnEditor)
{
editorText = (editor as GridDropDownColumnEditor).SelectedValue;
editorValue = (editor as GridDropDownColumnEditor).SelectedValue;
}
if (editor is GridTemplateColumnEditor)
{
if (i != 3)
{
TextBox txt = (TextBox)e.Item.FindControl("txtIPName");
editorText = txt.Text;
editorValue = txt.Text;
}
else if (i == 3)
{
TextBox txt = (TextBox)e.Item.FindControl("txtIPComments");
editorText = txt.Text;
editorValue = txt.Text;
}
}
try
{
dr[i] = editorText;
}
catch (Exception ex)
{
RadGrid1.Controls.Add(new LiteralControl("<strong>Unable to set value of column '" + column.UniqueName + "'</strong> - " + ex.Message));
e.Canceled = true;
break;
}
}
i++;
}
}
if (dr.ItemArray[2].ToString() != "")
{
dt.Rows.Add(dr);
Session[SessionContents.FPS_AddProspect_DataTable] = dt;
Rebind(false);
}
else
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Message", "javascript:ValidateIPTextBox();", true);
}
}
catch (Exception ex)
{
e.Canceled = true;
throw ex;
}
}
protected void rgPersonal_InsertCommand(object sender, GridCommandEventArgs e)
{
GrabarActualizar(sender, e, "add");
}
/// <summary>
/// 添加权限
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void RG_Power_InsertCommand(object sender, GridCommandEventArgs e)
{
var editedItem = e.Item as GridEditableItem;
var info = new CompanyInvoicePowerInfo();
Guid parentPowerID = Guid.NewGuid();
info.PowerID = parentPowerID;
if (editedItem != null)
{
info.FilialeID = new Guid(((DropDownList)editedItem.FindControl("DDL_Filiale")).SelectedValue);
info.BranchID = new Guid(((DropDownList)editedItem.FindControl("DDL_Branch")).SelectedValue);
info.PositionID = new Guid(((DropDownList)editedItem.FindControl("DDL_Position")).SelectedValue);
info.AuditorID = new Guid(((DropDownList)editedItem.FindControl("DDL_Personnel")).SelectedValue);
info.InvoicesType = int.Parse(((DropDownList)editedItem.FindControl("DDL_InvoiceType")).SelectedValue);
}
info.BindingType = (int)CompanyFundReceiptPowerBindType.DirectBind;
info.CompanyID = CompanyID;
info.ParentPowerID = Guid.Empty;
try
{
_companyInvoicePower.InsertCompanyInvoicePower(info);
CompanyClassInfo companyClassInfo = _companyClass.GetCompanyClass(CompanyID);
if (companyClassInfo.CompanyClassId != Guid.Empty)
{
IList <CompanyClassInfo> classList = _companyClass.GetChildCompanyClassList(CompanyID).ToList();
if (classList.Count > 0)
{
foreach (CompanyClassInfo cInfo in classList)
{
info.PowerID = Guid.NewGuid();
info.BindingType = (int)CompanyFundReceiptPowerBindType.ExpandBind;
info.CompanyID = cInfo.CompanyClassId;
info.ParentPowerID = parentPowerID;
_companyInvoicePower.InsertCompanyInvoicePower(info);
IList <CompanyCussentInfo> cussentList = _companyCussent.GetCompanyCussentList(cInfo.CompanyClassId).ToList();
if (cussentList.Count > 0)
{
foreach (CompanyCussentInfo cussentInfo in cussentList)
{
info.PowerID = Guid.NewGuid();
info.BindingType = (int)CompanyFundReceiptPowerBindType.ExpandBind;
info.CompanyID = cussentInfo.CompanyId;
info.ParentPowerID = parentPowerID;
_companyInvoicePower.InsertCompanyInvoicePower(info);
}
}
}
}
else
{
IList <CompanyCussentInfo> cussentList = _companyCussent.GetCompanyCussentList(CompanyID).ToList();
if (cussentList.Count > 0)
{
foreach (CompanyCussentInfo cussentInfo in cussentList)
{
info.PowerID = Guid.NewGuid();
info.BindingType = (int)CompanyFundReceiptPowerBindType.ExpandBind;
info.CompanyID = cussentInfo.CompanyId;
info.ParentPowerID = parentPowerID;
_companyInvoicePower.InsertCompanyInvoicePower(info);
}
}
}
}
RG_Power.Rebind();
}
catch (Exception ex)
{
RAM.Alert("权限添加失败！" + ex);
}
}
protected void RadGrid1_UpdateCommand(object source, GridCommandEventArgs e)
{
GridEditableItem editedItem = e.Item as GridEditableItem;
string ch_label = null;
Int32 ch_status_int;
Int32 ch_type_int;
string enb_ind_str;
string int_ind_str;
decimal area_id_dec;
string displayname = User.Identity.Name;
Int32 trolley_type_int;
decimal Chuteid = decimal.Parse(editedItem.OwnerTableView.DataKeyValues[e.Item.ItemIndex]["chute_id"].ToString());
RadTextBox chlabel = (RadTextBox)editedItem.FindControl("ch_label_TextBox");
ch_label = chlabel.Text.ToString();
//RadComboBox chstatus = (RadComboBox)editedItem.FindControl("ch_status_RadComboBox");
RadComboBox chtype = (RadComboBox)editedItem.FindControl("ch_type_RadComboBox");
RadComboBox enbind = (RadComboBox)editedItem.FindControl("ch_enb_ind_RadComboBox");
//RadComboBox intind = (RadComboBox)editedItem.FindControl("ch_int_ind_RadComboBox");
RadComboBox areaid = (RadComboBox)editedItem.FindControl("ch_area_RadComboBox");
RadComboBox trolleytype = (RadComboBox)editedItem.FindControl("trolleytype_RadComboBox");
//ch_status_int = Int32.Parse(chstatus.SelectedValue);
ch_status_int = 3;
ch_type_int = Int32.Parse(chtype.SelectedValue);
enb_ind_str = enbind.SelectedValue.ToString();
//int_ind_str = intind.SelectedValue.ToString();
area_id_dec = decimal.Parse(areaid.SelectedValue);
if (ch_type_int == 2)//multi chute
{
trolley_type_int = Int32.Parse(trolleytype.SelectedValue);
}
else
{
trolley_type_int = 0;
}
ChuteDAO chuteinsert = new ChuteDAO();
try
{
decimal chuteid = chuteinsert.Update_Chute(Chuteid,
ch_label,
ch_status_int,
ch_type_int,
enb_ind_str,
area_id_dec,
displayname,
trolley_type_int);
if (chuteid == 0)
{
// display error
string err_msg = "Error while updating Chute ID: " + Chuteid;
HandleError(err_msg, 1);
}
else if (chuteid == -1)
{
string err_msg = "Area in Use. Cannot update Chute";
HandleError(err_msg, 1);
}
else
{
HandleError("Chute Updated", 0);
}
}
catch (Exception ex_upd)
{
string err = ex_upd.Message;
HandleError(err, 1);
}
BindData();
}
//添加属性
protected void FieldGrid_InsertCommand(object sender, GridCommandEventArgs e)
{
var editedItem = (GridEditableItem)e.Item;
var fieldId = Guid.NewGuid();
Guid parentfieldId;
string fieldName;
string fieldValue;
FieldInfo fieldInfo;
switch (editedItem.OwnerTableView.DataMember)
{
case "TopField":
{
parentfieldId = Guid.Empty;
fieldName = ((TextBox)editedItem.FindControl("TB_FieldName")).Text;
fieldValue = ((TextBox)editedItem.FindControl("TB_FieldValue")).Text;
try
{
fieldInfo = new FieldInfo
{
FieldId = fieldId,
ParentFieldId = parentfieldId,
FieldName = fieldName,
FieldValue = fieldValue
};
string errorMessage;
var result = _goodsFieldSao.AddField(fieldInfo, out errorMessage);
if (result)
{
//商品属性添加操作记录添加
var personnelInfo = CurrentSession.Personnel.Get();
WebControl.AddOperationLog(personnelInfo.PersonnelId, personnelInfo.RealName, fieldId, "",
OperationPoint.GoodsAttributeManager.Add.GetBusinessInfo(), string.Empty);
//WebControl.AddCommodityAttributeOperation(HRS.Enum.OperationTypePoint.OperationLogTypeEnum.CommodityAttribute, CurrentSession.Personnel.Get().PersonnelId, fieldId, fieldName + fieldValue, HRS.Enum.OperationTypePoint.CommodityAttributeState.AddAttribute, string.Empty);
FieldGrid.Rebind();
}
else
{
RAM.Alert("操作无效！" + errorMessage);
}
}
catch
{
RAM.Alert("商品属性信息添加失败！");
}
}
break;
case "CombField":
{
GridDataItem parentItem = editedItem.OwnerTableView.ParentItem;
parentfieldId = new Guid(parentItem.GetDataKeyValue("FieldId").ToString());
fieldName = ((Label)parentItem.FindControl("LB_FieldName")).Text;
fieldValue = ((TextBox)editedItem.FindControl("TB_FieldValue")).Text;
try
{
fieldInfo = new FieldInfo
{
FieldId = fieldId,
ParentFieldId = parentfieldId,
FieldName = fieldName,
FieldValue = fieldValue
};
string errorMessage;
var result = _goodsFieldSao.AddField(fieldInfo, out errorMessage);
if (result)
{
//商品属性添加操作记录添加
var personnelInfo = CurrentSession.Personnel.Get();
WebControl.AddOperationLog(personnelInfo.PersonnelId, personnelInfo.RealName, fieldId, "",
OperationPoint.GoodsAttributeManager.Add.GetBusinessInfo(), string.Empty);
//WebControl.AddCommodityAttributeOperation(HRS.Enum.OperationTypePoint.OperationLogTypeEnum.CommodityAttribute, CurrentSession.Personnel.Get().PersonnelId, fieldId, fieldName + fieldValue, HRS.Enum.OperationTypePoint.CommodityAttributeState.AddAttribute, string.Empty);
editedItem.OwnerTableView.Rebind();
}
else
{
RAM.Alert("操作无效！" + errorMessage);
}
}
catch
{
RAM.Alert("商品属性信息添加失败！");
}
}
break;
}
}
protected void RadGrid1_ItemCommand(object sender, GridCommandEventArgs e)
{
if (e.CommandName == "QuickUpdate")
{
string ProjectCategoryID, IsShowOnMenu, IsShowOnHomePage, IsAvailable;
var oProjectCategory = new ProjectCategory();
foreach (GridDataItem item in RadGrid1.Items)
{
ProjectCategoryID = item.GetDataKeyValue("ProjectCategoryID").ToString();
IsShowOnMenu = ((CheckBox)item.FindControl("chkIsShowOnMenu")).Checked.ToString();
IsShowOnHomePage = ((CheckBox)item.FindControl("chkIsShowOnHomePage")).Checked.ToString();
IsAvailable = ((CheckBox)item.FindControl("chkIsAvailable")).Checked.ToString();
oProjectCategory.ProjectCategoryQuickUpdate(
ProjectCategoryID,
IsShowOnMenu,
IsShowOnHomePage,
IsAvailable
);
}
}
else if (e.CommandName == "DeleteSelected")
{
var oProjectCategory = new ProjectCategory();
var errorList = "";
foreach (GridDataItem item in RadGrid1.SelectedItems)
{
var isChildCategoryExist = oProjectCategory.ProjectCategoryIsChildrenExist(item.GetDataKeyValue("ProjectCategoryID").ToString());
var ProjectCategoryName = ((Label)item.FindControl("lblProjectCategoryName")).Text;
var ProjectCategoryNameEn = ((Label)item.FindControl("lblProjectCategoryNameEn")).Text;
if (isChildCategoryExist)
{
errorList += ", " + ProjectCategoryName;
}
else
{
string strImageName = ((HiddenField)item.FindControl("hdnImageName")).Value;
if (!string.IsNullOrEmpty(strImageName))
{
string strSavePath = Server.MapPath("~/res/projectcategory/" + strImageName);
if (File.Exists(strSavePath))
{
File.Delete(strSavePath);
}
}
}
}
if (!string.IsNullOrEmpty(errorList))
{
e.Canceled = true;
string strAlertMessage = "Danh mục <b>\"" + errorList.Remove(0, 1).Trim() + "\"</b> đang có danh mục con hoặc sản phẩm.<br /> Xin xóa danh mục con hoặc sản phẩm trong danh mục này hoặc thiết lập hiển thị = \"không\".";
lblError.Text = strAlertMessage;
}
}
else if (e.CommandName == "PerformInsert" || e.CommandName == "Update")
{
var command = e.CommandName;
var row = command == "PerformInsert" ? (GridEditFormInsertItem)e.Item : (GridEditFormItem)e.Item;
var FileImageName = (RadUpload)row.FindControl("FileImageName");
string strProjectCategoryName = ((RadTextBox)row.FindControl("txtProjectCategoryName")).Text.Trim();
string strProjectCategoryNameEn = ((RadTextBox)row.FindControl("txtProjectCategoryNameEn")).Text.Trim();
string strProjectCategoryLink = ((RadTextBox)row.FindControl("txtProjectCategoryLink")).Text.Trim();
string strProjectCategoryLinkEn = ((RadTextBox)row.FindControl("txtProjectCategoryLinkEn")).Text.Trim();
string strConvertedProjectCategoryName = Common.ConvertTitle(strProjectCategoryName);
string strDescription = HttpUtility.HtmlDecode(FCKEditorFix.Fix(((RadEditor)row.FindControl("txtDescription")).Content.Trim()));
string strDescriptionEn = HttpUtility.HtmlDecode(FCKEditorFix.Fix(((RadEditor)row.FindControl("txtDescriptionEn")).Content.Trim()));
string strContent = HttpUtility.HtmlDecode(FCKEditorFix.Fix(((RadEditor)row.FindControl("txtContent")).Content.Trim()));
string strContentEn = HttpUtility.HtmlDecode(FCKEditorFix.Fix(((RadEditor)row.FindControl("txtContentEn")).Content.Trim()));
string strMetaTitle = ((RadTextBox)row.FindControl("txtMetaTitle")).Text.Trim();
string strMetaTitleEn = ((RadTextBox)row.FindControl("txtMetaTitleEn")).Text.Trim();
string strMetaDescription = ((RadTextBox)row.FindControl("txtMetaDescription")).Text.Trim();
string strMetaDescriptionEn = ((RadTextBox)row.FindControl("txtMetaDescriptionEn")).Text.Trim();
string strImageName = FileImageName.UploadedFiles.Count > 0 ? FileImageName.UploadedFiles[0].GetName() : "";
string strParentID = ((RadComboBox)row.FindControl("ddlParent")).SelectedValue;
if ("".Equals(strParentID))
{
strParentID = "17";
}
string strIsAvailable = ((CheckBox)row.FindControl("chkIsAvailable")).Checked.ToString();
string strIsShowOnMenu = ((CheckBox)row.FindControl("chkIsShowOnMenu")).Checked.ToString();
string strIsShowOnHomePage = ((CheckBox)row.FindControl("chkIsShowOnHomePage")).Checked.ToString();
var oProjectCategory = new ProjectCategory();
if (e.CommandName == "PerformInsert")
{
strImageName = oProjectCategory.ProjectCategoryInsert(
strProjectCategoryName,
strProjectCategoryNameEn,
strProjectCategoryLink,
strProjectCategoryLinkEn,
strConvertedProjectCategoryName,
strDescription,
strDescriptionEn,
strContent,
strContentEn,
strMetaTitle,
strMetaTitleEn,
strMetaDescription,
strMetaDescriptionEn,
strImageName,
strParentID,
strIsShowOnMenu,
strIsShowOnHomePage,
strIsAvailable
);
string strFullPath = "~/res/projectcategory/" + strImageName;
if (!string.IsNullOrEmpty(strImageName))
{
FileImageName.UploadedFiles[0].SaveAs(Server.MapPath(strFullPath));
ResizeCropImage.ResizeByCondition(strFullPath, 40, 40);
}
RadGrid1.Rebind();
}
else
{
var dsUpdateParam = ObjectDataSource1.UpdateParameters;
var strProjectCategoryID = row.GetDataKeyValue("ProjectCategoryID").ToString();
var strOldImageName = ((HiddenField)row.FindControl("hdnImageName")).Value;
var strOldImagePath = Server.MapPath("~/res/projectcategory/" + strOldImageName);
dsUpdateParam["ProjectCategoryName"].DefaultValue = strProjectCategoryName;
dsUpdateParam["ProjectCategoryNameEn"].DefaultValue = strProjectCategoryNameEn;
dsUpdateParam["ProjectCategoryLink"].DefaultValue = strProjectCategoryLink;
dsUpdateParam["ProjectCategoryLinkEn"].DefaultValue = strProjectCategoryLinkEn;
dsUpdateParam["ConvertedProjectCategoryName"].DefaultValue = strConvertedProjectCategoryName;
dsUpdateParam["Description"].DefaultValue = strDescription;
dsUpdateParam["DescriptionEn"].DefaultValue = strDescriptionEn;
dsUpdateParam["Content"].DefaultValue = strContent;
dsUpdateParam["ContentEn"].DefaultValue = strContentEn;
dsUpdateParam["ImageName"].DefaultValue = strImageName;
dsUpdateParam["ParentID"].DefaultValue = strParentID;
dsUpdateParam["IsShowOnMenu"].DefaultValue = strIsShowOnMenu;
dsUpdateParam["IsShowOnHomePage"].DefaultValue = strIsShowOnHomePage;
dsUpdateParam["IsAvailable"].DefaultValue = strIsAvailable;
if (!string.IsNullOrEmpty(strImageName))
{
var strFullPath = "~/res/projectcategory/" + strConvertedProjectCategoryName + "-" + strProjectCategoryID + strImageName.Substring(strImageName.LastIndexOf('.'));
if (File.Exists(strOldImagePath))
{
File.Delete(strOldImagePath);
}
FileImageName.UploadedFiles[0].SaveAs(Server.MapPath(strFullPath));
ResizeCropImage.ResizeByCondition(strFullPath, 40, 40);
}
}
}
if (e.CommandName == "DeleteImage")
{
var oProjectCategory = new ProjectCategory();
var lnkDeleteImage = (LinkButton)e.CommandSource;
var s = lnkDeleteImage.Attributes["rel"].ToString().Split('#');
var strProjectCategoryID = s[0];
var strImageName = s[1];
oProjectCategory.ProjectCategoryImageDelete(strProjectCategoryID);
DeleteImage(strImageName);
RadGrid1.Rebind();
}
}
protected void rdgItemList_ItemCommand(object sender, GridCommandEventArgs e)
{
LoadItemList();
}
/// <summary>
/// Grid1_RowCommand
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Grid1_RowCommand(object sender, GridCommandEventArgs e)
{
}
protected void gvReports_ItemCommand(object sender, GridCommandEventArgs e)
{
}
protected void RadGrid1_ItemCommand(object sender, GridCommandEventArgs e)
{
if (e.CommandName == "alpha" || e.CommandName == "NoFilter")
{
String value = null;
switch (e.CommandName)
{
case ("alpha"):
{
value = string.Format("{0}%", e.CommandArgument);
break;
}
case ("NoFilter"):
{
value = "%";
break;
}
}
ObjectDataSource1.SelectParameters["ProjectTitle"].DefaultValue = value;
ObjectDataSource1.DataBind();
RadGrid1.Rebind();
}
else if (e.CommandName == "QuickUpdate")
{
string ProjectID, Priority, IsHot, IsNew, IsShowOnHomePage, IsAvailable;
var oProject = new Project();
foreach (GridDataItem item in RadGrid1.Items)
{
ProjectID = item.GetDataKeyValue("ProjectID").ToString();
Priority = ((RadNumericTextBox)item.FindControl("txtPriority")).Text.Trim();
IsHot = ((CheckBox)item.FindControl("chkIsHot")).Checked.ToString();
IsNew = ((CheckBox)item.FindControl("chkIsNew")).Checked.ToString();
IsShowOnHomePage = ((CheckBox)item.FindControl("chkIsShowOnHomePage")).Checked.ToString();
IsAvailable = ((CheckBox)item.FindControl("chkIsAvailable")).Checked.ToString();
oProject.ProjectQuickUpdate(
ProjectID,
IsHot,
IsNew,
IsShowOnHomePage,
IsAvailable,
Priority
);
}
}
else if (e.CommandName == "DeleteSelected")
{
string OldImageName;
var oProject = new Project();
string errorList = "", ProjectName = "";
foreach (GridDataItem item in RadGrid1.SelectedItems)
{
try
{
var ProjectID = item.GetDataKeyValue("ProjectID").ToString();
ProjectName = item["ProjectTitle"].Text;
oProject.ProjectDelete(ProjectID);
OldImageName = ((HiddenField)item.FindControl("hdnImageName")).Value;
DeleteImage(OldImageName);
}
catch (Exception ex)
{
lblError.Text = ex.Message;
if (ex.Message == ((int)ErrorNumber.ConstraintConflicted).ToString())
{
errorList += ", " + ProjectName;
}
}
}
if (!string.IsNullOrEmpty(errorList))
{
e.Canceled = true;
string strAlertMessage = "Dự án <b>\"" + errorList.Remove(0, 1).Trim() + " \"</b> đang chứa thư viện ảnh, file download hoặc video .<br /> Xin xóa ảnh, file download hoặc video trong dự án này hoặc thiết lập hiển thị = \"không\".";
lblError.Text = strAlertMessage;
}
RadGrid1.Rebind();
}
else if (e.CommandName == "PerformInsert" || e.CommandName == "Update")
{
var command = e.CommandName;
var row = command == "PerformInsert" ? (GridEditFormInsertItem)e.Item : (GridEditFormItem)e.Item;
var FileImageName = (RadUpload)row.FindControl("FileImageName");
string ProjectID = ((HiddenField)row.FindControl("hdnProjectID")).Value;
string OldImageName = ((HiddenField)row.FindControl("hdnOldImageName")).Value;
string ImageName = FileImageName.UploadedFiles.Count > 0 ? FileImageName.UploadedFiles[0].GetName() : "";
string Priority = ((RadNumericTextBox)row.FindControl("txtPriority")).Text.Trim();
string MetaTittle = ((TextBox)row.FindControl("txtMetaTittle")).Text.Trim();
string MetaDescription = ((TextBox)row.FindControl("txtMetaDescription")).Text.Trim();
string ProjectTitle = ((TextBox)row.FindControl("txtProjectTitle")).Text.Trim();
string ConvertedProjectTitle = Common.ConvertTitle(ProjectTitle);
string Description = ((RadTextBox)row.FindControl("txtDescription")).Text.Trim(); //HttpUtility.HtmlDecode(FCKEditorFix.Fix(((RadEditor)row.FindControl("txtDescription")).Content.Trim()));
string Content = HttpUtility.HtmlDecode(FCKEditorFix.Fix(((RadEditor)row.FindControl("txtContent")).Content.Trim()));
string Tag = ((TextBox)row.FindControl("txtTag")).Text.Trim();
string ProjectCategoryID = ((RadComboBox)row.FindControl("ddlProjectCategory")).SelectedValue;
if ("".Equals(ProjectCategoryID))
{
ProjectCategoryID = "35";
}
string IsHot = ((CheckBox)row.FindControl("chkIsHot")).Checked.ToString();
string IsNew = ((CheckBox)row.FindControl("chkIsNew")).Checked.ToString();
string IsShowOnHomePage = ((CheckBox)row.FindControl("chkIsShowOnHomePage")).Checked.ToString();
string IsAvailable = ((CheckBox)row.FindControl("chkIsAvailable")).Checked.ToString();
string MetaTittleEn = ((TextBox)row.FindControl("txtMetaTittleEn")).Text.Trim();
string MetaDescriptionEn = ((TextBox)row.FindControl("txtMetaDescriptionEn")).Text.Trim();
string ProjectTitleEn = ((TextBox)row.FindControl("txtProjectTitleEn")).Text.Trim();
string DescriptionEn = ((RadTextBox)row.FindControl("txtDescriptionEn")).Text.Trim(); //((RadEditor)row.FindControl("txtDescriptionEn")).Content.Trim();
string ContentEn = ((RadEditor)row.FindControl("txtContentEn")).Content.Trim();
string TagEn = ((TextBox)row.FindControl("txtTagEn")).Text.Trim();
if (e.CommandName == "PerformInsert")
{
var oProject = new Project();
ImageName = oProject.ProjectInsert(
ImageName,
MetaTittle,
MetaDescription,
ProjectTitle,
ConvertedProjectTitle,
Description,
Content,
Tag,
MetaTittleEn,
MetaDescriptionEn,
ProjectTitleEn,
DescriptionEn,
ContentEn,
TagEn,
ProjectCategoryID,
IsHot,
IsNew,
IsShowOnHomePage,
IsAvailable,
Priority
);
string strFullPath = "~/res/project/" + ImageName;
if (!string.IsNullOrEmpty(ImageName))
{
FileImageName.UploadedFiles[0].SaveAs(Server.MapPath(strFullPath));
ResizeCropImage.ResizeByCondition(strFullPath, 800, 800);
ResizeCropImage.CreateThumbNailByCondition("~/res/project/", "~/res/project/thumbs/", ImageName, 120, 120);
}
RadGrid1.Rebind();
}
else
{
var dsUpdateParam = ObjectDataSource1.UpdateParameters;
var strOldImagePath = Server.MapPath("~/res/project/" + OldImageName);
var strOldThumbImagePath = Server.MapPath("~/res/project/thumbs/" + OldImageName);
dsUpdateParam["ConvertedProjectTitle"].DefaultValue = ConvertedProjectTitle;
dsUpdateParam["ImageName"].DefaultValue = ImageName;
dsUpdateParam["ProjectCategoryID"].DefaultValue = ProjectCategoryID;
dsUpdateParam["IsHot"].DefaultValue = IsHot;
dsUpdateParam["IsNew"].DefaultValue = IsNew;
dsUpdateParam["IsShowOnHomePage"].DefaultValue = IsShowOnHomePage;
dsUpdateParam["IsAvailable"].DefaultValue = IsAvailable;
if (!string.IsNullOrEmpty(ImageName))
{
if (File.Exists(strOldImagePath))
{
File.Delete(strOldImagePath);
}
if (File.Exists(strOldThumbImagePath))
{
File.Delete(strOldThumbImagePath);
}
ImageName = (string.IsNullOrEmpty(ConvertedProjectTitle) ? "" : ConvertedProjectTitle + "-") + ProjectID + ImageName.Substring(ImageName.LastIndexOf('.'));
string strFullPath = "~/res/project/" + ImageName;
FileImageName.UploadedFiles[0].SaveAs(Server.MapPath(strFullPath));
ResizeCropImage.ResizeByCondition(strFullPath, 800, 800);
ResizeCropImage.CreateThumbNailByCondition("~/res/project/", "~/res/project/thumbs/", ImageName, 120, 120);
}
}
}
if (e.CommandName == "DeleteImage")
{
var oProject = new Project();
var lnkDeleteImage = (LinkButton)e.CommandSource;
var s = lnkDeleteImage.Attributes["rel"].ToString().Split('#');
var strProjectID = s[0];
var ImageName = s[1];
oProject.ProjectImageDelete(strProjectID);
DeleteImage(ImageName);
RadGrid1.Rebind();
}
}
protected void gridCapturas_ItemCommand(object sender, GridCommandEventArgs e)
{
Int64?_idCampo = null;
bool bit = true;
if (e.CommandName == "pdfArchivos")
{
foreach (GridDataItem item in gridCapturas.MasterTableView.Items)
{
if (item.Selected == true)
{
_idCampo = convertir.toNInt64(item.GetDataKeyValue("Idlaboratorio"));
loadarchivospdfs(_idCampo);
bit = true;
break;
}
}
}
if (e.CommandName == "editGrid")
{
foreach (GridDataItem item in gridCapturas.MasterTableView.Items)
{
if (item.Selected == true)
{
_idCampo = convertir.toNInt64(item.GetDataKeyValue("Idlaboratorio"));
Session["getIdInstalacionGrid"] = _idCampo;
Session["getTipoOp"] = 2;
string script = "function f(){openRadWindow(); Sys.Application.remove_load(f);}Sys.Application.add_load(f);";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "key", script, true);
bit = true;
break;
}
}
}
if (e.CommandName == "delGrid")
{
foreach (GridDataItem item in gridCapturas.MasterTableView.Items)
{
if (item.Selected == true)
{
_idCampo = convertir.toNInt64(item.GetDataKeyValue("Idlaboratorio"));
Session["getIdInstalacionGrid"] = _idCampo;
string script = "function f(){callConfirm(); Sys.Application.remove_load(f);}Sys.Application.add_load(f);";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "key", script, true);
bit = true;
break;
}
}
}
if (e.CommandName == "addGrid")
{
if (Session["getIDInstalacion"] != null)
{
Session["getTipoOp"] = 1;
string script = "function f(){openRadWindow(); Sys.Application.remove_load(f);}Sys.Application.add_load(f);";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "key", script, true);
}
else
{
windowManager1.RadAlert("Debe seleccionar la instalación del centro....", 300, 100, "Registros", null);
}
bit = true;
}
if (bit == false)
{
windowManager1.RadAlert("Debe seleccionar un registro....", 300, 100, "Registros", null);
}
}
protected void RadGrid1_ItemCommand(object sender, GridCommandEventArgs e)
{
if (e.CommandName == "alpha" || e.CommandName == "NoFilter")
{
String value = null;
switch (e.CommandName)
{
case ("alpha"):
{
value = string.Format("{0}%", e.CommandArgument);
break;
}
case ("NoFilter"):
{
value = "%";
break;
}
}
ObjectDataSource1.SelectParameters["ArticleTitle"].DefaultValue = value;
ObjectDataSource1.DataBind();
RadGrid1.Rebind();
}
else if (e.CommandName == "QuickUpdate")
{
string ArticleID, Priority, IsShowOnHomePage, IsHot, IsNew, IsAvailable;
var oArticle = new Article();
foreach (GridDataItem item in RadGrid1.Items)
{
ArticleID = item.GetDataKeyValue("ArticleID").ToString();
Priority = ((RadNumericTextBox)item.FindControl("txtPriority")).Text.Trim();
IsShowOnHomePage = ((CheckBox)item.FindControl("chkIsShowOnHomePage")).Checked.ToString();
IsHot = ((CheckBox)item.FindControl("chkIsHot")).Checked.ToString();
IsNew = ((CheckBox)item.FindControl("chkIsNew")).Checked.ToString();
IsAvailable = ((CheckBox)item.FindControl("chkIsAvailable")).Checked.ToString();
oArticle.ArticleQuickUpdate(
ArticleID,
IsShowOnHomePage,
IsHot,
IsNew,
IsAvailable,
Priority
);
}
}
else if (e.CommandName == "DeleteSelected")
{
string OldImageName;
var oArticle = new Article();
foreach (GridDataItem item in RadGrid1.SelectedItems)
{
OldImageName = ((HiddenField)item.FindControl("hdnImageName")).Value;
DeleteImage(OldImageName);
}
}
else if (e.CommandName == "PerformInsert" || e.CommandName == "Update")
{
var command = e.CommandName;
var row = command == "PerformInsert" ? (GridEditFormInsertItem)e.Item : (GridEditFormItem)e.Item;
var FileImageName = (RadUpload)row.FindControl("FileImageName");
var oArticle = new Article();
string strArticleID = ((HiddenField)row.FindControl("hdnArticleID")).Value;
string strOldImageName = ((HiddenField)row.FindControl("hdnOldImageName")).Value;
string strImageName = FileImageName.UploadedFiles.Count > 0 ? FileImageName.UploadedFiles[0].GetName() : "";
string strPriority = ((RadNumericTextBox)row.FindControl("txtPriority")).Text.Trim();
string strMetaTittle = ((TextBox)row.FindControl("txtMetaTittle")).Text.Trim();
string strMetaDescription = ((TextBox)row.FindControl("txtMetaDescription")).Text.Trim();
string strArticleTitle = ((TextBox)row.FindControl("txtArticleTitle")).Text.Trim();
string strConvertedArticleTitle = Common.ConvertTitle(strArticleTitle);
string strDescription = HttpUtility.HtmlDecode(FCKEditorFix.Fix(((RadEditor)row.FindControl("txtDescription")).Content.Trim()));
string strContent = HttpUtility.HtmlDecode(FCKEditorFix.Fix(((RadEditor)row.FindControl("txtContent")).Content.Trim()));
string strTag = ((TextBox)row.FindControl("txtTag")).Text.Trim();
string strArticleCategoryID = "8";// ((RadComboBox)row.FindControl("ddlCategory")).SelectedValue;
string strIsShowOnHomePage = ((CheckBox)row.FindControl("chkIsShowOnHomePage")).Checked.ToString();
string strIsHot = ((CheckBox)row.FindControl("chkIsHot")).Checked.ToString();
string strIsNew = ((CheckBox)row.FindControl("chkIsNew")).Checked.ToString();
string strIsAvailable = ((CheckBox)row.FindControl("chkIsAvailable")).Checked.ToString();
string strMetaTittleEn = ((TextBox)row.FindControl("txtMetaTittleEn")).Text.Trim();
string strMetaDescriptionEn = ((TextBox)row.FindControl("txtMetaDescriptionEn")).Text.Trim();
string strArticleTitleEn = ((TextBox)row.FindControl("txtArticleTitleEn")).Text.Trim();
string strDescriptionEn = ((RadEditor)row.FindControl("txtDescriptionEn")).Content.Trim();
string strContentEn = ((RadEditor)row.FindControl("txtContentEn")).Content.Trim();
string strTagEn = ((TextBox)row.FindControl("txtTagEn")).Text.Trim();
if (e.CommandName == "PerformInsert")
{
strImageName = oArticle.ArticleInsert(
strImageName,
strMetaTittle,
strMetaDescription,
strArticleTitle,
strConvertedArticleTitle,
strDescription,
strContent,
strTag,
strMetaTittleEn,
strMetaDescriptionEn,
strArticleTitleEn,
strDescriptionEn,
strContentEn,
strTagEn,
strArticleCategoryID,
strIsShowOnHomePage,
strIsHot,
strIsNew,
strIsAvailable,
strPriority
);
string strFullPath = "~/res/article/" + strImageName;
if (!string.IsNullOrEmpty(strImageName))
{
FileImageName.UploadedFiles[0].SaveAs(Server.MapPath(strFullPath));
//ResizeCropImage.ResizeByCondition(strFullPath, 800, 800);
ResizeCropImage.CreateThumbNailByCondition("~/res/article/", "~/res/article/thumbs/", strImageName, 120, 120);
}
RadGrid1.Rebind();
}
else
{
var dsUpdateParam = ObjectDataSource1.UpdateParameters;
var strOldImagePath = Server.MapPath("~/res/article/" + strOldImageName);
var strOldThumbImagePath = Server.MapPath("~/res/article/thumbs/" + strOldImageName);
dsUpdateParam["ArticleTitle"].DefaultValue = strArticleTitle;
dsUpdateParam["ConvertedArticleTitle"].DefaultValue = strConvertedArticleTitle;
dsUpdateParam["ImageName"].DefaultValue = strImageName;
dsUpdateParam["ArticleCategoryID"].DefaultValue = strArticleCategoryID;
dsUpdateParam["IsShowOnHomePage"].DefaultValue = strIsShowOnHomePage;
dsUpdateParam["IsHot"].DefaultValue = strIsHot;
dsUpdateParam["IsNew"].DefaultValue = strIsNew;
dsUpdateParam["IsAvailable"].DefaultValue = strIsAvailable;
if (!string.IsNullOrEmpty(strImageName))
{
if (File.Exists(strOldImagePath))
{
File.Delete(strOldImagePath);
}
if (File.Exists(strOldThumbImagePath))
{
File.Delete(strOldThumbImagePath);
}
strImageName = (string.IsNullOrEmpty(strConvertedArticleTitle) ? "" : strConvertedArticleTitle + "-") + strArticleID + strImageName.Substring(strImageName.LastIndexOf('.'));
string strFullPath = "~/res/article/" + strImageName;
FileImageName.UploadedFiles[0].SaveAs(Server.MapPath(strFullPath));
//ResizeCropImage.ResizeByCondition(strFullPath, 800, 800);
ResizeCropImage.CreateThumbNailByCondition("~/res/article/", "~/res/article/thumbs/", strImageName, 120, 120);
}
}
}
if (e.CommandName == "DeleteImage")
{
var oArticle = new Article();
var lnkDeleteImage = (LinkButton)e.CommandSource;
var s = lnkDeleteImage.Attributes["rel"].ToString().Split('#');
var strArticleID = s[0];
var strImageName = s[1];
oArticle.ArticleImageDelete(strArticleID);
DeleteImage(strImageName);
RadGrid1.Rebind();
}
}
public bool SubmitRecord(object sender, GridCommandEventArgs e)
{
DayCarePL.Logger.Write(DayCarePL.LogType.INFO, DayCarePL.ModuleToLog.SchoolYear, "SubmitRecord", "Submit record method called", DayCarePL.Common.GUID_DEFAULT);
Guid SchoolYearId = new Guid();
bool result = false;
try
{
DayCarePL.Logger.Write(DayCarePL.LogType.DEBUG, DayCarePL.ModuleToLog.SchoolYear, "SubmitRecord", "Debug Submit Record Of SchoolYear", DayCarePL.Common.GUID_DEFAULT);
DayCareBAL.SchoolYearService proxySchoolYear = new DayCareBAL.SchoolYearService();
DayCarePL.SchoolYearProperties objSchoolYear = new DayCarePL.SchoolYearProperties();
GridDataItem item = (GridDataItem)e.Item;
var InsertItem = e.Item as Telerik.Web.UI.GridEditableItem;
Telerik.Web.UI.GridEditManager editMan = InsertItem.EditManager;
if (InsertItem != null)
{
foreach (GridColumn column in e.Item.OwnerTableView.RenderColumns)
{
if (column is GridEditableColumn)
{
IGridEditableColumn editTableColumn = (column as IGridEditableColumn);
if (editTableColumn.IsEditable)
{
IGridColumnEditor editor = editMan.GetColumnEditor(editTableColumn);
switch (column.UniqueName)
{
case "Year":
{
objSchoolYear.Year = (e.Item.FindControl("ddlYear") as DropDownList).SelectedValue;
break;
}
case "StartDate":
{
objSchoolYear.StartDate = (e.Item.FindControl("rdpStartDate") as RadDatePicker).SelectedDate.Value;
break;
}
case "EndDate":
{
if ((e.Item.FindControl("rdpEndDate") as RadDatePicker).SelectedDate != null)
{
objSchoolYear.EndDate = (e.Item.FindControl("rdpEndDate") as RadDatePicker).SelectedDate.Value;
}
else
{
objSchoolYear.EndDate = null;
}
break;
}
case "Comment":
{
objSchoolYear.Comments = (e.Item.FindControl("txtComment") as TextBox).Text;
break;
}
case "CurrentId":
{
objSchoolYear.CurrentId = (editor as GridCheckBoxColumnEditor).Value;
break;
}
}
}
}
}
if (objSchoolYear.EndDate != null)
{
if (objSchoolYear.StartDate > objSchoolYear.EndDate)
{
MasterAjaxManager = this.Page.Master.FindControl("RadAjaxManager1") as Telerik.Web.UI.RadAjaxManager;
MasterAjaxManager.ResponseScripts.Add(string.Format("ShowMessage('{0}','{1}')", "Start Date must be less than End Date.", "false"));
return(false);
}
}
if (Session["SchoolId"] != null)
{
objSchoolYear.SchoolId = new Guid(Session["SchoolId"].ToString());
}
if (e.CommandName != "PerformInsert")
{
if (Session["StaffId"] != null)
{
objSchoolYear.LastModifiedById = new Guid(Session["StaffId"].ToString());
}
objSchoolYear.Id = new Guid(e.Item.OwnerTableView.DataKeyValues[e.Item.ItemIndex]["Id"].ToString());
if (!objSchoolYear.Year.Trim().Equals(hdnName.Value.Trim()))
{
bool ans = proxySchoolYear.CheckDuplicateSchoolYear(objSchoolYear.Year, objSchoolYear.Id, objSchoolYear.SchoolId);
if (ans)
{
MasterAjaxManager = this.Page.Master.FindControl("RadAjaxManager1") as Telerik.Web.UI.RadAjaxManager;
MasterAjaxManager.ResponseScripts.Add(string.Format("ShowMessage('{0}','{1}')", "School Year Already Exist", "false"));
return(false);
}
}
}
else
{
if (Session["StaffId"] != null)
{
objSchoolYear.CreatedById = new Guid(Session["StaffId"].ToString());
}
bool ans = proxySchoolYear.CheckDuplicateSchoolYear(objSchoolYear.Year, objSchoolYear.Id, objSchoolYear.SchoolId);
if (ans)
{
MasterAjaxManager = this.Page.Master.FindControl("RadAjaxManager1") as Telerik.Web.UI.RadAjaxManager;
MasterAjaxManager.ResponseScripts.Add(string.Format("ShowMessage('{0}','{1}')", "School Year Already Exist", "false"));
return(false);
}
}
hdnName.Value = "";
SchoolYearId = proxySchoolYear.Save(objSchoolYear, new Guid(Session["CurrentSchoolYearId"].ToString()));
if (!SchoolYearId.ToString().Equals(DayCarePL.Common.GUID_DEFAULT))
{
MasterAjaxManager = this.Page.Master.FindControl("RadAjaxManager1") as Telerik.Web.UI.RadAjaxManager;
MasterAjaxManager.ResponseScripts.Add(string.Format("ShowMessage('{0}','{1}')", "Saved Successfully", "false"));
if (objSchoolYear.CurrentId == true)
{
Session["CurrentSchoolYearId"] = SchoolYearId;
}
result = true;
Session["SchoolYearMessage"] = true;
}
else
{
result = false;
}
}
}
catch (Exception ex)
{
DayCarePL.Logger.Write(DayCarePL.LogType.EXCEPTION, DayCarePL.ModuleToLog.SchoolYear, "SubmitRecord", ex.Message.ToString(), DayCarePL.Common.GUID_DEFAULT);
result = false;
}
return(result);
}
protected void radgridDevice_InsertCommand(object sender, GridCommandEventArgs e)
{
GridEditFormInsertItem insertedItem = (GridEditFormInsertItem)e.Item;
if (e.Item.OwnerTableView.Name == "Service")
{
Entities.User u = GetCurrentUser();
string s = e.Item.OwnerTableView.ParentItem.GetDataKeyValue("ID").ToString();;//e.Item.Parent.ite
dsService.InsertParameters.Add(new Parameter("DeviceID", DbType.Int32, s));
dsService.InsertParameters.Add(new Parameter("TypeID", DbType.Int32, (insertedItem["ServiceType"].Controls[0] as RadComboBox).SelectedValue));
dsService.InsertParameters.Add(new Parameter("dateIn", DbType.DateTime, (insertedItem["DateInService"].Controls[0] as RadDatePicker).SelectedDate.ToString()));
//Заменить текущим юзером
dsService.InsertParameters.Add(new Parameter("userID", DbType.Int32, u.ID.ToString()));
Parameter p = new Parameter();
p.Direction = ParameterDirection.Output;
p.Name = "ID";
p.DbType = DbType.Int32;
dsService.InsertParameters.Add(p);
dsService.Insert();
radWM.RadAlert("Тип обслуживания был успешно добавлен.", 300, 200, "", "123");
}
if (e.Item.OwnerTableView.Name == "Device")
{
dsDevices.InsertParameters.Add(new Parameter("fn", DbType.String, (insertedItem["FN"].Controls[0] as TextBox).Text));
dsDevices.InsertParameters.Add(new Parameter("title", DbType.String, (insertedItem["Title"].Controls[0] as TextBox).Text));
dsDevices.InsertParameters.Add(new Parameter("description", DbType.String, (insertedItem["Description"].Controls[0] as TextBox).Text));
dsDevices.InsertParameters.Add(new Parameter("typeid", DbType.Int32, (insertedItem["DeviceType"].Controls[0] as RadComboBox).SelectedValue));
Parameter p = new Parameter();
p.Direction = ParameterDirection.Output;
p.Name = "ID";
p.DbType = DbType.Int32;
dsDevices.InsertParameters.Add(p);
dsDevices.Insert();
radWM.RadAlert("Устройство было успешно добавлено.", 300, 200, "", "123");
}
if (e.Item.OwnerTableView.Name == "Works")
{
string s = e.Item.OwnerTableView.ParentItem.GetDataKeyValue("ID").ToString();
dsEventWork.InsertParameters["EventID"].DefaultValue = s;
dsEventWork.InsertParameters["TypeWorkID"].DefaultValue = (insertedItem["WorkType"].Controls[0] as RadComboBox).SelectedValue;
dsEventWork.Insert();
radWM.RadAlert("Вид работы \"" + (insertedItem["WorkType"].Controls[0] as RadComboBox).SelectedItem.Text + "\" был успешно добавлен.", 300, 200, "", "123");
}
if (e.Item.OwnerTableView.Name == "WP")
{
//string s = e.Item.OwnerTableView.ParentItem.GetDataKeyValue("ID").ToString();
dsWP.InsertParameters.Add("LocationID", DbType.Int32, (insertedItem["WPLocation"].Controls[0] as RadComboBox).SelectedValue);
dsWP.InsertParameters.Add("Title", DbType.String, (insertedItem["Title"].Controls[0] as TextBox).Text);
dsWP.InsertParameters.Add("LF", DbType.Double, (insertedItem["LineFirst"].Controls[0] as TextBox).Text);
dsWP.InsertParameters.Add("LS", DbType.Double, (insertedItem["LineSecond"].Controls[0] as TextBox).Text);
dsWP.InsertParameters.Add("D", DbType.Int32, (insertedItem["D"].Controls[0] as TextBox).Text);
dsWP.InsertParameters.Add("DCalc", DbType.Int32, (insertedItem["DCalc"].Controls[0] as TextBox).Text);
dsWP.InsertParameters.Add("Qmin", DbType.Int32, (insertedItem["QMin"].Controls[0] as TextBox).Text);
dsWP.InsertParameters.Add("Qmax", DbType.Int32, (insertedItem["QMax"].Controls[0] as TextBox).Text);
dsWP.InsertParameters.Add("Comment", DbType.String, (insertedItem["Comment"].Controls[0] as TextBox).Text);
dsWP.InsertParameters.Add("TypeID", DbType.Int32, (insertedItem["WPType"].Controls[0] as RadComboBox).SelectedValue);
dsWP.InsertParameters.Add("StartDate", DbType.DateTime, (insertedItem["StartDate"].Controls[0] as RadDatePicker).SelectedDate.ToString());
dsWP.Insert();
radWM.RadAlert("Водоузел был успешно добавлен.", 300, 200, "", "123");
}
if (e.Item.OwnerTableView.Name == "Device")
{
dsDevices.InsertParameters.Add(new Parameter("fn", DbType.String, (insertedItem["FN"].Controls[0] as TextBox).Text));
dsDevices.InsertParameters.Add(new Parameter("title", DbType.String, (insertedItem["Title"].Controls[0] as TextBox).Text));
dsDevices.InsertParameters.Add(new Parameter("description", DbType.String, (insertedItem["Description"].Controls[0] as TextBox).Text));
dsDevices.InsertParameters.Add(new Parameter("typeid", DbType.Int32, (insertedItem["DeviceType"].Controls[0] as RadComboBox).SelectedValue));
dsDevices.Insert();
radWM.RadAlert("Устройство было успешно добавлено.", 300, 200, "", "123");
}
if (e.Item.OwnerTableView.Name == "Event")
{
Entities.User u = GetCurrentUser();
string s = e.Item.OwnerTableView.ParentItem.GetDataKeyValue("ID").ToString();;//e.Item.Parent.ite
dsEvents.InsertParameters["WPID"].DefaultValue = s;
dsEvents.InsertParameters["WPTypeEventID"].DefaultValue = (insertedItem["EventType"].Controls[0] as RadComboBox).SelectedValue;
dsEvents.InsertParameters["WPEventSourceTypeID"].DefaultValue = (insertedItem["EventSource"].Controls[0] as RadComboBox).SelectedValue;
dsEvents.InsertParameters["DateIn"].DefaultValue = (insertedItem["DateInService"].Controls[0] as RadDatePicker).SelectedDate.ToString();
dsEvents.InsertParameters["UserID"].DefaultValue = u.ID.ToString();
dsEvents.Insert();
e.Item.Edit = false;
radWM.RadAlert("Выезд был успешно добавлен.", 300, 200, "", "123");
//radgrid.Rebind();
}
e.Item.Edit = false;
e.Canceled = false;
//radgridDevice.Rebind();
}
protected void RadGrid1_ItemCommand(object sender, GridCommandEventArgs e)
{
if (e.CommandName == "alpha" || e.CommandName == "NoFilter")
{
String value = null;
switch (e.CommandName)
{
case ("alpha"):
{
value = string.Format("{0}%", e.CommandArgument);
break;
}
case ("NoFilter"):
{
value = "%";
break;
}
}
ObjectDataSource1.SelectParameters["CompanyName"].DefaultValue = value;
ObjectDataSource1.DataBind();
RadGrid1.Rebind();
}
else if (e.CommandName == "QuickUpdate")
{
string AdsBannerID, Priority, IsAvailable;
var oAdsBanner = new AdsBanner();
foreach (GridDataItem item in RadGrid1.Items)
{
AdsBannerID = item.GetDataKeyValue("AdsBannerID").ToString();
Priority = ((RadNumericTextBox)item.FindControl("txtPriority")).Text.Trim();
IsAvailable = ((CheckBox)item.FindControl("chkIsAvailable")).Checked.ToString();
oAdsBanner.AdsBannerQuickUpdate(
AdsBannerID,
Priority,
IsAvailable
);
}
}
else if (e.CommandName == "DeleteSelected")
{
var oAdsBanner = new AdsBanner();
foreach (GridDataItem item in RadGrid1.SelectedItems)
{
string strFileName = ((HiddenField)item.FindControl("hdnFileName")).Value;
if (!string.IsNullOrEmpty(strFileName))
{
string strSavePath = Server.MapPath("~/res/advertisement/" + strFileName);
if (File.Exists(strSavePath))
{
File.Delete(strSavePath);
}
}
}
}
else if (e.CommandName == "PerformInsert" || e.CommandName == "Update")
{
var command = e.CommandName;
var row = command == "PerformInsert" ? (GridEditFormInsertItem)e.Item : (GridEditFormItem)e.Item;
var FileFileName = (RadUpload)row.FindControl("FileFileName");
var dpFromDate = (RadDatePicker)row.FindControl("dpFromDate");
var dpToDate = (RadDatePicker)row.FindControl("dpToDate");
string strCompanyName = HttpUtility.HtmlDecode(FCKEditorFix.Fix(((RadEditor)row.FindControl("txtCompanyName")).Content.Trim()));//((TextBox)row.FindControl("txtCompanyName")).Text.Trim();
//string strTitle = ((TextBox)row.FindControl("txtTitle")).Text.Trim();
//string strDescription = ((TextBox)row.FindControl("txtDescription")).Text.Trim();
string strConvertedAdsBannerName = Common.ConvertTitle(strCompanyName);
string strFileName = FileFileName.UploadedFiles.Count > 0 ? FileFileName.UploadedFiles[0].GetName() : "";
string strIsAvailable = ((CheckBox)row.FindControl("chkIsAvailable")).Checked.ToString();
string strPriority = ((RadNumericTextBox)row.FindControl("txtPriority")).Text.Trim();
string strFromDate = dpFromDate.SelectedDate.HasValue ? dpFromDate.SelectedDate.Value.ToString("MM/dd/yyyy") : "";
string strToDate = dpToDate.SelectedDate.HasValue ? dpToDate.SelectedDate.Value.ToString("MM/dd/yyyy") : "";
string strAdsCategoryID = "11";// ((RadComboBox)row.FindControl("ddlCategory")).SelectedValue;
string strWebsite = ((TextBox)row.FindControl("txtWebsite")).Text.Trim();
double ratio = 0;
if (!string.IsNullOrEmpty(strFileName))
{
string strTempPath = Server.MapPath(FileFileName.TargetFolder + strFileName);
if (IsImageFormat(strFileName))
{
System.Drawing.Image img = System.Drawing.Image.FromFile(strTempPath);
ratio = (double)img.Width / (img.Height == 0 ? 1 : img.Height);
img.Dispose();
}
else
{
SwfParser swfParser = new SwfParser();
Rectangle rectangle = swfParser.GetDimensions(strTempPath);
ratio = (double)rectangle.Width / (rectangle.Height == 0 ? 1 : rectangle.Height);
}
string[] files = Directory.GetFiles(Server.MapPath(FileFileName.TargetFolder));
foreach (string filePath in files)
{
File.Delete(filePath);
}
}
var oAdsBanner = new AdsBanner();
if (e.CommandName == "PerformInsert")
{
strFileName = oAdsBanner.AdsBannerInsert(
strFileName,
strConvertedAdsBannerName,
strAdsCategoryID,
strCompanyName,
strWebsite,
strFromDate,
strToDate,
strPriority,
strIsAvailable,
ratio == 0 ? "" : ratio.ToString().Replace(',', '.')
);
string strFullPath = "~/res/advertisement/" + strFileName;
if (!string.IsNullOrEmpty(strFileName))
{
FileFileName.UploadedFiles[0].SaveAs(Server.MapPath(strFullPath));
if (IsImageFormat(strFileName))
{
//ResizeCropImage.ResizeByCondition(strFullPath, 800, 800);
}
}
RadGrid1.Rebind();
}
else
{
var dsUpdateParam = ObjectDataSource1.UpdateParameters;
var strAdsBannerID = row.GetDataKeyValue("AdsBannerID").ToString();
var strOldFileName = ((HiddenField)row.FindControl("hdnFileName")).Value;
var strOldImagePath = Server.MapPath("~/res/advertisement/" + strOldFileName);
dsUpdateParam["FileName"].DefaultValue = strFileName;
dsUpdateParam["ConvertedAdsBannerName"].DefaultValue = strConvertedAdsBannerName;
dsUpdateParam["AdsCategoryID"].DefaultValue = strAdsCategoryID;
dsUpdateParam["FromDate"].DefaultValue = strFromDate;
dsUpdateParam["ToDate"].DefaultValue = strToDate;
dsUpdateParam["IsAvailable"].DefaultValue = strIsAvailable;
dsUpdateParam["Ratio"].DefaultValue = ratio == 0 ? "" : ratio.ToString().Replace(',', '.');
if (!string.IsNullOrEmpty(strFileName))
{
var strFullPath = "~/res/advertisement/" + (string.IsNullOrEmpty(strConvertedAdsBannerName) ? "" : strConvertedAdsBannerName + "-") + strAdsBannerID + strFileName.Substring(strFileName.LastIndexOf('.'));
if (File.Exists(strOldImagePath))
{
File.Delete(strOldImagePath);
}
FileFileName.UploadedFiles[0].SaveAs(Server.MapPath(strFullPath));
if (IsImageFormat(strFileName))
{
//ResizeCropImage.ResizeByCondition(strFullPath, 654, 654);
}
}
}
}
if (e.CommandName == "DeleteImage")
{
var oAdsBanner = new AdsBanner();
var lnkDeleteImage = (LinkButton)e.CommandSource;
var s = lnkDeleteImage.Attributes["rel"].ToString().Split('#');
var strAdsBannerID = s[0];
var strFileName = s[1];
oAdsBanner.AdsBannerDelete(strAdsBannerID);
DeleteImage(strFileName);
RadGrid1.Rebind();
}
}
protected void radgridDevice_UpdateCommand(object sender, GridCommandEventArgs e)
{
GridEditableItem updatedItem = (GridEditableItem)e.Item;
if (e.Item.OwnerTableView.Name == "Service")
{
string s = e.Item.OwnerTableView.DataKeyValues[e.Item.ItemIndex]["ID"].ToString();
dsService.UpdateParameters.Add(new Parameter("ID", DbType.Int32, s));
dsService.UpdateParameters.Add(new Parameter("ServiceTypeID", DbType.Int32, (updatedItem["ServiceType"].Controls[0] as RadComboBox).SelectedValue));
dsService.UpdateParameters.Add(new Parameter("dateIn", DbType.DateTime, (updatedItem["DateInService"].Controls[0] as RadDatePicker).SelectedDate.ToString()));
dsService.Update();
radWM.RadAlert("Тип обслуживания был успешно обновлен.", 300, 200, "", "123");
}
if (e.Item.OwnerTableView.Name == "Device")
{
string s = e.Item.OwnerTableView.DataKeyValues[e.Item.ItemIndex]["ID"].ToString();
dsDevices.UpdateParameters.Add(new Parameter("ID", DbType.Int32, s));
dsDevices.UpdateParameters.Add(new Parameter("fn", DbType.String, (updatedItem["FN"].Controls[0] as TextBox).Text));
dsDevices.UpdateParameters.Add(new Parameter("title", DbType.String, (updatedItem["Title"].Controls[0] as TextBox).Text));
dsDevices.UpdateParameters.Add(new Parameter("description", DbType.String, (updatedItem["Description"].Controls[0] as TextBox).Text));
dsDevices.UpdateParameters.Add(new Parameter("typeid", DbType.Int32, (updatedItem["DeviceType"].Controls[0] as RadComboBox).SelectedValue));
dsDevices.Update();
radWM.RadAlert("Устройство было успешно обновлено.", 300, 200, "", "123");
}
if (e.Item.OwnerTableView.Name == "Event")
{
Entities.User u = GetCurrentUser();
string s = e.Item.OwnerTableView.DataKeyValues[e.Item.ItemIndex]["ID"].ToString();
dsEvents.UpdateParameters["ID"].DefaultValue = s;
dsEvents.UpdateParameters["WPTypeEventID"].DefaultValue = (updatedItem["EventType"].Controls[0] as RadComboBox).SelectedValue;
dsEvents.UpdateParameters["WPEventSourceTypeID"].DefaultValue = (updatedItem["EventSource"].Controls[0] as RadComboBox).SelectedValue;
dsEvents.UpdateParameters["DateIn"].DefaultValue = (updatedItem["DateInService"].Controls[0] as RadDatePicker).SelectedDate.ToString();
dsEvents.UpdateParameters["UserID"].DefaultValue = u.ID.ToString();
dsEvents.Update();
e.Item.Edit = false;
radWM.RadAlert("Выезд был успешно обновлен.", 300, 200, "", "123");
//radgrid.Rebind();
}
if (e.Item.OwnerTableView.Name == "WP")
{
string s = e.Item.OwnerTableView.DataKeyValues[e.Item.ItemIndex]["ID"].ToString();
dsWP.UpdateParameters.Add("ID", DbType.Int32, s);
dsWP.UpdateParameters.Add("LocationID", DbType.Int32, (updatedItem["WPLocation"].Controls[0] as RadComboBox).SelectedValue);
dsWP.UpdateParameters.Add("Title", DbType.String, (updatedItem["Title"].Controls[0] as TextBox).Text);
dsWP.UpdateParameters.Add("LF", DbType.Double, (updatedItem["LineFirst"].Controls[0] as TextBox).Text);
dsWP.UpdateParameters.Add("LS", DbType.Double, (updatedItem["LineSecond"].Controls[0] as TextBox).Text);
dsWP.UpdateParameters.Add("D", DbType.Int32, (updatedItem["D"].Controls[0] as TextBox).Text);
dsWP.UpdateParameters.Add("DCalc", DbType.Int32, (updatedItem["DCalc"].Controls[0] as TextBox).Text);
dsWP.UpdateParameters.Add("Qmin", DbType.Int32, (updatedItem["QMin"].Controls[0] as TextBox).Text);
dsWP.UpdateParameters.Add("Qmax", DbType.Int32, (updatedItem["QMax"].Controls[0] as TextBox).Text);
dsWP.UpdateParameters.Add("Comment", DbType.String, (updatedItem["Comment"].Controls[0] as TextBox).Text);
dsWP.UpdateParameters.Add("TypeID", DbType.Int32, (updatedItem["WPType"].Controls[0] as RadComboBox).SelectedValue);
dsWP.UpdateParameters.Add("StartDate", DbType.DateTime, (updatedItem["StartDate"].Controls[0] as RadDatePicker).SelectedDate.ToString());
dsWP.Update();
radgrid.Rebind();
radWM.RadAlert("Водовод был успешно обновлён.", 300, 200, "", "123");
}
e.Canceled = false;
//radgrid.Rebind();
}
// clear form input controls for insert/update
// grid export functions
protected void gvEmployee_ItemCommand(object sender, GridCommandEventArgs e)
{
RadGrid grid = (sender as RadGrid);
if (e.CommandName == RadGrid.InitInsertCommandName)
{
grid.MasterTableView.ClearEditItems();
}
if (e.CommandName == RadGrid.EditCommandName)
{
e.Item.OwnerTableView.IsItemInserted = false;
}
if (e.CommandName == RadGrid.RebindGridCommandName)
{
grid.MasterTableView.ClearEditItems();
e.Item.OwnerTableView.IsItemInserted = false;
if (htSearchParams != null)
{
htSearchParams.Clear();
}
}
if (e.CommandName == RadGrid.ExportToExcelCommandName)
{
exporting = true;
grid.GridLines = GridLines.Both;
grid.BorderStyle = BorderStyle.Solid;
grid.BorderWidth = Unit.Pixel(1);
grid.ExportSettings.HideStructureColumns = true;
grid.ExportSettings.FileName = "noDetailTable";
grid.ExportSettings.IgnorePaging = true;
grid.ExportSettings.ExportOnlyData = true;
grid.ExportSettings.OpenInNewWindow = true;
grid.MasterTableView.UseAllDataFields = true;
grid.ExportSettings.Excel.Format = GridExcelExportFormat.Xlsx;
foreach (GridDataItem item in grid.Items)
{
item["ExpandColumn"].Visible = false;
}
//have the nested tables render only when the user expands them via the UI, so they are not present in the export output
grid.MasterTableView.HierarchyLoadMode = GridChildLoadMode.ServerOnDemand;
grid.MasterTableView.DetailTables[0].HierarchyLoadMode = GridChildLoadMode.ServerOnDemand;
if (e.Item.OwnerTableView.DataMember == "EmployeeMaster")
{
grid.MasterTableView.GetColumn("ExpType").Visible = false;
grid.MasterTableView.GetColumn("defval").Visible = false;
grid.MasterTableView.GetColumn("EditEmployee").Visible = false;
grid.MasterTableView.GetColumn("DeleteEmployee").Visible = false;
int NofCols = (e.Item.OwnerTableView.Columns.Count) - 5;
Session["_NOfColumns"] = NofCols;
}
else if (e.Item.OwnerTableView.DataMember == "EmpExpTypeDetail")
{
e.Item.OwnerTableView.GetColumn("EditExpenseType").Visible = false;
e.Item.OwnerTableView.GetColumn("DeleteExpenseType").Visible = false;
e.Item.OwnerTableView.GetColumn("ExpSubType").Visible = false;
int NofCols = (e.Item.OwnerTableView.Columns.Count) - 3;
Session["_NOfColumns"] = NofCols;
}
else if (e.Item.OwnerTableView.DataMember == "EmpExpSubTypeDetail")
{
e.Item.OwnerTableView.GetColumn("DeleteExpenseSubType").Visible = false;
int NofCols = (e.Item.OwnerTableView.Columns.Count) - 2;
Session["_NOfColumns"] = NofCols;
}
grid.MasterTableView.ExportToExcel();
//grid.GridLines = GridLines.Both;
//grid.BorderStyle = BorderStyle.Solid;
//grid.BorderWidth = Unit.Pixel(1);
//grid.ExportSettings.ExportOnlyData = true;
//grid.ExportSettings.HideStructureColumns = true;
//grid.MasterTableView.HierarchyLoadMode = GridChildLoadMode.ServerOnDemand;
//grid.MasterTableView.DetailTables[0].HierarchyLoadMode = GridChildLoadMode.ServerOnDemand;
//foreach (GridDataItem item in grid.Items)
//{
// item["ExpandColumn"].Visible = false;
//}
//if (e.Item.OwnerTableView.DataMember == "EmployeeMaster")
//{
// grid.MasterTableView.GetColumn("ExpType").Visible = false;
// grid.MasterTableView.GetColumn("defval").Visible = false;
// grid.MasterTableView.GetColumn("EditEmployee").Visible = false;
// grid.MasterTableView.GetColumn("DeleteEmployee").Visible = false;
// grid.MasterTableView.ExportToExcel();
//}
//else if (e.Item.OwnerTableView.DataMember == "EmpExpTypeDetail")
//{
// GridTableHierarchySetEditability(grid.MasterTableView, true);
// grid.MasterTableView.ExportToExcel();
//}
//else if (e.Item.OwnerTableView.DataMember == "EmpExpSubTypeDetail")
//{
// GridTableHierarchySetEditability(grid.MasterTableView, true);
// grid.MasterTableView.ExportToExcel();
//}
}
if (e.CommandName == RadGrid.ExportToCsvCommandName)
{
exporting = true;
grid.GridLines = GridLines.Both;
grid.BorderStyle = BorderStyle.Solid;
grid.BorderWidth = Unit.Pixel(1);
grid.ExportSettings.ExportOnlyData = false;
grid.MasterTableView.EnableHierarchyExpandAll = false;
foreach (GridDataItem item in grid.Items)
{
item["ExpandColumn"].Visible = false;
}
if (e.Item.OwnerTableView.DataMember == "EmployeeMaster")
{
grid.MasterTableView.GetColumn("ExpType").Visible = false;
grid.MasterTableView.GetColumn("defval").Visible = false;
grid.MasterTableView.GetColumn("EditEmployee").Visible = false;
grid.MasterTableView.GetColumn("DeleteEmployee").Visible = false;
}
else if (e.Item.OwnerTableView.DataMember == "EmpExpTypeDetail")
{
GridTableHierarchySetEditability(grid.MasterTableView, true);
}
else if (e.Item.OwnerTableView.DataMember == "EmpExpSubTypeDetail")
{
GridTableHierarchySetEditability(grid.MasterTableView, true);
}
grid.MasterTableView.ExportToCSV();
}
if (e.CommandName == RadGrid.ExportToPdfCommandName)
{
exporting = true;
grid.GridLines = GridLines.Both;
grid.BorderStyle = BorderStyle.Solid;
grid.BorderWidth = Unit.Pixel(1);
foreach (GridDataItem item in grid.Items)
{
item["ExpandColumn"].Visible = false;
}
if (e.Item.OwnerTableView.DataMember == "EmployeeMaster")
{
grid.MasterTableView.GetColumn("ExpType").Visible = false;
grid.MasterTableView.GetColumn("defval").Visible = false;
grid.MasterTableView.GetColumn("EditEmployee").Visible = false;
grid.MasterTableView.GetColumn("DeleteEmployee").Visible = false;
}
else if (e.Item.OwnerTableView.DataMember == "EmpExpTypeDetail")
{
GridTableHierarchySetEditability(grid.MasterTableView, true);
}
else if (e.Item.OwnerTableView.DataMember == "EmpExpSubTypeDetail")
{
GridTableHierarchySetEditability(grid.MasterTableView, true);
}
grid.MasterTableView.ExportToPdf();
}
if (e.CommandName == "Print")
{
Button btnPrint = (Button)e.Item.FindControl("btnOvertimePrint");
RadComboBox ddlPrintOptions = (RadComboBox)e.Item.FindControl("ddlPrintOptions");
if (ddlPrintOptions != null)
{
if (!string.IsNullOrEmpty(ddlPrintOptions.Text))
{
String qstring = clsEncryption.EncryptData(ddlPrintOptions.Text);
//btnPrint.Attributes["onclick"] = String.Format("return ShowReport('{0}');", qstring);
ScriptManager.RegisterStartupScript(this, Page.GetType(), "mykey", "ShowReport('" + qstring + "');", true);
}
}
}
}
protected void GrabarActualizar(object sender, GridCommandEventArgs e, String action)
{
var editableItem = ((GridEditableItem)e.Item);
//create new entity
//populate its properties
Hashtable values = new Hashtable();
editableItem.ExtractValues(values);
RadComboBox oRadComboBox1 = (RadComboBox)e.Item.FindControl("rcbEmpresa");
RadComboBox oRadComboBox2 = (RadComboBox)e.Item.FindControl("rcbGerencia");
RadComboBox oRadComboBox3 = (RadComboBox)e.Item.FindControl("rcbArea");
RadComboBox oRadComboBox_Coordinacion = (RadComboBox)e.Item.FindControl("rcbCoordinacion");
RadComboBox oRadComboBox_Sede = (RadComboBox)e.Item.FindControl("rcbSede");
RadComboBox oRadComboBox_GrupoOrganizacional = (RadComboBox)e.Item.FindControl("rcbGrupoOrganizacional");
RadComboBox oRadComboBox_Puesto = (RadComboBox)e.Item.FindControl("rcbPuesto");
RadComboBox oRadComboBox4 = (RadComboBox)e.Item.FindControl("rcbPerfiles");
BE_PERSONAL oentidad = new BE_PERSONAL();
BL_PERSONAL BL_PERSONAL = new BL_PERSONAL();
Nullable <Guid> ID;
if (e.CommandName == RadGrid.PerformInsertCommandName)
{
ID = Guid.Empty;
}
else
{
ID = Guid.Parse(editableItem.GetDataKeyValue("ID").ToString());
}
oentidad.ID = (Guid)ID;
oentidad.CODIGO_TRABAJO = values["CODIGO_TRABAJO"].ToString();
oentidad.NOMBRES = values["NOMBRES"].ToString();
oentidad.APELLIDO_PATERNO = values["APELLIDO_PATERNO"].ToString();
oentidad.APELLIDO_MATERNO = values["APELLIDO_MATERNO"].ToString();
oentidad.CORREO = values["CORREO"].ToString();
oentidad.NOMBRE_USUARIO = values["NOMBRE_USUARIO"].ToString();
if (!String.IsNullOrEmpty(oRadComboBox1.SelectedValue))
{
oentidad.EMPRESA_ID = Guid.Parse(oRadComboBox1.SelectedValue);
}
else
{
e.Canceled = true;
oRadComboBox1.Text = String.Empty;
return;
}
if (!String.IsNullOrEmpty(oRadComboBox_Sede.SelectedValue))
{
oentidad.SEDE_ID = Guid.Parse(oRadComboBox_Sede.SelectedValue);
}
else
{
e.Canceled = true;
oRadComboBox_Sede.Text = String.Empty;
return;
}
if (!String.IsNullOrEmpty(oRadComboBox2.SelectedValue))
{
oentidad.GERENCIA_ID = Guid.Parse(oRadComboBox2.SelectedValue);
}
else
{
e.Canceled = true;
oRadComboBox2.Text = String.Empty;
return;
}
if (!String.IsNullOrEmpty(oRadComboBox4.SelectedValue))
{
oentidad.PERFIL_ID = Int32.Parse(oRadComboBox4.SelectedValue);
}
else
{
oRadComboBox4.Text = String.Empty;
}
if (!String.IsNullOrEmpty(oRadComboBox3.SelectedValue))
{
oentidad.AREA_ID = Guid.Parse(oRadComboBox3.SelectedValue);
}
else
{
e.Canceled = true;
oRadComboBox3.Text = String.Empty;
return;
}
if (!String.IsNullOrEmpty(oRadComboBox_Coordinacion.SelectedValue))
{
oentidad.COORDINACION_ID = Guid.Parse(oRadComboBox_Coordinacion.SelectedValue);
}
else
{
oRadComboBox_Coordinacion.Text = String.Empty;
}
if (!String.IsNullOrEmpty(oRadComboBox_Puesto.SelectedValue))
{
oentidad.PUESTO_ID = Guid.Parse(oRadComboBox_Puesto.SelectedValue);
}
else
{
e.Canceled = true;
oRadComboBox_Puesto.Text = String.Empty;
return;
}
if (!String.IsNullOrEmpty(oRadComboBox_GrupoOrganizacional.SelectedValue))
{
oentidad.GRUPO_ORGANIZACIONAL_ID = Guid.Parse(oRadComboBox_GrupoOrganizacional.SelectedValue);
}
else
{
e.Canceled = true;
oRadComboBox_GrupoOrganizacional.Text = String.Empty;
return;
}
if (action == "add")
{
oentidad.USUARIO_CREACION = USUARIO;
oentidad.ESTADO = 1;
BL_PERSONAL.InsertarPersonal(oentidad);
rgPersonal.Rebind();
}
else
{
oentidad.USUARIO_CREACION = USUARIO;
oentidad.ESTADO = 1;
BL_PERSONAL.ActualizarPersonal(oentidad);
rgPersonal.Rebind();
}
}
// grid insert command
protected void gvEmployee_InsertCommand(object sender, GridCommandEventArgs e)
{
Insert_or_Update_EmpExpAssignment(ref e, "Insert");
}
// insert/update function
private void Insert_or_Update_EmpExpAssignment(ref GridCommandEventArgs e, string operation)
{
GridEditableItem editedItem = e.Item as GridEditableItem;
try
{
if (e.Item.OwnerTableView.DataMember == "EmployeeMaster")
{
//Insert new values
Hashtable newValues = new Hashtable();
newValues["@empidd"] = Convert.ToInt32(editedItem.GetDataKeyValue("recidd"));
newValues["@empcod"] = Convert.ToInt32(editedItem.GetDataKeyValue("empcod"));
newValues["@empfsn"] = editedItem.GetDataKeyValue("empfsn");
newValues["@defval"] = (editedItem.FindControl("cbDefVal") as CheckBox).Checked;
RadComboBox ddlExpenseType = (editedItem.FindControl("ddlExpenseType") as RadComboBox);
if (ddlExpenseType != null)
{
if (ddlExpenseType.Items.Count > 0)
{
Hashtable ht = new Hashtable();
ht.Add("@ID", editedItem.GetDataKeyValue("recidd").ToString());
DataTable dtET = clsDAL.GetDataSet_Payroll("sp_Payroll_Get_EmpExpenseTypeAssignment_Records", ht).Tables[0];
RadGrid rgExp = (ddlExpenseType.Items[0].FindControl("rGrdExpenseType4DDL") as RadGrid);
if (rgExp.SelectedItems.Count > 0)
{
foreach (GridDataItem dataItem in rgExp.SelectedItems)
{
bool match = false;
for (int i = dtET.Rows.Count - 1; i >= 0; i--)
{
DataRow row = dtET.Rows[i];
if (row["exptidd"].ToString() == dataItem.OwnerTableView.DataKeyValues[dataItem.ItemIndex]["exptidd"].ToString())
{
match = true;
dtET.Rows.Remove(row);
}
}
if (match == false)
{
newValues["@exptidd"] = Convert.ToInt32(dataItem.OwnerTableView.DataKeyValues[dataItem.ItemIndex]["exptidd"].ToString());
newValues["@DBMessage"] = "";
string DBMessage = "";
DBMessage = clsDAL.ExecuteNonQuery_payroll("sp_Payroll_Insert_EmployeeExpenseTypeAssignment_Record", newValues, "@DBMessage", System.Data.SqlDbType.NVarChar, 255).ToString();
if ((null != DBMessage) && DBMessage.Contains("ERROR:"))
{
ShowClientMessage(DBMessage, MessageType.Error);
e.Canceled = true;
}
}
}
for (int i = dtET.Rows.Count - 1; i >= 0; i--)
{
Hashtable htValues = new Hashtable();
DataRow row = dtET.Rows[i];
htValues.Add("@exptidd", Convert.ToInt32(row["exptidd"].ToString()));
htValues.Add("@empidd", Convert.ToInt32(editedItem.GetDataKeyValue("recidd")));
clsDAL.ExecuteNonQuery_payroll("sp_Payroll_Delete_EmployeeExpenseAssignment_recordDetail", htValues);
}
}
}
}
ShowClientMessage("Employee expense assignment record saved successfully.", MessageType.Success);
//gvEmployee.Rebind();
}
if (e.Item.OwnerTableView.DataMember == "EmpExpTypeDetail")
{
//Insert new values
Hashtable newValues = new Hashtable();
newValues["@empidd"] = Convert.ToInt32(editedItem.GetDataKeyValue("empidd"));
newValues["@exptidd"] = Convert.ToInt32(editedItem.GetDataKeyValue("exptidd"));
GridDataItem ParentItem = e.Item.OwnerTableView.ParentItem as GridDataItem;
newValues["@empcod"] = ParentItem.GetDataKeyValue("empcod");
newValues["@empfsn"] = ParentItem.GetDataKeyValue("empfsn");
RadComboBox ddlExpenseSubType = (editedItem.FindControl("ddlExpenseSubType") as RadComboBox);
if (ddlExpenseSubType != null)
{
if (ddlExpenseSubType.Items.Count > 0)
{
#region delete old records
Hashtable ht = new Hashtable();
ht.Add("@empidd", Convert.ToInt32(editedItem.GetDataKeyValue("empidd")));
ht.Add("@exptidd", Convert.ToInt32(editedItem.GetDataKeyValue("exptidd")));
clsDAL.ExecuteNonQuery_payroll("sp_Payroll_Delete_EmployeeExpenseAssignment_recordDetail", ht);
#endregion
RadGrid rgEmployee = (ddlExpenseSubType.Items[0].FindControl("rGrdExpenseSubType4DDL") as RadGrid);
if (rgEmployee.SelectedItems.Count > 0)
{
foreach (GridDataItem dataItem in rgEmployee.SelectedItems)
{
newValues["@expsubtidd"] = Convert.ToInt32(dataItem.OwnerTableView.DataKeyValues[dataItem.ItemIndex]["expsubtidd"].ToString());
newValues["@expsubtcod"] = dataItem.OwnerTableView.DataKeyValues[dataItem.ItemIndex]["expsubtcod"].ToString();
newValues["@DBMessage"] = "";
string DBMessage = "";
DBMessage = clsDAL.ExecuteNonQuery_payroll("sp_Payroll_Insert_EmployeeExpenseSubTypeAssignment_Record", newValues, "@DBMessage", System.Data.SqlDbType.NVarChar, 255).ToString();
if ((null != DBMessage) && DBMessage.Contains("ERROR:"))
{
ShowClientMessage(DBMessage, MessageType.Error);
e.Canceled = true;
}
}
}
}
}
ShowClientMessage("Employee expense assignment record saved successfully.", MessageType.Success);
//gvEmployee.Rebind();
}
}
catch (Exception ex)
{
ShowClientMessage("Unable to save employee expense assignment record. Reason: " + ex.Message, MessageType.Error);
e.Canceled = true;
}
}
protected void grdRequest_ItemCommand(object sender, GridCommandEventArgs e)
{
try
{
if (e.CommandName == "Select")
{
GridDataItem dataitem = e.Item as GridDataItem;
DataTable dtcon = CM_Main.SelectJob("CASE11", dataitem["REQUEST_ID"].Text, "", "", "", "", System.DateTime.Now);
grdRequest.DataSource = dtcon;
grdRequest.DataBind();
BtnUpdate.Enabled = true;
BtnReject.Enabled = true;
txtReqID.Text = dtcon.Rows[0]["REQUEST_ID"].ToString();
lblCompany.Text = dtcon.Rows[0]["COMPANY"].ToString();
lblStatus.Text = dtcon.Rows[0]["STATUS"].ToString();
lblTitle.Text = dtcon.Rows[0]["TITLE"].ToString();
lblSystem.Text = dtcon.Rows[0]["SYSTEM"].ToString();
lblDescription.Text = dtcon.Rows[0]["DESCRIPTION"].ToString();
lblRequestUser.Text = dtcon.Rows[0]["RU_FULLNAME"].ToString();
lblManager.Text = dtcon.Rows[0]["MAN_FULLNAME"].ToString();
lblImplement.Text = dtcon.Rows[0]["IMP_FULLNAME"].ToString();
lblQA.Text = dtcon.Rows[0]["QA_FULLNAME"].ToString();
lblRelease.Text = dtcon.Rows[0]["RE_FULLNAME"].ToString();
lblRejectRea.Text = dtcon.Rows[0]["REJECT_COMMENT"].ToString();
lblImpact.Text = dtcon.Rows[0]["IMPACT"].ToString();
lblOutage.Text = dtcon.Rows[0]["OUTAGE"].ToString();
lblFallBack.Text = dtcon.Rows[0]["FEEDBACK_PLAN"].ToString();
lblParent.Text = dtcon.Rows[0]["PARENT_ID"].ToString();
lblCreation.Text = dtcon.Rows[0]["REQUEST_DATE"].ToString();
lblStart.Text = dtcon.Rows[0]["START_DATE"].ToString();
lblEnd.Text = dtcon.Rows[0]["END_DATE"].ToString();
lblLastUpdate.Text = dtcon.Rows[0]["LAST_UPDATE_DATE"].ToString();
lblAssign.Text = dtcon.Rows[0]["ASSIGN_DATE"].ToString();
RdGrdEvents.DataSource = CM_Main.SelectJob("CASE10", dataitem["REQUEST_ID"].Text, "", "", "", "", System.DateTime.Now);
RdGrdEvents.DataBind();
DataTable dtDocsJobWise = CM_Main.SelectJob("CASE13", txtReqID.Text, "", "", "", "", System.DateTime.Now);
if (dtDocsJobWise.Rows.Count >= 1)
{
RadListBox2.DataSource = dtDocsJobWise;
RadListBox2.DataTextField = "DOCUMENT";
RadListBox2.DataValueField = "DOCUMENT";
RadListBox2.DataBind();
}
DataTable dt = Main.SelectImages(dtcon.Rows[0]["IT_REQUEST_ID"].ToString(), "BRANCH_IMAGE");
galleryDataList.DataSource = dt;
galleryDataList.DataBind();
DataTable dt33 = Main.SelectImages(dtcon.Rows[0]["IT_REQUEST_ID"].ToString(), "BRANCH_DOCS");
DataList2.DataSource = dt33;
DataList2.DataBind();
DataTable dtEvents = Main.SelectJobFromRegister("CASE16", dtcon.Rows[0]["IT_REQUEST_ID"].ToString(), "", "", System.DateTime.Now);
RadGrdEventsITWF.DataSource = dtEvents;
RadGrdEventsITWF.DataBind();
}
}
catch (Exception ex)
{
lblError.Text = ex.Message;
lblError.Visible = true;
return;
}
}
protected void RadGrid1_UpdateCommand(object source, GridCommandEventArgs e)
{
try
{
GridEditableItem editedItem = e.Item as GridEditableItem;
GridEditManager editMan = editedItem.EditManager;
int i = 2;
dt = (DataTable)Session[SessionContents.FPS_AddProspect_DataTable];
dr = dt.NewRow();
foreach (GridColumn column in e.Item.OwnerTableView.RenderColumns)
{
if (column is IGridEditableColumn)
{
IGridEditableColumn editableCol = (column as IGridEditableColumn);
if (editableCol.IsEditable)
{
IGridColumnEditor editor = editMan.GetColumnEditor(editableCol);
string editorType = editor.ToString();
string editorText = "unknown";
object editorValue = null;
if (editor is GridTextColumnEditor)
{
editorText = (editor as GridTextColumnEditor).Text;
editorValue = (editor as GridTextColumnEditor).Text;
}
if (editor is GridBoolColumnEditor)
{
editorText = (editor as GridBoolColumnEditor).Value.ToString();
editorValue = (editor as GridBoolColumnEditor).Value;
}
if (editor is GridDropDownColumnEditor)
{
editorText = (editor as GridDropDownColumnEditor).SelectedValue;
editorValue = (editor as GridDropDownColumnEditor).SelectedValue;
}
if (editor is GridTemplateColumnEditor)
{
if (i != 3)
{
TextBox txt = (TextBox)e.Item.FindControl("txtIPName");
editorText = txt.Text;
editorValue = txt.Text;
}
else if (i == 3)
{
TextBox txt = (TextBox)e.Item.FindControl("txtIPComments");
editorText = txt.Text;
editorValue = txt.Text;
}
}
try
{
DataRow[] changedrows = dt.Select();
changedrows[editedItem.ItemIndex][column.UniqueName] = editorValue;
}
catch (Exception ex)
{
RadGrid1.Controls.Add(new LiteralControl("<strong>Unable to set value of column '" + column.UniqueName + "'</strong> - " + ex.Message));
e.Canceled = true;
break;
}
}
i++;
}
}
Session[SessionContents.FPS_AddProspect_DataTable] = dt;
Rebind(false);
}
catch (Exception ex)
{
e.Canceled = true;
throw ex;
}
}
