protected void Button1_Click(object sender, EventArgs e)
{
ClArchiveAgreeTitle cl = new ClArchiveAgreeTitle();
cl = Data;
int i = 0;
if (CSharp.PublicFunction.ModeInsert(lblArchiveAgreeTitle.Text))
{
i = ArchiveAgreeTitleClass.insert(cl);
if (i > 0)
{
InsertArchiv(i);
}
}
else
{
i = ArchiveAgreeTitleClass.Update(cl);
}
if (i > 0)
{
BindGrid();
}
else
{
CSharp.Utility.ShowMsg(Page, CSharp.ProPertyData.MsgType.warning, "خطا در ثبت");
}
}
public void BindDD()
{
ClArchiveAgreeTitle cl = new ClArchiveAgreeTitle();
cl.AgreeID = Agreement;
ddarchive.DataSource = ArchiveAgreeTitleClass.GetList(cl);
ddarchive.DataTextField = "AgreeName";
ddarchive.DataValueField = "tbl_ArchiveAgreeTitle";
ddarchive.DataBind();
}
private void BindGrid()
{
ClArchiveAgreeTitle cl = new ClArchiveAgreeTitle();
cl.AgreeID = Convert.ToInt32(lblAgrement.Text);
DataSet ds = ArchiveAgreeTitleClass.GetList(cl);
DataView dv = new DataView(ds.Tables[0]);
if (ViewState["AreaID "] == null)
{
ViewState["AreaID"] = "tbl_ArchiveAgreeTitle Desc";
}
dv.Sort = Securenamespace.SecureData.CheckSecurity(ViewState["AreaID"].ToString()).ToString();
GridView1.DataSource = dv;
GridView1.DataBind();
}
//---------------------------------------------------------------------------------------------------------
public static DataSet GetList(ClArchiveAgreeTitle c)
{
SqlCommand cmd = new SqlCommand("PRC_ArchiveAgreeTitle_GetList", cnn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("UserIDLog", SqlDbType.NVarChar)).Value = CSharp.PublicFunction.GetUserID();
cmd.Parameters.Add(new SqlParameter("IpLog", SqlDbType.NVarChar)).Value = CSharp.PublicFunction.GetIPAddress();
cmd.Parameters.Add(new SqlParameter("OSLog", SqlDbType.NVarChar)).Value = CSharp.PublicFunction.GetOS();
cmd.Parameters.Add(new SqlParameter("OSVerLog", SqlDbType.NVarChar)).Value = CSharp.PublicFunction.GetBrowser() + CSharp.PublicFunction.GetBrowserVersion();
cmd.Parameters.Add(new SqlParameter("URLLog", SqlDbType.NVarChar)).Value = CSharp.PublicFunction.GetURL();
cmd.Parameters.Add(new SqlParameter("tbl_ArchiveAgreeTitle", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.tbl_ArchiveAgreeTitle);
cmd.Parameters.Add(new SqlParameter("FromDate", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.FromDate);
cmd.Parameters.Add(new SqlParameter("ToDate", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.ToDate);
cmd.Parameters.Add(new SqlParameter("Title", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.Title);
cmd.Parameters.Add(new SqlParameter("IsDelete", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.IsDelete);
cmd.Parameters.Add(new SqlParameter("AgreeID", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.AgreeID);
SqlParameter prmResult = new SqlParameter("Result", SqlDbType.Int);
prmResult.Direction = ParameterDirection.Output;
cmd.Parameters.Add(prmResult);
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(cmd);
try
{
cnn.Open();
da.Fill(ds);
return(ds);
}
catch (Exception ex)
{
return(null);
}
finally
{
cnn.Close();
}
}
public static int insert(ClArchiveAgreeTitle c)
{
SqlCommand cmd = new SqlCommand("PRC_ArchiveAgreeTitle_Insert", cnn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("UserIDLog", SqlDbType.NVarChar)).Value = CSharp.PublicFunction.GetUserID();
cmd.Parameters.Add(new SqlParameter("IpLog", SqlDbType.NVarChar)).Value = CSharp.PublicFunction.GetIPAddress();
cmd.Parameters.Add(new SqlParameter("OSLog", SqlDbType.NVarChar)).Value = CSharp.PublicFunction.GetOS();
cmd.Parameters.Add(new SqlParameter("OSVerLog", SqlDbType.NVarChar)).Value = CSharp.PublicFunction.GetBrowser() + CSharp.PublicFunction.GetBrowserVersion();
cmd.Parameters.Add(new SqlParameter("URLLog", SqlDbType.NVarChar)).Value = CSharp.PublicFunction.GetURL();
cmd.Parameters.Add(new SqlParameter("FromDate", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.FromDate);
cmd.Parameters.Add(new SqlParameter("ToDate", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.ToDate);
cmd.Parameters.Add(new SqlParameter("Title", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.Title);
cmd.Parameters.Add(new SqlParameter("IsDelete", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.IsDelete);
cmd.Parameters.Add(new SqlParameter("AgreeID", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.AgreeID);
cmd.Parameters.Add(new SqlParameter("SoratJalase", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.SoratJalase);
cmd.Parameters.Add(new SqlParameter("SoratJalase_Manfi", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.SoratJalase_Manfi);
SqlParameter prmResult = new SqlParameter("Result", SqlDbType.Int);
prmResult.Direction = ParameterDirection.Output;
cmd.Parameters.Add(prmResult);
try
{
cnn.Open();
cmd.ExecuteNonQuery();
return(Convert.ToInt32(prmResult.Value));
}
catch (Exception ex)
{
return(0);
}
finally
{
cnn.Close();
}
}
