protected void grid_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
if (e.RowIndex < Page.Settings.SortedColumns.Count)
Page.Settings.SortedColumns.RemoveAt(e.RowIndex);
int reportColumnsSchemaId = Convert.ToInt32((grid.Rows[e.RowIndex].Cells[0].Controls[1] as DropDownList).SelectedValue);
bool asc = Convert.ToBoolean((grid.Rows[e.RowIndex].Cells[1].Controls[1] as DropDownList).SelectedValue);
// Verifies if yet inserted
ReportSort sortItem = Page.Settings.SortedColumns.Find(p => p.ReportColumnsSchemaId == reportColumnsSchemaId);
if (sortItem == null)
{
sortItem = new ReportSort();
sortItem.ReportTablesSchemaId = Page.Settings.Report.ReportTablesSchemaId.Value;
sortItem.ReportColumnsSchemaId = reportColumnsSchemaId;
sortItem.Ascending = asc;
sortItem.Name = (grid.Rows[e.RowIndex].Cells[0].Controls[1] as DropDownList).SelectedItem.Text;
Page.Settings.SortedColumns.Insert(e.RowIndex, sortItem);
}
else
{
sortItem.Ascending = asc;
}
BindGrid(-1);
}
public void GridViewNews_RowUpdating(Object sender, GridViewUpdateEventArgs e)
{
int index = GridViewNews.EditIndex;
GridViewRow row = GridViewNews.Rows[index];
TextBox description = (TextBox)row.FindControl("TextBoxDescription");
e.NewValues["description"] = description.Text;
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
TextBox my_RealQuantity;
String my_MaterialID = gv.DataKeys[e.RowIndex].Value.ToString();
String my_MaterialName = gv.Rows[e.RowIndex].Cells[2].Text;
String my_SystemQuantity = gv.Rows[e.RowIndex].Cells[3].Text;
my_RealQuantity = (TextBox)gv.Rows[e.RowIndex].Cells[4].Controls[0];
String my_MaterialCost = gv.Rows[e.RowIndex].Cells[5].Text;
if (!IsNumeric(my_RealQuantity.Text))
{
ShowMsg2(UpdatePanel1, "請輸入數字");
return;
}
//檢查更新是否成功
if (UpdateICS_Material(my_MaterialID, my_MaterialName, my_SystemQuantity, my_RealQuantity, my_MaterialCost))
{
ShowMsg2(UpdatePanel1, "更新成功");
}
else
{
ShowMsg2(UpdatePanel1, "更新失敗");
}
gv.EditIndex = -1;
InitData();
SearchData();
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
string sno = (GridView1.Rows[e.RowIndex].Cells[3].Controls[0] as TextBox).Text;
string sname = (GridView1.Rows[e.RowIndex].Cells[4].Controls[0] as TextBox).Text;
string ssex = (GridView1.Rows[e.RowIndex].Cells[5].Controls[0] as TextBox).Text;
string sage = (GridView1.Rows[e.RowIndex].Cells[6].Controls[0] as TextBox).Text;
string sdept = (GridView1.Rows[e.RowIndex].Cells[7].Controls[0] as TextBox).Text;
using (
SqlConnection connection =
new SqlConnection(connectionString))
{
string commanText =
string.Format("UPDATE Student SET Sname = '{0}', Ssex = '{1}', Sage = '{2}', Sdept = '{3}' WHERE Sno = '{4}'", sname,
ssex, sage, sdept, sno);
var command = new SqlCommand(commanText, connection);
if (connection.State != ConnectionState.Open)
{
connection.Open();
}
command.ExecuteNonQuery();
GridView1.EditIndex = -1;
BindGridView();
}
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
int _selectedRowIndex = e.RowIndex;
// HiddenField hidden = (HiddenField)
int projID = (int)GridView1.DataKeys[_selectedRowIndex].Values[2];
int rowIndex = GridView1.SelectedIndex;
// int projID = Convert.ToInt32( GridView1.DataKeys[rowIndex].Values[2]);
// int projID = 4;
TextBox txtForMark = (TextBox)(GridView1.Rows[e.RowIndex].FindControl("theMarkTextBox"));
string newMark = txtForMark.Text.ToString();
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
try
{
// con.Open();
string upDate = "UPDATE StudentsProjects SET mark=" + newMark + " WHERE projectID=" + projID + " ";
// SqlCommand updateCommand = new SqlCommand(upDate, con);
// updateCommand.CommandType = CommandType.Text;
// updateCommand.ExecuteNonQuery();
// con.Close();
// SqlDataSource1.Update();
SqlDataSource1.UpdateCommand = upDate;
// GridView1.DataSource = SqlDataSource1;
// GridView1.DataBind();
}
catch { }
//SqlDataSource1.Update();
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
obj = (ObjectDataSource)Session["obj"];
obj.UpdateMethod = "UpdateStudent";
obj.UpdateParameters.Clear();
Label id = (Label)GridView1.Rows[e.RowIndex].FindControl("EditID");
TextBox F_name = (TextBox)GridView1.Rows[e.RowIndex].FindControl("Edit_F_Name");
TextBox L_Name = (TextBox)GridView1.Rows[e.RowIndex].FindControl("Edit_L_Name");
TextBox Address = (TextBox)GridView1.Rows[e.RowIndex].FindControl("Edit_Address");
TextBox Age = (TextBox)GridView1.Rows[e.RowIndex].FindControl("Edit_Age");
DropDownList Dept = (DropDownList)GridView1.Rows[e.RowIndex].FindControl("Edit_Dept");
DropDownList Leader = (DropDownList)GridView1.Rows[e.RowIndex].FindControl("Edit_Leader");
TextBox password = (TextBox)GridView1.Rows[e.RowIndex].FindControl("Edit_Password");
TextBox UserName = (TextBox)GridView1.Rows[e.RowIndex].FindControl("Edit_UserName");
obj.UpdateParameters.Add("St_ID", id.Text);
obj.UpdateParameters.Add("F_Name", F_name.Text);
obj.UpdateParameters.Add("L_Name", L_Name.Text);
obj.UpdateParameters.Add("Address", Address.Text);
obj.UpdateParameters.Add("Age", Age.Text);
obj.UpdateParameters.Add("Dept_No", Dept.SelectedValue);
obj.UpdateParameters.Add("Leader", Leader.SelectedValue);
obj.UpdateParameters.Add("password", password.Text);
obj.UpdateParameters.Add("UserName", UserName.Text);
obj.Update();
GridView1.EditIndex = -1;
GridView1.DataSource = obj;
GridView1.DataBind();
Session["obj"] = obj;
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
var List = new List<Student_Registration_Form>();
var db = new DataClassesDataContext();
string _accountType, _email, _contactMethod, _campus, _faculty, _course;
int _phone, _mobile;
_accountType = ((TextBox) (GridView1.Rows[e.RowIndex].FindControl("textAccType"))).Text;
_email = ((TextBox) (GridView1.Rows[e.RowIndex].FindControl("textEmail"))).Text;
//_citizenship = ((TextBox)(GridView1.Rows[e.RowIndex].FindControl("Marital_Status"))).Text;
_contactMethod = ((TextBox) (GridView1.Rows[e.RowIndex].FindControl("textContact"))).Text;
_campus = ((TextBox) (GridView1.Rows[e.RowIndex].FindControl("textCampus"))).Text;
_faculty = ((TextBox) (GridView1.Rows[e.RowIndex].FindControl("textFaculty"))).Text;
_course = ((TextBox) (GridView1.Rows[e.RowIndex].FindControl("textCourse"))).Text;
//_phone = ((TextBox)(GridView1.Rows[e.RowIndex].FindControl.("textPhone"))).ToString();
//_mobile = ((TextBox)(GridView1.Rows[e.RowIndex].FindControl("textMobile"))).Text;
var update = (from u in db.Student_Registration_Forms
where u.Accomodition_Type == _accountType
where u.Email == _email
//where u.Marital_Status == _citizenship
where u.Contact == _contactMethod
where u.campus == _campus
where u.Faculty == _faculty
where u.Courses == _course
select u);
GridView1.DataSource = List;
db.SubmitChanges();
BindGrid();
}
protected void gvmon_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
mhdto.MaMon = gvmon.DataKeys[e.RowIndex].Value.ToString();
TextBox tx = (TextBox)gvmon.Rows[e.RowIndex].FindControl("txttenmon");
Label lb = (Label)gvto.Rows[e.RowIndex].FindControl("lblmamon");
string tenmon = sv.To_searchbyMa(lb.Text.ToString()).Rows[0]["Tên môn"].ToString();
if (sv.MonHoc_checkTrungtenmon(tx.Text.ToString()) == true && tx.Text.ToString() != tenmon)
{
Response.Write("<script>alert('Tên môn học này đã tồn tại !')</script>");
}
else
{
TextBox heso = (TextBox)gvmon.FooterRow.FindControl("txtheso");
mhdto.TenMon = tx.Text.ToString();
mhdto.HeSo = int.Parse(heso.Text.ToString());
gvmon.EditIndex = -1;
int result = mhbus.Update(mhdto);
if (result > 0)
{
Response.Write("<script>alert('Sửa thông tin thành công')</script>");
}
else
{
Response.Write("<script>alert('Sửa thất bại')</script>");
}
//Response.Redirect("QuanlyTo.aspx");
gvmon.DataSource = mhbus.List();
gvmon.DataBind();
}
}
protected void GrdLoadJobCompany_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
int indexrow = e.RowIndex;
string tid = ((Label)GrdLoadJobCompany.Rows[indexrow].FindControl("PostJobId")).Text;
Response.Redirect("~/ShowJobDetails.aspx?PostJobId=" + tid);
}
// Update a product
protected void grid_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
// Retrieve updated data
try
{
string id = grid.DataKeys[e.RowIndex].Value.ToString();
string name = ((TextBox)grid.Rows[e.RowIndex].FindControl("nameTextBox")).Text;
string description = ((TextBox)grid.Rows[e.RowIndex].FindControl("descriptionTextBox")).Text;
string price = ((TextBox)grid.Rows[e.RowIndex].FindControl("priceTextBox")).Text;
string thumbnail = ((TextBox)grid.Rows[e.RowIndex].FindControl("thumbTextBox")).Text;
string image = ((TextBox)grid.Rows[e.RowIndex].FindControl("imageTextBox")).Text;
string promoDept = ((CheckBox)grid.Rows[e.RowIndex].Cells[6].Controls[0]).Checked.ToString();
string promoFront = ((CheckBox)grid.Rows[e.RowIndex].Cells[7].Controls[0]).Checked.ToString();
// Execute the update command
bool success = CatalogAccess.UpdateProduct(id, name, description, price, thumbnail, image, promoDept, promoFront);
// Cancel edit mode
grid.EditIndex = -1;
// Display status message
statusLabel.Text = success ? "Product update successful" : "Product update failed";
}
catch
{
// Display error
statusLabel.Text = "Product update failed";
}
// Reload grid
BindGrid();
}
protected void gv_weddingCustomer_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
GridViewRow row = (GridViewRow)gv_weddingCustomer.Rows[e.RowIndex];
Label lblCustomerID = (Label)row.FindControl("lblid");
Label lblSalutation = (Label)row.FindControl("lblid1");
TextBox textFname = (TextBox)row.FindControl("textbox1");
TextBox textLname = (TextBox)row.FindControl("textbox2");
TextBox textstate_Address = (TextBox)row.FindControl("textbox3");
TextBox textCity = (TextBox)row.FindControl("textbox4");
TextBox textPostelCode = (TextBox)row.FindControl("textbox5");
TextBox textPhone = (TextBox)row.FindControl("textbox6");
TextBox textEmail = (TextBox)row.FindControl("textbox7");
TextBox textCountry = (TextBox)row.FindControl("textbox8");
TextBox textPassport_num = (TextBox)row.FindControl("textbox9");
gv_weddingCustomer.EditIndex = -1;
String customerUpdateQuery = "update Customer set fname = '" + textFname.Text + "',lname = '" + textLname.Text + "' where CustomerID = " + lblCustomerID.Text + " ";
bool updateResult = dc.insert(customerUpdateQuery);
lblUpdateMsg.Visible = true;
if (updateResult == true)
{
lblUpdateMsg.Text = "Details of Customer with ID '" + lblCustomerID.Text + "' was sucessly updated!";
}
else
{
lblUpdateMsg.Text = "Sorry!Unable to be update Details of Customer with ID '" + lblCustomerID.Text + "'!";
}
fillGrid();
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
//获取编辑状态下当前行中每一列的值
//当 GridView 中的某一行处于编辑状态时，可以看成是某个单元格中放置了一个 TextBox 控件
//所以需要得到这个 TextBox 控件，并获取其中的文本
string sno = (GridView1.Rows[e.RowIndex].Cells[3].Controls[0] as TextBox).Text;
string sname = (GridView1.Rows[e.RowIndex].Cells[4].Controls[0] as TextBox).Text;
string ssex = (GridView1.Rows[e.RowIndex].Cells[5].Controls[0] as TextBox).Text;
string sage = (GridView1.Rows[e.RowIndex].Cells[6].Controls[0] as TextBox).Text;
string sdept = (GridView1.Rows[e.RowIndex].Cells[7].Controls[0] as TextBox).Text;
//获取 DataSet 中与点击了 “编辑” 按钮的这行对应的数据行
DataRow row = dataSet.Tables[0].Rows[e.RowIndex];
//修改其中各字段的值
row["Sno"] = sno;
row["Sname"] = sname;
row["Ssex"] = ssex;
row["Sage"] = sage;
row["Sdept"] = sdept;
//提交到数据库中
dataAdapter.Update(dataSet);
GridView1.EditIndex = -1;
BindGridView();
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
int postid = 0;
string postcontent = "";
DateTime modified = DateTime.Now;
string poststatus = "";
int rating = 0;
postid = Convert.ToInt16(((Label)GridView1.Rows[e.RowIndex].FindControl("lblpostid")).Text);
postcontent = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txtPostContent")).Text;
poststatus = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txtstatus")).Text;
rating = Convert.ToInt16(((TextBox)GridView1.Rows[e.RowIndex].FindControl("txtrating")).Text);
PostBLL pb = new PostBLL();
int i= pb.UpdatePost(postid,postcontent,modified,poststatus,rating);
if (i == 1)
{
Response.Write("<script language='javascript'>alert('Post has been updated !');</script>");
GridView1.DataBind();
}
else
{
Response.Write("<script language='javascript'>alert('Post is failed to be updated !');</script>");
GridView1.DataBind();
}
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
string cname, c_add, city, desig, j_date, salary, c_per_name, c_per_no, sid;
cname = ((TextBox)(GridView1.Rows[e.RowIndex].FindControl("TextBox3"))).Text;
c_add = ((TextBox)(GridView1.Rows[e.RowIndex].FindControl("TextBox4"))).Text;
city = ((TextBox)(GridView1.Rows[e.RowIndex].FindControl("TextBox5"))).Text;
desig = ((TextBox)(GridView1.Rows[e.RowIndex].FindControl("TextBox6"))).Text;
j_date = ((TextBox)(GridView1.Rows[e.RowIndex].FindControl("TextBox7"))).Text;
salary = ((TextBox)(GridView1.Rows[e.RowIndex].FindControl("TextBox8"))).Text;
c_per_name = ((TextBox)(GridView1.Rows[e.RowIndex].FindControl("TextBox9"))).Text;
c_per_no = ((TextBox)(GridView1.Rows[e.RowIndex].FindControl("TextBox10"))).Text;
sid = GridView1.DataKeys[e.RowIndex].Value.ToString();
SqlDataSource5.UpdateParameters["cname"].DefaultValue = cname;
SqlDataSource5.UpdateParameters["c_add"].DefaultValue = c_add;
SqlDataSource5.UpdateParameters["city"].DefaultValue = city;
SqlDataSource5.UpdateParameters["desig"].DefaultValue = desig;
SqlDataSource5.UpdateParameters["j_date"].DefaultValue = j_date;
SqlDataSource5.UpdateParameters["salary"].DefaultValue = salary;
SqlDataSource5.UpdateParameters["c_per_name"].DefaultValue = c_per_name;
SqlDataSource5.UpdateParameters["c_per_no"].DefaultValue = c_per_no;
SqlDataSource5.UpdateParameters["sid"].DefaultValue = sid;
SqlDataSource5.Update();
GridView1.EditIndex = -1;
GridView1.DataBind();
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
TextBox my_MaterialName, my_PurchaseUnit, my_ConsumeUnit, my_ConversionFactor, my_MaterialSafeQuantity, my_MaterialTypeID, my_MaterialUnit, my_Active;
String my_NO = gv.DataKeys[e.RowIndex].Value.ToString();
my_MaterialName = (TextBox)gv.Rows[e.RowIndex].Cells[2].Controls[0];
my_PurchaseUnit = (TextBox)gv.Rows[e.RowIndex].Cells[3].Controls[0];
my_ConsumeUnit = (TextBox)gv.Rows[e.RowIndex].Cells[4].Controls[0];
my_ConversionFactor = (TextBox)gv.Rows[e.RowIndex].Cells[5].Controls[0];
my_MaterialSafeQuantity = (TextBox)gv.Rows[e.RowIndex].Cells[6].Controls[0];
my_MaterialTypeID = (TextBox)gv.Rows[e.RowIndex].Cells[7].Controls[0];
my_MaterialUnit = (TextBox)gv.Rows[e.RowIndex].Cells[8].Controls[0];
my_Active = (TextBox)gv.Rows[e.RowIndex].Cells[9].Controls[0];
//檢查更新是否成功
if (UpdateICS_Material(my_NO, my_MaterialName, my_PurchaseUnit, my_ConsumeUnit, my_ConversionFactor, my_MaterialSafeQuantity, my_MaterialTypeID, my_MaterialUnit, my_Active))
{
ShowMsg2(UpdatePanel1, "更新成功");
}
else
{
ShowMsg2(UpdatePanel1, "更新失敗");
}
gv.EditIndex = -1;
InitData();
SearchData();
}
protected void gvTagCategory_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
M_TagCategory model = new M_TagCategory();
int tagCategoryId = (int)gvTagCategory.DataKeys[e.RowIndex].Value;
TextBox txtName = gvTagCategory.Rows[e.RowIndex].FindControl("txtName") as TextBox;
string name = txtName.Text.Trim();
TextBox txtDesc = gvTagCategory.Rows[e.RowIndex].FindControl("txtDesc") as TextBox;
string desc = txtDesc.Text.Trim();
if(name.Length==0||name.Length>20)
{
LitMsg.Text = "<script type='text/javascript'>alert('Tag类别名称必须填写');</script>";
return;
}
if(desc.Length>100)
{
LitMsg.Text = "<script type='text/javascript'>alert('Tag类别描述不能超过100个字');</script>";
return;
}
model.TagCategoryId = tagCategoryId;
model.Name = name;
model.Desc = desc;
Bll.Update(model);
gvTagCategory.EditIndex = -1;
Bind();
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
//Get the CheckBox in the row that is being updated
CheckBox adminbox = (CheckBox)GridView1.Rows[e.RowIndex].FindControl("CheckBox1");
//Get the User
string username = GridView1.Rows[e.RowIndex].Cells[0].Text;
//get the username from the datakeys collection instead
//string username1 = GridView1.DataKeys[e.RowIndex].Value.ToString();
//if the checkbox is checked and the user is not currently an admin, add the user to the admin role
if(adminbox.Checked && Roles.IsUserInRole(username,"Admin"))
{
Roles.AddUserToRole(username, "Admin");
}
//if the checkebox is unchecked and the user is currently an admin, remove the user from the Admin role
if(!adminbox.Checked && Roles.IsUserInRole(username, "Admin"))
{
Roles.RemoveUserFromRole(username, "Admin");
}
GridView1.EditIndex = -1;
GridView1.DataBind();
}
protected void GV_UomConversion_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
string BaseQty = ((TextBox)GV_UomConversion.Rows[e.RowIndex].Cells[3].Controls[1]).Text.ToString().Trim();
string AlterQty = ((TextBox)GV_UomConversion.Rows[e.RowIndex].Cells[5].Controls[1]).Text.ToString().Trim();
try
{
Convert.ToDecimal(BaseQty);
}
catch (Exception)
{
e.Cancel = true;
ShowErrorMessage("Common.Decimal.Error", itemMessage);
return;
}
try
{
Convert.ToDecimal(AlterQty);
}
catch (Exception)
{
e.Cancel = true;
ShowErrorMessage("Common.Decimal.Error", itemMessage);
return;
}
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
GridViewRow row;
row = GridView1.Rows[e.RowIndex];
TextBox t;
t = (TextBox)row.Cells[3].Controls[0];
string nename = t.Text;
t = (TextBox)row.Cells[4].Controls[0];
string eid = t.Text;
int eno = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Value);
MySqlCommand cmd = new MySqlCommand("update forum_users set username='******',password=password('" + eid + "') where id=" + eno, con);
try
{
con.Open();
cmd.ExecuteNonQuery();
con.Close();
GridView1.EditIndex = -1;
binddata();
}
catch (Exception ex)
{
CreateLogFile log = new CreateLogFile();
log.ErrorLog(Server.MapPath("../Logs/Errorlog"), "GridView RowUpdating method of Stud_EditDel page for " + Session["loginname"] + ":"+ex.Message);
}
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
SQLDB db = new SQLDB();
string deviceKind = gv.Rows[e.RowIndex].Cells[1].Text;
TextBox checkcycle;
checkcycle = (TextBox)gv.Rows[e.RowIndex].Cells[2].Controls[0];
if (!IsNumeric(checkcycle.Text))
{
ShowMsg2(UpdatePanel1, "請輸入數字");
return;
}
//檢查更新是否成功
string updatestring = "Update CD_CheckCycle set cycle= '" + checkcycle.Text + "' where Devicekind = '" + deviceKind + "'";
if (db.ExecuteStatement(updatestring))
{
ShowMsg2(UpdatePanel1, "更新成功");
}
else
{
ShowMsg2(UpdatePanel1, "更新失敗");
}
gv.EditIndex = -1;
InitData();
SearchData();
}
protected void GridView2_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
DropDownList ddlevelForMultCh = (DropDownList)(GridView2.Rows[e.RowIndex].FindControl("ddlevelForMultCh"));
caseOfErr = (DropDownList)(GridView2.Rows[e.RowIndex].FindControl("ddForMultChoCaseOferror"));
e.NewValues.Add("caseOfError", caseOfErr.SelectedItem.ToString());
e.NewValues.Add("level", ddlevelForMultCh.SelectedItem.ToString());
}
protected void gvMappedInstruments_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
try
{
GridViewRow editingRow = (gvMappedInstruments.EditIndex >= 0 ? gvMappedInstruments.Rows[gvMappedInstruments.EditIndex] : null);
if (editingRow != null)
{
DropDownList ddlAssetClass = (DropDownList)Utility.FindControl(editingRow, "ddlAssetClass");
DropDownList ddlRegionClass = (DropDownList)Utility.FindControl(editingRow, "ddlRegionClass");
DropDownList ddlInstrumentsCategories = (DropDownList)Utility.FindControl(editingRow, "ddlInstrumentsCategories");
DropDownList ddlSectorClass = (DropDownList)Utility.FindControl(editingRow, "ddlSectorClass");
DecimalBox dbMaxWithdrawalAmountPercentage = (DecimalBox)Utility.FindControl(editingRow, "dbMaxWithdrawalAmountPercentage");
e.NewValues["assetClassId"] = Convert.ToInt32(ddlAssetClass.SelectedValue);
e.NewValues["regionClassId"] = Convert.ToInt32(ddlRegionClass.SelectedValue);
e.NewValues["instrumentsCategoryId"] = Convert.ToInt32(ddlInstrumentsCategories.SelectedValue);
e.NewValues["sectorClassId"] = Convert.ToInt32(ddlSectorClass.SelectedValue);
e.NewValues["maxWithdrawalAmountPercentage"] = dbMaxWithdrawalAmountPercentage.Value;
}
}
catch (Exception ex)
{
e.Cancel = true;
lblErrorMessage.Text = Utility.GetCompleteExceptionMessage(ex);
}
}
protected void GvOrder_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
int i = e.RowIndex;
DataRow rOrder = TableOrder.Rows[i];
GridViewRow row = GvOrder.Rows[e.RowIndex];
double f = -1;
double.TryParse(((TextBox)(row.Cells[1].Controls[0])).Text,out f);
int quant = (int)f;
if (quant < 0) return;
string s = (string)rOrder[4];
if (s[0] > '9' || s[0] <= '0')
{
//get rid of "$"
s = s.Substring(1);
}
rOrder["SubPrice"] = (Convert.ToDouble(s) * quant).ToString("C");
rOrder["Quantity"] = quant;
GvOrder.EditIndex = -1;
Update();
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
try
{
UserDetails userDetails = new UserDetails();
userDetails.userID = GridView1.Rows[e.RowIndex].Cells[0].Text;
userDetails.firstName = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].Controls[0])).Text;
userDetails.lastName = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[2].Controls[0])).Text;
userDetails.phone = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[5].Controls[0])).Text;
userDetails.cityID = int.Parse(((DropDownList)(GridView1.Rows[e.RowIndex].Cells[3].FindControl("DropDownList1"))).SelectedValue);
userDetails.address = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[6].FindControl("TextBox1"))).Text;
userDetails.state = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[6].FindControl("TextBox3"))).Text;
userDetails.zipCode = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[6].FindControl("TextBox2"))).Text;
UserService userService = new UserService();
userService.UpdateUserDetails(userDetails);
GridView1.EditIndex = -1;
populateGrid();
}
catch (Exception ex)
{
Label1.Text = ex.Message;
}
}
protected void gridStudent_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
SqlConnection connection = SqlHelper.GetConnection();
var dataAdapter = new SqlDataAdapter(selectCommandText, connection);
var builder = new SqlCommandBuilder(dataAdapter);
dataAdapter.DeleteCommand = builder.GetDeleteCommand();
DataSet dataSet = SqlHelper.GetDataSetBySqlCommand(selectCommandText, connection);
string studentID = (gridStudent.Rows[e.RowIndex].Cells[1].Controls[0] as TextBox).Text;
string name = (gridStudent.Rows[e.RowIndex].Cells[2].Controls[0] as TextBox).Text;
string gender = (gridStudent.Rows[e.RowIndex].Cells[3].Controls[0] as TextBox).Text;
string dayOfBirth = (gridStudent.Rows[e.RowIndex].Cells[4].Controls[0] as TextBox).Text;
string address = (gridStudent.Rows[e.RowIndex].Cells[5].Controls[0] as TextBox).Text;
string department = (gridStudent.Rows[e.RowIndex].Cells[6].Controls[0] as TextBox).Text;
//获取 DataSet 中与点击了 “编辑” 按钮的这行对应的数据行
DataRow row = dataSet.Tables[0].Rows[e.RowIndex];
//修改其中各字段的值
row["StudentID"] = studentID;
row["Name"] = name;
row["Gender"] = gender;
row["DayOfBirth"] = dayOfBirth;
row["Address"] = address;
row["Department"] = department;
//提交到数据库中
dataAdapter.Update(dataSet);
gridStudent.EditIndex = -1;
ShowData();
}
protected void UserAccounts_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
Guid id = (Guid)e.Keys[0];
GridViewRow row = UserAccounts.Rows[e.RowIndex];
string fullname = (row.FindControl("txtFullname") as TextBox).Text;
string email = (row.FindControl("txtEmail") as TextBox).Text;
string phone = (row.FindControl("txtPhone") as TextBox).Text;
string comment = (row.FindControl("txtComment") as TextBox).Text;
bool isApproved = (row.FindControl("chkIsApproved") as CheckBox).Checked;
MembershipUser user = Membership.GetUser(id);
if (user == null) return;
user.Email = email;
user.Comment = comment;
user.IsApproved = isApproved;
Membership.UpdateUser(user);
aspnet_UserProfilesBLL bll = new aspnet_UserProfilesBLL();
bll.UpdateProfile(user.UserName, fullname, phone);
//LinqDataSource1.DataBind();
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
GridViewRow gvr = this.GridView1.Rows[this.GridView1.EditIndex];
DropDownList ddl = (DropDownList)gvr.Cells[9].FindControl("DropDownList1");
e.NewValues["Type"] = ddl.SelectedValue;
}
protected void gridViewFarms_RowUpdating(object sender,
GridViewUpdateEventArgs e)
{
GridViewRow row = gridViewFarms.Rows[e.RowIndex];
try
{
sqlConnection.Open();
SqlCommand cmd = sqlConnection.CreateCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "UpdateNotes";
cmd.Parameters.Add("@VillageCoordinates", SqlDbType.Int).Value = ((TextBox) row.Cells[0].Controls[0]).Text;
cmd.Parameters.Add("@Notes", SqlDbType.NVarChar).Value = ((TextBox) row.Cells[7].Controls[0]).Text;
cmd.ExecuteNonQuery();
}
catch (SqlException ex)
{
LabelStatus.Text = ex.ToString();
}
finally
{
sqlConnection.Close();
}
gridViewFarms.EditIndex = -1;
PopulateGridView();
}
protected void AdminDoctorView_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
BusinessLayer businessLyerObj = new BusinessLayer();
string connectString = ConfigurationManager.AppSettings.Get("connString");
int index = e.RowIndex;
businessLyerObj.ApproveDoctor(AdminDoctorView.DataKeys[index].Value.ToString(), connectString);
}
protected void gridViewIssueMaintenance_OnRowUpdating(object sender, GridViewUpdateEventArgs e)
{
// Check for New Row
if (Convert.ToString(e.Keys["IssueID"]) == "")
{
// --------------- //
// Transfer Values //
// --------------- //
// Issue
if (e.NewValues["Issue"] != null) { hiddenFieldIssue.Value = Convert.ToString(e.NewValues["Issue"].ToString()); };
// IssueDescription
if (e.NewValues["IssueDescription"] != null) { hiddenFieldIssueDescription.Value = Convert.ToString(e.NewValues["IssueDescription"].ToString()); };
// IssueLevelID
if (e.NewValues["IssueLevelID"] != null) { hiddenFieldIssueLevelID.Value = Convert.ToString(e.NewValues["IssueLevelID"].ToString()); };
// IssueStatusID
if (e.NewValues["IssueStatusID"] != null) { hiddenFieldIssueStatusID.Value = Convert.ToString(e.NewValues["IssueStatusID"].ToString()); };
// Notes
if (e.NewValues["Notes"] != null) { hiddenFieldNotes.Value = Convert.ToString(e.NewValues["Notes"].ToString()); };
// New Row - Insert
objectDataSourceIssue.Insert();
// Reload Page
Response.Redirect(Request.RawUrl);
}
}
protected void datagridview_RowUpdate(object sender, GridViewUpdateEventArgs e)
{
// this is important
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
}
protected void gvReal_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
HtmlInputHidden key = (HtmlInputHidden)gvReal.Rows[e.RowIndex].Cells[0].FindControl("realid");
string sID = key.Value;
string sCode = ((TextBox)(gvReal.Rows[e.RowIndex].Cells[2].Controls[0])).Text.ToString().Trim();
string sDesc = ((TextBox)(gvReal.Rows[e.RowIndex].Cells[3].Controls[0])).Text.ToString().Trim();
string sEngunit = ((TextBox)(gvReal.Rows[e.RowIndex].Cells[4].Controls[0])).Text.ToString().Trim();
string sMax = ((TextBox)(gvReal.Rows[e.RowIndex].Cells[5].Controls[0])).Text.ToString().Trim();
string sMin = ((TextBox)(gvReal.Rows[e.RowIndex].Cells[6].Controls[0])).Text.ToString().Trim();
string sSnapshot = ((DropDownList)(gvReal.Rows[e.RowIndex].Cells[7].FindControl("ddlSnapshot"))).SelectedValue;
string sSort = ((DropDownList)(gvReal.Rows[e.RowIndex].Cells[8].FindControl("ddlSort"))).SelectedValue;
string sDisplay = ((DropDownList)(gvReal.Rows[e.RowIndex].Cells[9].FindControl("ddlDisplay"))).SelectedValue;
string sXYZ = ((DropDownList)(gvReal.Rows[e.RowIndex].Cells[10].FindControl("ddlXYZ"))).SelectedValue;
string sNote = ((TextBox)(gvReal.Rows[e.RowIndex].Cells[11].Controls[0])).Text.ToString().Trim();
string msg = "";
if (sCode == "")
{
msg += "名称不能为空！\r\n";
}
//判断double格式
if (sMax != "" && !Regex.IsMatch(sMax, @"^\d*[.]?\d*$"))
{
msg += "最值只能为空或数字组成！\r\n";
}
//判断double格式
if (sMin != "" && !Regex.IsMatch(sMin, @"^\d*[.]?\d*$"))
{
msg += "最值只能为空或数字组成！\r\n";
}
if (msg != "")
{
MessageBox.popupClientMessage(this.Page, msg);
return;
}
//代码是否重复
if (KPI_RealTagDal.CodeExist(sCode, sID) || ALLDal.CodeExist(sCode, sID))
{
MessageBox.popupClientMessage(this.Page, "已存在相同的标签!");
return;
}
//更新
KPI_RealTagEntity ote = new KPI_RealTagEntity();
ote.RealID = sID;
ote.RealCode = sCode;
ote.RealDesc = sDesc;
ote.RealEngunit = sEngunit;
if (sMax != "")
{
ote.RealMaxValue = decimal.Parse(sMax);
}
if (sMin != "")
{
ote.RealMinValue = decimal.Parse(sMin);
}
ote.RealSnapshot = sSnapshot;
ote.RealSort = sSort;
//if (sDisplay == "0")
ote.RealDisplay = sDisplay;
ote.RealXYZ = sXYZ;
ote.RealNote = sNote;
ote.RealModifyTime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss");
if (KPI_RealTagDal.Update(ote))
{
MessageBox.popupClientMessage(this.Page, "编辑成功！", "call();");
}
else
{
MessageBox.popupClientMessage(this.Page, "编辑错误！", "call();");
}
gvReal.EditIndex = -1;
BindReal();
}
protected void BooksGrid_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
GridViewRow row = (GridViewRow)BooksGrid.Rows[e.RowIndex];
TextBox textName = (TextBox)row.Cells[1].Controls[0];
TextBox textAuthor = (TextBox)row.Cells[2].Controls[0];
TextBox textPublishYear = (TextBox)row.Cells[3].Controls[0];
TextBox textGenre = (TextBox)row.Cells[4].Controls[0];
TextBox textDescription = (TextBox)row.Cells[5].Controls[0];
string name, author, publishYear, genre, description;
string BookID = ViewState["BookID"].ToString();
name = textName.Text;
author = textAuthor.Text;
publishYear = textPublishYear.Text;
genre = textGenre.Text;
description = textDescription.Text;
BooksGrid.EditIndex = -1;
SqlCommand cmdUpdtBooks = new SqlCommand("UPDATE DS_Library.[dbo].Books SET Title = @Name, Author = @Author, [Publish year] = @PublishYear, Genre = @Genre , Description = @Description WHERE BookID = @BookID;", conn);
cmdUpdtBooks.Parameters.Add("@BookID", System.Data.SqlDbType.Int);
cmdUpdtBooks.Parameters["@BookID"].Value = Convert.ToInt32(BookID);
cmdUpdtBooks.Parameters.Add("@Name", System.Data.SqlDbType.VarChar);
cmdUpdtBooks.Parameters["@Name"].Value = name;
cmdUpdtBooks.Parameters.Add("@Author", System.Data.SqlDbType.VarChar);
cmdUpdtBooks.Parameters["@Author"].Value = author;
cmdUpdtBooks.Parameters.Add("@PublishYear", System.Data.SqlDbType.Int);
cmdUpdtBooks.Parameters["@PublishYear"].Value = Convert.ToInt32(publishYear);
cmdUpdtBooks.Parameters.Add("@Genre", System.Data.SqlDbType.VarChar);
cmdUpdtBooks.Parameters["@Genre"].Value = genre;
cmdUpdtBooks.Parameters.Add("@Description", System.Data.SqlDbType.VarChar);
cmdUpdtBooks.Parameters["@Description"].Value = description;
BooksGrid.EditIndex = -1;
try
{
conn.Open();
// Label1.Text = "Reached Before.";
cmdUpdtBooks.ExecuteNonQuery();
// Label1.Text += "Reached After";
}
finally
{
conn.Close();
}
WarningLabel.Visible = false;
BindDetails();
}
protected void gv_schemesteps_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
try
{
ArrayList data = new ArrayList();
GridViewRow row = gv_schemesteps.Rows[e.RowIndex];
for (int i = 1; i < gv_schemesteps.Columns.Count-1; i++)
{
TableCell cell = row.Controls[i] as TableCell;
if (cell.Controls[0] is TextBox)
{
TextBox box = cell.Controls[0] as TextBox;
data.Add(box.Text);
}
else if (cell.Controls[0] is HyperLink)
{
HyperLink hl = cell.Controls[0] as HyperLink;
data.Add(hl.Text);
}
else if (cell.Controls[0] is CheckBox)
{
CheckBox chk = cell.Controls[0] as CheckBox;
data.Add(chk.Checked.ToString());
}
}
String uqry = "UPDATE db_performancereportstep SET recurring=@recurring, recur=@recur, num_weeks=@num_weeks WHERE step_id=@step_id";
SQL.Update(uqry,
new String[] { "@recurring", "@recur", "@num_weeks", "@step_id" },
new Object[] { data[5].ToString().Replace("True","1").Replace("False","0"),
data[6].ToString(),
data[7].ToString(),
data[0].ToString()
});
// In case of duration changes, update all steps from updated point
String qry = "SELECT * FROM db_performancereportstep, db_performancereportscheme " +
"WHERE db_performancereportscheme.scheme_id = db_performancereportstep.scheme_id " +
"AND db_performancereportscheme.scheme_id=@scheme_id " +
"AND office=@office AND step_id >= @step_id " +
"ORDER BY step_no";
DataTable steps = SQL.SelectDataTable(qry,
new String[] { "@office", "@step_id", "@scheme_id" },
new Object[] { dd_office.SelectedItem.Text, data[0].ToString(), dd_schemes.SelectedItem.Value });
if (steps.Rows.Count > 0)
{
DateTime last_start_date = Convert.ToDateTime(steps.Rows[0][3]);
for (int i = 0; i < steps.Rows.Count; i++)
{
bool recurring = Convert.ToBoolean(steps.Rows[i][6]);
int recur = Convert.ToInt32(steps.Rows[i][8])+1;
int num_weeks = Convert.ToInt32(steps.Rows[i][4]);
int duration_weeks = num_weeks;
DateTime start_date = Convert.ToDateTime(steps.Rows[i][3]);
DateTime next_start_date = start_date;
if (recurring) { duration_weeks = num_weeks * recur; }
int complete = 0;
if (DateTime.Now > next_start_date.AddDays(duration_weeks * 7)) { complete = 1; }
uqry = "UPDATE db_performancereportstep SET duration_weeks=@dw, complete=@c WHERE step_id=@s_id";
SQL.Update(uqry,
new String[] { "@dw", "@c", "@s_id" },
new Object[] { duration_weeks, complete, steps.Rows[i][0].ToString() });
if (i != (steps.Rows.Count - 1))
{
next_start_date = last_start_date.AddDays(duration_weeks * 7);
uqry = "UPDATE db_performancereportstep SET start_date=@sd WHERE step_id=@s_id";
SQL.Update(uqry,
new String[] { "@sd", "@s_id" },
new Object[] { next_start_date.ToString("yyyy/MM/dd"), steps.Rows[i + 1][0].ToString()});
last_start_date = next_start_date;
}
else
{
String active = "1";
if (complete == 1) { active = "0"; }
uqry = "UPDATE db_performancereportscheme SET active=@active WHERE scheme_id=@s_id";
SQL.Update(uqry,
new String[] { "@active", "@s_id" },
new Object[] { active, steps.Rows[i][1].ToString() });
}
}
}
}
catch (Exception r)
{
Util.Debug(r.Message + " " + r.StackTrace + " " + r.InnerException);
Util.PageMessage(this, "Error updating record. Make sure you are entering the correct data in each field. Dates should be formatted: dd/MM/yy.");
}
gv_schemesteps.EditIndex = -1;
BindData(null, null);
}
protected void gv_schemes_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
try
{
ArrayList data = new ArrayList();
GridViewRow row = gv_schemes.Rows[e.RowIndex];
for (int i = 1; i < gv_schemes.Columns.Count; i++)
{
TableCell cell = row.Controls[i] as TableCell;
if (cell.Controls[0] is TextBox)
{
TextBox box = cell.Controls[0] as TextBox;
data.Add(box.Text);
}
}
if (data[2].ToString() != "")
{
// Handle date
DateTime entryDate = Convert.ToDateTime(data[2]);
data[2] = entryDate.ToString("yyyy/MM/dd");
String uqry = "UPDATE db_performancereportscheme SET " +
"scheme_name=@scheme_name, " +
"start_date=@start_date, " +
"step_s=@s, " +
"step_p=@p, " +
"step_a=@a, " +
"step_rev=@rev " +
"WHERE scheme_id=@scheme_id";
SQL.Update(uqry,
new String[] { "@scheme_name", "@start_date", "@s", "@p", "@a", "@rev", "@scheme_id" },
new Object[] { data[1].ToString(),
data[2].ToString(),
data[4].ToString(),
data[5].ToString(),
data[6].ToString(),
data[7].ToString(),
data[0].ToString()
});
// In case of start_date change, update all steps
String qry = "SELECT * FROM db_performancereportstep, db_performancereportscheme " +
"WHERE db_performancereportscheme.scheme_id = db_performancereportstep.scheme_id " +
"AND db_performancereportscheme.scheme_id=@scheme_id " +
"AND office=@office";
DataTable steps = SQL.SelectDataTable(qry,
new String[] { "@scheme_id", "@office" },
new Object[] { dd_schemes.SelectedItem.Value, dd_office.SelectedItem.Text });
if (steps.Rows.Count > 0 && steps.Rows[0][3].ToString() != entryDate.ToString())
{
DateTime new_start_date = entryDate;
for (int i = 0; i < steps.Rows.Count; i++)
{
if (i != 0)
{
int weeks = Convert.ToInt32(steps.Rows[i-1][5]);
new_start_date = new_start_date.AddDays(weeks * 7);
}
int complete = 0;
int duration = Convert.ToInt32(steps.Rows[i][5]);
if (DateTime.Now > new_start_date.AddDays(duration*7)) { complete = 1; }
uqry = "UPDATE db_performancereportstep SET " +
"start_date=@start_date, " +
"complete=@complete " +
"WHERE step_id=@step_id";
SQL.Update(uqry,
new String[] { "@start_date", "@complete", "@step_id" },
new Object[] { new_start_date.ToString("yyyy/MM/dd"),
complete,
steps.Rows[i][0]
});
if (i == (steps.Rows.Count - 1))
{
String active = "1";
if (complete == 1) { active = "0"; }
uqry = "UPDATE db_performancereportscheme SET active=@active WHERE scheme_id=@scheme_id";
SQL.Update(uqry, new String[] { "@active", "@scheme_id" }, new Object[] { active, steps.Rows[i][1] });
}
}
}
}
else
{
Util.PageMessage(this, "You must enter a start date for this scheme.");
}
}
catch (Exception)
{
Util.PageMessage(this, "Error updating record. Make sure you are entering the correct data in each field. Dates should be formatted: dd/MM/yy.");
}
gv_schemes.EditIndex = -1;
BindData(null, null);
}
protected void grid_carcolor_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
}
protected void gvReviews_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
int rowIndex = e.RowIndex;
int ReviewID = int.Parse(gvReviews.Rows[rowIndex].Cells[0].Text);
TextBox TBox;
//TBox = (TextBox)gvReviews.Rows[rowIndex].Cells[2].Controls[0];
//int FoodRating = int.Parse(TBox.Text);
//TBox = (TextBox)gvReviews.Rows[rowIndex].Cells[3].Controls[0];
//int ServiceRating = int.Parse(TBox.Text);
//TBox = (TextBox)gvReviews.Rows[rowIndex].Cells[4].Controls[0];
//int PriceRating = int.Parse(TBox.Text);
//TBox = (TextBox)gvReviews.Rows[rowIndex].Cells[5].Controls[0];
//String ReviewComment = TBox.Text.ToString();
int foodrating;
int servicerating;
int pricerating;
TBox = (TextBox)gvReviews.Rows[rowIndex].Cells[2].Controls[0];
bool res = int.TryParse(TBox.Text, out foodrating);
TBox = (TextBox)gvReviews.Rows[rowIndex].Cells[3].Controls[0];
bool res1 = int.TryParse(TBox.Text, out servicerating);
TBox = (TextBox)gvReviews.Rows[rowIndex].Cells[4].Controls[0];
bool res2 = int.TryParse(TBox.Text, out pricerating);
TBox = (TextBox)gvReviews.Rows[rowIndex].Cells[5].Controls[0];
String ReviewComment = TBox.Text.ToString();
if (res == false || res1 == false || res2 == false)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "MessageBox", "alert('Please enter a valid number for the Ratings');", true);
}
else
{
if (foodrating > 5 || foodrating < 1 || servicerating > 5 || servicerating < 1 || pricerating > 5 || pricerating < 1)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "MessageBox", "alert('Please enter a number from 1-5 for the Ratings');", true);
}
else
{
SqlCommand objCommand = new SqlCommand();
objCommand.CommandType = CommandType.StoredProcedure;
objCommand.CommandText = "UpdateReview";
objCommand.Parameters.AddWithValue("@ReviewID", ReviewID);
objCommand.Parameters.AddWithValue("@ChangedFoodRating", foodrating);
objCommand.Parameters.AddWithValue("@ChangedServiceRating", servicerating);
objCommand.Parameters.AddWithValue("@ChangedPriceRating", pricerating);
objCommand.Parameters.AddWithValue("@ChangedReviewComment", ReviewComment);
DBConnect objDB = new DBConnect();
objDB.DoUpdateUsingCmdObj(objCommand);
gvReviews.EditIndex = -1;
//Rebind GV
SqlCommand objCommand2 = new SqlCommand();
objCommand2.CommandType = CommandType.StoredProcedure;
objCommand2.CommandText = "GetReviewByAccountID";
objCommand2.Parameters.AddWithValue("@AccountID", AccountID);
DBConnect objDB2 = new DBConnect();
DataSet myDataSet2 = objDB2.GetDataSetUsingCmdObj(objCommand2);
gvReviews.DataSource = myDataSet2;
gvReviews.DataBind();
}
}
}
protected void GridView_Update(object sender, GridViewUpdateEventArgs e)
{
string userId = userGrid.DataKeys[e.RowIndex].Values[0].ToString();
if (!FooStringHelper.IsValidAlphanumeric(userId, 16))
{
errorLabel.Text = "Invalid request.";
Reset_Page();
return;
}
var txtUserName = (TextBox)userGrid.Rows[e.RowIndex].FindControl("txtUserName");
var txtUserAlias = (TextBox)userGrid.Rows[e.RowIndex].FindControl("txtUserAlias");
var txtEmail = (TextBox)userGrid.Rows[e.RowIndex].FindControl("txtEmail");
var groupDropdown = (DropDownList)userGrid.Rows[e.RowIndex].FindControl("groupDropdown");
if (!string.IsNullOrEmpty(txtUserName.Text) && !string.IsNullOrEmpty(txtUserAlias.Text) &&
!string.IsNullOrEmpty(txtEmail.Text) && FooStringHelper.IsValidEmailAddress(txtEmail.Text))
{
try
{
if (FooSessionHelper.IsValidRequest(HttpContext.Current, RequestToken.Value))
{
using (var conn = new NpgsqlConnection())
{
conn.ConnectionString =
ConfigurationManager.ConnectionStrings["fooPostgreSQL"].ConnectionString;
conn.Open();
var cmd = new NpgsqlCommand
{
CommandText =
"UPDATE users SET (username, useralias, groupid, email) = (@NAME, @USERALIAS, @GROUP, @EMAIL) WHERE userID= @USERID",
CommandType = CommandType.Text,
Connection = conn
};
var param = new NpgsqlParameter
{
ParameterName = "@USERID",
NpgsqlDbType = NpgsqlDbType.Varchar,
Size = 16,
Direction = ParameterDirection.Input,
Value = userId
};
cmd.Parameters.Add(param);
var nameParam = new NpgsqlParameter
{
ParameterName = "@USERNAME",
NpgsqlDbType = NpgsqlDbType.Varchar,
Size = 32,
Direction = ParameterDirection.Input,
Value = txtUserName.Text
};
cmd.Parameters.Add(nameParam);
var dispParam = new NpgsqlParameter
{
ParameterName = "@USERALIAS",
NpgsqlDbType = NpgsqlDbType.Varchar,
Size = 32,
Direction = ParameterDirection.Input,
Value = txtUserAlias.Text
};
cmd.Parameters.Add(dispParam);
var emailParam = new NpgsqlParameter
{
ParameterName = "@EMAIL",
NpgsqlDbType = NpgsqlDbType.Varchar,
Size = 64,
Direction = ParameterDirection.Input,
Value = txtEmail.Text
};
cmd.Parameters.Add(emailParam);
var groupParam = new NpgsqlParameter
{
ParameterName = "@GROUP",
NpgsqlDbType = NpgsqlDbType.Varchar,
Size = 16,
Direction = ParameterDirection.Input,
Value = groupDropdown.SelectedValue
};
cmd.Parameters.Add(groupParam);
cmd.ExecuteNonQuery();
}
}
else
{
errorLabel.Text = "Invalid request.";
}
}
catch (Exception ex)
{
FooLogging.WriteLog(ex.ToString());
errorLabel.Text = "Something has gone wrong. A log has been forwarded to the site administrator.";
}
}
else
{
errorLabel.Text = "Incomplete or invalid input.";
}
Reset_Page();
}
protected void dgTransportMaster_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
}
protected void listaUsuarios_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
Debug.WriteLine("RowUpdating chamado");
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
try
{
int dk = Convert.ToInt32(GridView1.DataKeys[GridView1.EditIndex].Value);
TextBox cat = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txtCategory1");
DropDownList wh = (DropDownList)GridView1.Rows[GridView1.EditIndex].FindControl("ddlBusiness1");
CheckBox cb = (CheckBox)GridView1.Rows[e.RowIndex].FindControl("cbxStatus1");
//string str1 = "SELECT * from JobFunctionCategory where CategoryName ='" + cat.Text + "' and Whid='" + wh.SelectedValue + "' and Id<>'" + dk + "'";
//SqlCommand cmd1 = new SqlCommand(str1, con);
//SqlDataAdapter da1 = new SqlDataAdapter(cmd1);
//DataTable dt1 = new DataTable();
//da1.Fill(dt1);
CLS_JobFunctionCategory jfc = new CLS_JobFunctionCategory();
jfc.Whid = wh.SelectedValue;
jfc.CategoryName = cat.Text;
jfc.Id = dk.ToString();
DataTable dt1 = jfc.cls_jobfunctioncategory5();
if (dt1.Rows.Count > 0)
{
lblmsg.Visible = true;
lblmsg.Text = "Category already exist";
}
else
{
int i;
if (cb.Checked == true)
{
i = 1;
}
else
{
i = 0;
}
string sr51 = ("update JobFunctionCategory set CategoryName ='" + cat.Text + "',Whid='" + wh.SelectedValue + "',Status = " + i + " where Id='" + dk + "' ");
SqlCommand cmd801 = new SqlCommand(sr51, con);
if (con.State.ToString() != "Open")
{
con.Open();
}
cmd801.ExecuteNonQuery();
con.Close();
//jfc.Whid = wh.SelectedValue;
//jfc.CategoryName = cat.Text;
//jfc.Id = dk.ToString();
//jfc.cls_update_jobfunction();
GridView1.EditIndex = -1;
fillgrid();
lblmsg.Visible = true;
lblmsg.Text = "Record updated successfully";
//ddl();
}
}
catch (Exception ert)
{
lblmsg.Visible = true;
lblmsg.Text = "Error :" + ert.Message;
}
}
protected void gvSeniorityRecords_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
try
{
lblmsg.Text = "";
int CrewID = UDFLib.ConvertToInteger(gvSeniorityRecords.DataKeys[e.RowIndex].Values[0].ToString());
int CompanySeniorityYear = UDFLib.ConvertToInteger(gvSeniorityRecords.DataKeys[e.RowIndex].Values[1].ToString());
int CompanySeniorityDays = UDFLib.ConvertToInteger(gvSeniorityRecords.DataKeys[e.RowIndex].Values[2].ToString());
int CompanySeniorityYear_New = UDFLib.ConvertToInteger(e.NewValues["CompanySeniorityYear"]);
int CompanySeniorityDays_New = UDFLib.ConvertToInteger(e.NewValues["CompanySeniorityDays"]);
string Remarks = "Updating Company Seniority first time for existing crews";
DateTime CompanyEffectiveDate_New;
if ((CompanySeniorityYear_New > 0 || CompanySeniorityDays_New > 0) && (CompanySeniorityYear != CompanySeniorityYear_New || CompanySeniorityDays != CompanySeniorityDays_New))
{
if (CompanySeniorityDays_New > 364)
{
lblmsg.Text = "Company Seniority Days cannot be greater than 364";
}
if (e.NewValues["CompanyEffective_date"] != null)
{
CompanyEffectiveDate_New = UDFLib.ConvertToDate(Convert.ToString(e.NewValues["CompanyEffective_date"]), UDFLib.GetDateFormat());
BLL_PortageBill.Update_CrewCompanySeniority(CrewID, CompanySeniorityYear_New, CompanySeniorityDays_New, Remarks, CompanyEffectiveDate_New, Convert.ToInt32(Session["userid"]));
}
else
{
lblmsg.Text = "Company Effective Date is mandatory to update Company Seniority";
}
}
int RankSeniorityYear = UDFLib.ConvertToInteger(gvSeniorityRecords.DataKeys[e.RowIndex].Values[3].ToString());
int RankSeniorityDays = UDFLib.ConvertToInteger(gvSeniorityRecords.DataKeys[e.RowIndex].Values[4].ToString());
int RankSeniorityYear_New = UDFLib.ConvertToInteger(e.NewValues["RankSeniorityYear"]);
int RankSeniorityDays_New = UDFLib.ConvertToInteger(e.NewValues["RankSeniorityDays"]);
Remarks = "Updating Rank Seniority first time for existing crews";
if ((RankSeniorityYear_New > 0 || RankSeniorityDays_New > 0) && (RankSeniorityYear != RankSeniorityYear_New || RankSeniorityDays != RankSeniorityDays_New))
{
GridViewRow row = (GridViewRow)gvSeniorityRecords.Rows[e.RowIndex];
int RankId1 = int.Parse(((DropDownList)row.FindControl("ddlSeniorityRank")).SelectedValue.ToString());
if (RankSeniorityDays_New > 364)
{
lblmsg.Text = "Rank Seniority Days cannot be greater than 364";
}
if (e.NewValues["RankEffective_date"] != null)
{
BLL_PortageBill.Update_CrewRankSeniority(CrewID, RankId1, RankSeniorityYear_New, RankSeniorityDays_New, 0, Remarks, UDFLib.ConvertToDate(e.NewValues["RankEffective_date"].ToString(), UDFLib.GetDateFormat()), Convert.ToInt32(Session["userid"]));
}
else
{
lblmsg.Text = "Rank Effective Date is mandatory to update Rank Seniority";
}
}
if (lblmsg.Text.Trim() == "")
{
lblmsg.Visible = false;
gvSeniorityRecords.EditIndex = -1;
Load_SeniorityRecords();
}
else
{
lblmsg.Visible = true;
}
}
catch (Exception ex)
{
UDFLib.WriteExceptionLog(ex);
}
}
protected void egvShowPictures_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
Response.Redirect(GlobalSettings.RelativeWebRoot + "controlpanel/controlpanel.aspx?site-showpictureadd&ID=" + egvShowPictures.DataKeys[e.RowIndex].Value);
}
protected void gv_PSF_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
try
{
DataSet ds_update = new DataSet();
TextBox txtLetterSentDate = (TextBox)grdNextDueMaintenance.Rows[e.RowIndex].FindControl("txtLetterSentDate");
TextBox txtCallDate = (TextBox)grdNextDueMaintenance.Rows[e.RowIndex].FindControl("txtCallDate");
TextBox txtSmsDate = (TextBox)grdNextDueMaintenance.Rows[e.RowIndex].FindControl("txtSmsDate");
TextBox txtRemarks = (TextBox)grdNextDueMaintenance.Rows[e.RowIndex].FindControl("txtRemarks");
Label JobCode = (Label)grdNextDueMaintenance.Rows[e.RowIndex].FindControl("lblJobCode");
ds_update = (DataSet)Session["NextDueMaintenance"];
//Uzair
foreach (DataRow dr in ds_update.Tables[0].Rows)
{
if (dr["JobCardCode"].ToString().Trim() == JobCode.Text.Trim())
{
dr["LetterSentDate"] = sysFunc.SaveDate(txtLetterSentDate.Text);
if (txtCallDate.Text == "")
{
dr["CalledDate10Day"] = null;
}
else
{
dr["CalledDate10Day"] = sysFunc.SaveDate(txtCallDate.Text);
}
if (txtSmsDate.Text == "")
{
dr["SMSSendDate"] = null;
}
else
{
dr["SMSSendDate"] = sysFunc.SaveDate(txtSmsDate.Text);
}
dr["Remarks2Day"] = txtRemarks.Text.Trim();
}
}
grdNextDueMaintenance.EditIndex = -1;
grdNextDueMaintenance.DataSource = ds_update;
grdNextDueMaintenance.DataBind();
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char, 5),
new SqlParameter("@JObCardCode", SqlDbType.Char, 8),
new SqlParameter("@LetterSentDate", SqlDbType.DateTime),
new SqlParameter("@CalledDate10Day", SqlDbType.DateTime),
new SqlParameter("@SMSSendDate", SqlDbType.DateTime),
new SqlParameter("@Remarks2Day", SqlDbType.VarChar, 50)
};
param[0].Value = Session["DealerCode"].ToString();
param[1].Value = JobCode.Text;
if (txtLetterSentDate.Text == "")
{
param[2].Value = null;
}
else
{
param[2].Value = sysFunc.SaveDate(txtLetterSentDate.Text);
}
if (txtCallDate.Text == "")
{
param[3].Value = null;
}
else
{
param[3].Value = sysFunc.SaveDate(txtCallDate.Text);
}
if (txtSmsDate.Text == "")
{
param[4].Value = null;
}
else
{
param[4].Value = sysFunc.SaveDate(txtSmsDate.Text);
}
param[5].Value = txtRemarks.Text.Trim();
if (ObjTrans.BeginTransaction(ref Trans) == true)
{
myFunc.ExecuteSP_NonQuery("[sp_SP_CRM_PostSales_NextDueMaintenance_Update]", param, Trans);
//string sql = "update CRM_PostSales_NextDueMaintenance set LetterSentDate = '" + sysFunc.SaveDate(txtLetterSentDate.Text) + "', Remarks2Day = '" + txtRemarks.Text + "' , CalledDate10Day ='" + sysFunc.SaveDate(txtCallDate.Text) + "'" +
// ", SMSSendDate = '" + sysFunc.SaveDate(txtSmsDate.Text) + "' where DealerCode = '" + Session["DealerCode"].ToString() + "' and JobCardCode = '" + JobCode.Text + "' ";
//myFunc.ExecuteQuery(sql, Trans);
}
lblMessage.Visible = true;
lblMessage.ForeColor = Color.Green;
lblMessage.Text = "Record " + JobCode.Text + " Updated";
Session["NextDueMaintenance"] = ds_update;
ObjTrans.CommittTransaction(ref Trans);
}
catch (Exception ex)
{
//ObjTrans.CommittTransaction(ref Trans);
ObjTrans.RollBackTransaction(ref Trans);
lblMessage.Visible = true;
lblMessage.Text = ex.Message;
}
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
GridView1.EditIndex = e.RowIndex;
// Rebind the data
GridView1.DataBind();
}
protected void grdBookDetails_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
grdBookDetails.EditIndex = -1;
BindBookRecordGridView();
}
protected void gdvPortalModulesLists_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
}
protected void gvCustomRatings_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
}
protected void gvEmployees_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
DataTable dt = ((DataSet)ViewState["DNDS"]).Tables["Employees"];
}
protected void gvLoans_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
Label Id = gvCommittee.Rows[e.RowIndex].FindControl("lblId") as Label;
TextBox Name = gvCommittee.Rows[e.RowIndex].FindControl("txtName") as TextBox;
TextBox Duration = gvCommittee.Rows[e.RowIndex].FindControl("txtGridDuration") as TextBox;
TextBox SKU = gvCommittee.Rows[e.RowIndex].FindControl("txtSKU") as TextBox;
//TextBox Date = gvCommittee.Rows[e.RowIndex].FindControl("txtGridDate") as TextBox;
//Label lblSKUProduct = gvCommittee.Rows[e.RowIndex].FindControl("lblDuration") as Label;
if (Duration.Text.Length < 4 || Duration.Text.Length > 4)
{
lblmsgerror.Text = "Enter only 4 digit code";
}
else
{
lblmsgerror.Text = "";
int r = 0;
int n = Convert.ToInt32(SKU.Text);
int left = n;
int rev = 0;
int count = 0;
int val = 0;
while (left > 0)
{
r = left % 10;
if (count > 3)
{
val = val * 10 + r;
//count++;
}
else
{
rev = rev * 10 + r;
count++;
}
left = left / 10;
}
left = rev;
int updateSku = 0;
int r1 = 0;
while (left > 0)
{
r1 = left % 10;
updateSku = updateSku * 10 + r1;
left = left / 10;
}
left = val;
int updateSku1 = 0;
while (left > 0)
{
r1 = left % 10;
// val = val * 10 + r1;
updateSku1 = updateSku1 * 10 + r1;
left = left / 10;
}
p1.Text = updateSku1.ToString() + Duration.Text.ToString();
con.Open();
//updating the record
SqlCommand cmd = new SqlCommand("Update Product set Name='" + Name.Text + "',Code='" + Duration.Text + "',SKU='" + p1.Text.ToString() + "' where Id=" + Convert.ToInt32(Id.Text), con);
cmd.ExecuteNonQuery();
con.Close();
//Setting the EditIndex property to -1 to cancel the Edit mode in Gridview
gvCommittee.EditIndex = -1;
//Call ShowData method for displaying updated data
}
LoadLoans();
}
protected void gridField_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
}
protected void GrdDatos_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
Idioma = (DataTable)ViewState["TablaIdioma"];
DataRow[] Result;
Cnx.SelecBD();
using (SqlConnection sqlCon = new SqlConnection(Cnx.GetConex()))
{
CheckBox chkbox = GrdDatos.Rows[e.RowIndex].FindControl("CkbActivo") as CheckBox;
int VbAdmin = 0;
if (chkbox.Checked == true)
{
VbAdmin = 1;
}
sqlCon.Open();
using (SqlTransaction Transac = sqlCon.BeginTransaction())
{
string VBQuery = "EXEC SP_TablasGeneral 18,@CodUsu, '', '', @Login, @Pass,@VbC77U, '','','UPDATE',0,@Act,0,0,0,@ICC,'01-01-1','02-01-1','03-01-1'";
using (SqlCommand sqlCmd = new SqlCommand(VBQuery, sqlCon, Transac))
{
try
{
string Mensj = "";
string borrar = GrdDatos.DataKeys[e.RowIndex].Value.ToString();
sqlCmd.Parameters.AddWithValue("@Login", (GrdDatos.Rows[e.RowIndex].FindControl("TxtUsu") as TextBox).Text.Trim());
sqlCmd.Parameters.AddWithValue("@Pass", (GrdDatos.Rows[e.RowIndex].FindControl("TxtPassW") as TextBox).Text.Trim());
sqlCmd.Parameters.AddWithValue("@Act", VbAdmin);
sqlCmd.Parameters.AddWithValue("@VbC77U", Session["C77U"].ToString());
sqlCmd.Parameters.AddWithValue("@CodUsu", GrdDatos.DataKeys[e.RowIndex].Value.ToString());
sqlCmd.Parameters.AddWithValue("@ICC", Session["!dC!@"].ToString());
SqlDataReader SDR = sqlCmd.ExecuteReader();
if (SDR.Read())
{
Mensj = HttpUtility.HtmlDecode(SDR["Mensj"].ToString().Trim());
}
SDR.Close();
if (!Mensj.ToString().Trim().Equals(""))
{
Result = Idioma.Select("Objeto= '" + Mensj.ToString().Trim() + "'");
foreach (DataRow row in Result)
{
Mensj = row["Texto"].ToString().Trim();
}
ScriptManager.RegisterClientScriptBlock(this.Page, this.Page.GetType(), "alert", "alert('" + Mensj + "');", true);
Transac.Rollback();
return;
}
Transac.Commit();
GrdDatos.EditIndex = -1;
BindData(TxtBusqueda.Text, "UPD");
}
catch (Exception)
{
Transac.Rollback();
Result = Idioma.Select("Objeto= 'MensErrMod'");
foreach (DataRow row in Result)
{
ScriptManager.RegisterClientScriptBlock(this.Page, this.Page.GetType(), "alert", "alert('" + row["Texto"].ToString() + "');", true);
} //Error en el proceso de edición')", true);
}
}
}
}
}
protected void GridView3_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
lblmsg1.Text = "";
lblmsg1.CssClass = "reset";
SqlConnection con = new SqlConnection(Session[Session["TMLDealercode"] + "-TMLConString"].ToString());
try
{
int catid = int.Parse(GridView3.DataKeys[e.RowIndex].Value.ToString());
string txtdevice = ((TextBox)GridView3.Rows[e.RowIndex].Cells[1].Controls[1]).Text;
string txtipaddress = ((TextBox)GridView3.Rows[e.RowIndex].Cells[2].Controls[1]).Text;
string txtmachineid = ((TextBox)GridView3.Rows[e.RowIndex].Cells[3].Controls[1]).Text;
string drplocname = ((DropDownList)GridView3.Rows[e.RowIndex].Cells[4].Controls[1]).SelectedValue;
// string chkSpeedo = ((System.Web.UI.WebControls.CheckBox)GridView3.Rows[e.RowIndex].Cells[5].Controls[1]).Checked.ToString();
// string EmpType = ((DropDownList)GridView3.Rows[e.RowIndex].Cells[6].Controls[1]).SelectedItem.Text;
string txtDeviceSN = ((TextBox)GridView3.Rows[e.RowIndex].Cells[5].Controls[1]).Text;
//if (EmpType == "Select")
//{
// EmpType = "";
//}
SqlCommand cmd = new SqlCommand("udpUpdateTblDevices_BS", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@SlNo", catid);
cmd.Parameters.AddWithValue("@DeviceName", txtdevice);
cmd.Parameters.AddWithValue("@IpAddress", txtipaddress);
cmd.Parameters.AddWithValue("@MachineId", txtmachineid);
cmd.Parameters.AddWithValue("@LocationName", drplocname);
//cmd.Parameters.AddWithValue("@IsSpeedoBay", chkSpeedo);
//cmd.Parameters.AddWithValue("@EmpType", EmpType);
cmd.Parameters.AddWithValue("@DeviceSerialNo", txtDeviceSN);
SqlParameter msg = cmd.Parameters.Add("@msg", SqlDbType.VarChar, 100);
SqlParameter Flag = cmd.Parameters.Add("@Flag", SqlDbType.Int);
msg.Direction = ParameterDirection.Output;
msg.Value = "";
Flag.Direction = ParameterDirection.Output;
Flag.Value = 0;
con.Open();
cmd.ExecuteNonQuery();
if (Flag.Value.ToString() == "0")
{
lblmsg1.CssClass = "ErrMsg";
lblmsg1.Attributes.Add("style", "text-transform:none !important");
lblmsg1.Text = msg.Value.ToString();
ClientScript.RegisterStartupScript(this.GetType(), "HideLabel", "<script type=\"text/javascript\">setTimeout(\"document.getElementById('" + lblmsg1.ClientID + "').style.display='none'\",5000)</script>");
}
else
{
lblmsg1.CssClass = "ScsMsg";
lblmsg1.Attributes.Add("style", "text-transform:none !important");
lblmsg1.Text = msg.Value.ToString();
GridView3.EditIndex = -1;
ClientScript.RegisterStartupScript(this.GetType(), "HideLabel", "<script type=\"text/javascript\">setTimeout(\"document.getElementById('" + lblmsg1.ClientID + "').style.display='none'\",5000)</script>");
bindgridVal();
}
}
catch (Exception ex)
{
ClientScript.RegisterStartupScript(this.GetType(), "HideLabel", "<script type=\"text/javascript\">setTimeout(\"document.getElementById('" + lblmsg1.ClientID + "').style.display='none'\",5000)</script>");
lblmsg1.Text = ex.Message;
lblmsg1.CssClass = "ErrMsg";
lblmsg1.Attributes.Add("style", "text-transform:none !important");
}
finally
{
con.Close();
}
}
protected void gvNguoiDaiDienVon_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
}
protected void gvExcel_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
getVisible(((Label)gvExcel.Rows[e.RowIndex].Cells[0].FindControl("Label2")).Text, ((Label)gvExcel.Rows[e.RowIndex].Cells[0].FindControl("Label1")).Text);
gvData.DataSource = ddt;
gvData.DataBind();
}
protected void dctGRIDVIEW2_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
DateTime currentTime = DateTime.Now;
DateTime endDate = DateTime.Today.AddDays(90);
foreach (DateTime day in EachDay(currentTime, endDate))
{
if (IsWeekend(day))
{
string insertweekend;
String selectsql;
selectsql = " select slot1 ";
selectsql += " from tempdentistslot ";
selectsql += "WHERE appdate = :day and dentist_id=:dentistid";// +Convert.ToDateTime(day) + "'";
OracleConnection incon = new OracleConnection(connectionString);
OracleCommand cmd1 = new OracleCommand(selectsql, incon);
cmd1.Parameters.Add(":day", day);
cmd1.Parameters.Add(":dentistid", Int64.Parse(GridView2.Rows[e.RowIndex].Cells[2].Text));
incon.Open();
OracleDataReader readerchk;
try
{
readerchk = cmd1.ExecuteReader();
readerchk.Read();
if (!readerchk.HasRows)
{
insertweekend = "INSERT INTO tempDentistSlot (";
insertweekend += "dentist_id, appdate, slot1, slot2, slot3, slot4, slot5, slot6, slot7, slot8, vaction ) ";
insertweekend += "VALUES (";
insertweekend += ":dentist_id, :appdate, :slot1,:slot2, :slot3, :slot4, :slot5, :slot6, :slot7, :slot8, :vaction)";
// OracleConnection incon = new OracleConnection(connectionString);
OracleCommand cmd2 = new OracleCommand(insertweekend, incon);
cmd2.Parameters.Add(":dentist_id", Int64.Parse(GridView2.Rows[e.RowIndex].Cells[2].Text));
cmd2.Parameters.Add(":APPDATE", Convert.ToDateTime(day.ToString()));
cmd2.Parameters.Add(":slot1", "w");
cmd2.Parameters.Add(":slot2", "w");
cmd2.Parameters.Add(":slot3", "w");
cmd2.Parameters.Add(":slot4", "w");
cmd2.Parameters.Add(":slot5", "w");
cmd2.Parameters.Add(":slot6", "w");
cmd2.Parameters.Add(":slot7", "w");
cmd2.Parameters.Add(":slot8", "w");
cmd2.Parameters.Add(":vaction", "");
cmd2.BindByName = true;
int added1 = 0;
// incon.Open();
added1 = cmd2.ExecuteNonQuery();
adderror.Text = "Update doctor vacation";
}
}
catch (Exception err)
{
bdreeor.Text = "Error inserting record. ";
bdreeor.Text += err.Message;
}
finally
{
incon.Close();
}
}
TextBox t = (TextBox)GridView2.Rows[e.RowIndex].Cells[2].FindControl("strtdte");
string strdte = t.Text;
// string strdte = (GridView2.FooterRow.FindControl("startdate") as TextBox).Text;
// string enddte = (GridView2.FooterRow.FindControl("enddate") as TextBox).Text;
TextBox t1 = (TextBox)GridView2.Rows[e.RowIndex].Cells[2].FindControl("enddte");
string enddte = t1.Text;
if (day >= Convert.ToDateTime(strdte) && day <= Convert.ToDateTime(enddte))
{
string INSERTSQL;
INSERTSQL = "INSERT INTO tempDentistSlot (";
INSERTSQL += "dentist_id, appdate, slot1, slot2, slot3, slot4, slot5, slot6, slot7, slot8, vaction) ";
INSERTSQL += "VALUES (";
INSERTSQL += ":dentist_id, :appdate, :slot1, :slot2, :slot3, :slot4, :slot5, :slot6, :slot7, :slot8, :vaction )";
OracleConnection incon = new OracleConnection(connectionString);
OracleCommand cmd = new OracleCommand(INSERTSQL, incon);
// incon2.Open();
cmd.Parameters.Add(":dentist_id", Int64.Parse(GridView2.Rows[e.RowIndex].Cells[2].Text));
cmd.Parameters.Add(":APPDATE", Convert.ToDateTime(day.ToString()));
cmd.Parameters.Add(":slot1", "v");
cmd.Parameters.Add(":slot2", "v");
cmd.Parameters.Add(":slot3", "v");
cmd.Parameters.Add(":slot4", "v");
cmd.Parameters.Add(":slot5", "v");
cmd.Parameters.Add(":slot6", "v");
cmd.Parameters.Add(":slot7", "v");
cmd.Parameters.Add(":slot8", "v");
cmd.Parameters.Add(":vaction", "v");
cmd.BindByName = true;
int added2 = 0;
try
{
incon.Open();
added2 = cmd.ExecuteNonQuery();
adderror.Text = "New services added";
}
catch (Exception err)
{
bdreeor.Text = "Error inserting record. ";
bdreeor.Text += err.Message;
}
finally
{
incon.Close();
}
}
else if (!IsWeekend(day))
{
string INSERTSQL;
INSERTSQL = "INSERT INTO tempDentistSlot (";
INSERTSQL += "dentist_id, appdate, slot1, slot2, slot3, slot4, slot5, slot6, slot7, slot8, vaction) ";
INSERTSQL += "VALUES (";
INSERTSQL += ":dentist_id, :appdate, :slot1, :slot2, :slot3, :slot4, :slot5, :slot6, :slot7, :slot8, :vaction )";
OracleConnection incon2 = new OracleConnection(connectionString);
OracleCommand cmd3 = new OracleCommand(INSERTSQL, incon2);
//incon2.Open();
cmd3.Parameters.Add(":dentist_id", Int64.Parse(GridView2.Rows[e.RowIndex].Cells[2].Text));
cmd3.Parameters.Add(":APPDATE", Convert.ToDateTime(day.ToString()));
cmd3.Parameters.Add(":slot1", "");
cmd3.Parameters.Add(":slot2", "");
cmd3.Parameters.Add(":slot3", "");
cmd3.Parameters.Add(":slot4", "");
cmd3.Parameters.Add(":slot5", "");
cmd3.Parameters.Add(":slot6", "");
cmd3.Parameters.Add(":slot7", "");
cmd3.Parameters.Add(":slot8", "");
cmd3.Parameters.Add(":vaction", "");
cmd3.BindByName = true;
int added1 = 0;
try
{
incon2.Open();
added1 = cmd3.ExecuteNonQuery();
adderror.Text = "New services added";
}
catch (Exception err)
{
bdreeor.Text = "Error inserting record. ";
bdreeor.Text += err.Message;
}
finally
{
incon2.Close();
}
}
}
}
protected void GvList_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
GvHelper.DatagridSkinUpdate(e);
}
protected void gvAddData_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
//Page.ClientScript.RegisterStartupScript(this.GetType(), "focus", "<script>alert('" + (gvAddData.Rows[e.RowIndex].FindControl("HiddenField1") as HiddenField).Value + "')</script>");
string D_id = (gvAddData.Rows[e.RowIndex].FindControl("hfDetailId") as HiddenField).Value;
string c = "select Bill_id from pd_detail where Detail_id ='" + D_id + "'";
string bill_id = new SelectCommandBuilder().ExecuteDataTable(c).Rows[0][0].ToString();
string sql1 = "delete from pd_detail where Detail_id ='" + D_id + "'";
int count = new DeleteCommandBuilder().ExecuteNonQuery(sql1);
string dsql = "SELECT COUNT(*) AS COUNTa FROM pd_detail where Bill_id = '" + bill_id + "'";
int p = Convert.ToInt32(new SelectCommandBuilder().ExecuteScalar(dsql));
if (p == 0)
{
string sqlc = "delete from pd where Bill_id = '" + bill_id + "'";
count += new DeleteCommandBuilder().ExecuteNonQuery(sqlc);
}
if (count != 0)
{
string sql = @"SELECT a.Bill_id,
a.prd_Batch_id,
a.materials_id,
a.Qty,
a.Pch,
a.Detail_id,
a.yxq,
a.PDate,
a.Price,
a.is_can_sale,
materials.name,
materials.spec,
vendor.vendor_name,
materials.unit,
materials.name,
materials.select_code,
materials.texture,
materials.color,
a.hwh,
a.is_new,
total = Isnull((a.Price*a.Qty),0)
FROM pd_detail a,
materials,
vendor
WHERE ( materials.sccj_id *= vendor.vendor_id) and
( a.materials_id = materials.id ) and
a.bill_id ='" + ViewState["billId"].ToString().Trim() + "'";
DataTable dt = new SelectCommandBuilder().ExecuteDataTable(sql);
aList.Clear();
if (dt != null && dt.Rows.Count != 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
AddData a = new AddData()
{
id = dt.Rows[i]["Detail_id"].ToString(),
pm = dt.Rows[i]["name"].ToString(),
spec = dt.Rows[i]["spec"].ToString(),
cz = dt.Rows[i]["texture"].ToString(),
ys = dt.Rows[i]["color"].ToString(),
goods_unit = dt.Rows[i]["unit"].ToString(),
pch = dt.Rows[i]["pch"].ToString(),
hwh = dt.Rows[i]["hwh"].ToString(),
pdsl = Convert.ToDecimal(dt.Rows[i]["qty"]).ToString("0.##"),
Price = dt.Rows[i]["price"].ToString() == "" ? "0.00" : Convert.ToDecimal(dt.Rows[i]["price"]).ToString("0.##"),
total = dt.Rows[i]["price"].ToString() == "" ? "0.00" : (Convert.ToDecimal(dt.Rows[i]["qty"]) * Convert.ToDecimal(dt.Rows[i]["price"])).ToString("0.##"),
customer_name = dt.Rows[i]["vendor_name"].ToString()
};
aList.Add(a);
}
}
gvAddData.DataSource = aList;
gvAddData.DataBind();
}
else
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "focus", "<script>alert('删除失败!')</script>");
}
}
protected void gdvContacters_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
}