protected void gdvAccountCode_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
try
{
int current_index = int.Parse(ViewState["current_index"].ToString());
GridView gv = (GridView)gdvAccountType.Rows[current_index + 1].FindControl("gdvAccountCode");
Label lblAccountType_ID = (Label)gdvAccountType.Rows[current_index].FindControl("lblAccountType_ID");
TextBox txtEditAccountCode_Name = (TextBox)gv.Rows[e.RowIndex].FindControl("txtEditAccountCode_Name");
Label lblAccountCode_ID = (Label)gv.Rows[e.RowIndex].FindControl("lblAccountCode_ID");
if (!string.IsNullOrEmpty(txtEditAccountCode_Name.Text))
{
dbo_AccountCodeClass cycle = new dbo_AccountCodeClass()
{
Account_Type_ID = lblAccountType_ID.Text,
Account_Name = txtEditAccountCode_Name.Text,
Account_Code = lblAccountCode_ID.Text
};
bool success = false;
string User_ID = HttpContext.Current.Request.Cookies["User_ID"].Value;
success = dbo_AccountTypeDataClass.UpdateAccountCode_New(cycle, User_ID);
if (success)
{
gv.ShowFooter = false;
gv.EditIndex = -1;
List <dbo_AccountCodeClass> item_value = dbo_AccountTypeDataClass.GetAccountCode_New(lblAccountType_ID.Text);
gv.DataSource = item_value;
gv.DataBind();
}
System.Threading.Thread.Sleep(500);
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "SAMWAIT", "myApp.hidePleaseWait();", true);
}
else
{
System.Threading.Thread.Sleep(500);
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "SAMWAIT", "myApp.hidePleaseWait();", true);
Show("กรุณากรอกข้อมูลที่จำเป็นให้ครบถ้วน");
}
}
catch (Exception ex)
{
logger.Error(ex);
}
}
public static Boolean InsertAccountCode_New(dbo_AccountCodeClass clsAccountCode, string userName, string Account_ID)
{
/// Account_Type_ID Account_Code Account_Name
/// 01 0101 11223344556677
/// 01 0102 11223344556677
/// 02 0202 11223344556677
SqlConnection connection = SAMDataClass.GetConnection();
string insertProcedure = "InsertAccountType";
SqlCommand insertCommand = new SqlCommand(insertProcedure, connection);
insertCommand.CommandType = CommandType.StoredProcedure;
insertCommand.Parameters.AddWithValue("@Mode", "InsAccountCode");
insertCommand.Parameters.AddWithValue("@Account_Type_ID", clsAccountCode.Account_Type_ID);
insertCommand.Parameters.AddWithValue("@InsertParam", clsAccountCode.Account_Name);
insertCommand.Parameters.AddWithValue("@InsertBy", userName);
insertCommand.Parameters.AddWithValue("@Account_ID", Account_ID);
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();
}
}
