protected void btnSaveCL_Click(object sender, EventArgs e)
{
Credit_Term_Model mdlCL = new Credit_Term_Model();
mdlCL.credit_term = txtCreditTerm.Text.Trim();
mdlCL.term_desc = txtDescription.Text.Trim();
mdlCL.days_to_pay = txtDays.Text.Trim();
if (Session["clMode"].ToString() == "Save")
{
Credit_Term.Save(oCon, mdlCL);
}
else if (Session["clMode"].ToString() == "Update")
{
mdlCL.credit_term = Session["credit_term"].ToString();
Credit_Term.Update(oCon, mdlCL);
}
clearCL();
getCreditTerm();
}
public List <Credit_Term_Model> getCreditTerms()
{
StringBuilder sQuery = new StringBuilder();
sQuery.Append(@"SELECT [credit_term]
,[term_desc]
FROM a_Credit_Term
");
var lmodel = new List <Credit_Term_Model>();
connection.Open();
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = connection;
cmd.CommandText = sQuery.ToString();
cmd.CommandType = CommandType.Text;
var oreader = cmd.ExecuteReader();
while (oreader.Read())
{
Credit_Term_Model oModel = new Credit_Term_Model
{
credit_term = (string)oreader["credit_term"],
term_desc = (string)oreader["term_desc"]
};
lmodel.Add(oModel);
}
cmd.Dispose();
}
connection.Close();
return(lmodel);
}
public static bool Save(SqlConnection connection, Credit_Term_Model model)
{
bool returnValue = true;
StringBuilder sQuery = new StringBuilder();
var GUID = SQL_Transact.GenerateGUID();
SQL_Transact.BeginTransaction(connection, GUID);
sQuery.Append(@"INSERT INTO a_Credit_Term
(credit_term
,term_desc
,days_to_pay)
VALUES
(@credit_term
,@term_desc
,@days_to_pay)" );
using (SqlCommand cmd = new SqlCommand())
{
try
{
cmd.Connection = connection;
cmd.CommandText = sQuery.ToString();
cmd.CommandType = CommandType.Text;
SqlParameter parm2 = new SqlParameter
{
ParameterName = "@credit_term",
SqlDbType = SqlDbType.NVarChar,
Value = model.credit_term
};
cmd.Parameters.Add(parm2);
SqlParameter parm3 = new SqlParameter
{
ParameterName = "@term_desc",
SqlDbType = SqlDbType.NVarChar,
Value = model.term_desc
};
cmd.Parameters.Add(parm3);
SqlParameter parm4 = new SqlParameter
{
ParameterName = "@days_to_pay",
SqlDbType = SqlDbType.NVarChar,
Value = model.days_to_pay
};
cmd.Parameters.Add(parm4);
if (cmd.ExecuteNonQuery() >= 1)
{
returnValue = true;
cmd.Dispose();
cmd.Parameters.Clear();
SQL_Transact.CommitTransaction(connection, GUID);
}
}
catch
{
cmd.Dispose();
cmd.Parameters.Clear();
SQL_Transact.RollbackTransaction(connection, GUID);
}
}
return(returnValue);
}
