public static Boolean UpdateItemValue_New(dbo_ItemValueClass clsItemValue, string userName)
{
SqlConnection connection = SAMDataClass.GetConnection();
string insertProcedure = "UpdateItemValue";
SqlCommand insertCommand = new SqlCommand(insertProcedure, connection);
insertCommand.CommandType = CommandType.StoredProcedure;
insertCommand.Parameters.AddWithValue("@Mode", "UpdItemValue");
insertCommand.Parameters.AddWithValue("@Item_Value_ID", clsItemValue.Item_Value_ID);
insertCommand.Parameters.AddWithValue("@UpdateBY", userName);
insertCommand.Parameters.AddWithValue("@UpdateParam", clsItemValue.Item_Value_Name);
try
{
connection.Open();
int count = insertCommand.ExecuteNonQuery();
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (SqlException ex)
{
logger.Error(ex.Message);
return(false);
}
finally
{
connection.Close();
}
}
protected void gdvItemValue_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
int current_index = int.Parse(ViewState["current_index"].ToString());
GridView gv = (GridView)gdvItem.Rows[current_index + 1].FindControl("gdvItemValue");
Label lblItem_ID = (Label)gdvItem.Rows[current_index].FindControl("lblItem_ID");
TextBox txtEditItemValue_Name = (TextBox)gv.Rows[e.RowIndex].FindControl("txtEditItemValue_Name");
Label lblItemValue_ID = (Label)gv.Rows[e.RowIndex].FindControl("lblItemValue_ID");
if (!string.IsNullOrEmpty(txtEditItemValue_Name.Text))
{
dbo_ItemValueClass cycle = new dbo_ItemValueClass()
{
Item_ID = lblItem_ID.Text,
Item_Value_Name = txtEditItemValue_Name.Text,
Item_Value_ID = lblItemValue_ID.Text
};
bool success = false;
string User_ID = HttpContext.Current.Request.Cookies["User_ID"].Value;
success = dbo_ItemDataClass.UpdateItemValue_New(cycle, User_ID);
if (success)
{
gv.ShowFooter = false;
gv.EditIndex = -1;
//List<dbo_ItemValueClass> item_value = dbo_ItemDataClass.GetItemValue_New(lblItemValue_ID.Text);
List <dbo_ItemValueClass> item_value = dbo_ItemDataClass.GetItemValue_New(lblItem_ID.Text);
gv.DataSource = item_value;
gv.DataBind();
//gv.Visible = true;
}
}
else
{
System.Threading.Thread.Sleep(500);
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "SAMWAIT", "myApp.hidePleaseWait();", true);
Show("กรุณากรอกข้อมูลที่จำเป็นให้ครบถ้วน");
}
System.Threading.Thread.Sleep(500);
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "SAMWAIT", "myApp.hidePleaseWait();", true);
}
