protected void GridView_MemberAvgift_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridView_MemberAvgift.PageIndex = e.NewPageIndex;
GridView_MemberAvgift.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (Session["UserName"] == null)
{
//Response.Write("<script LANGUAGE='JavaScript' >alert('You are not logged in, Please login to see your side!);href='~/'</script>",true );
ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('You are not logged in, Please login to see your side.');window.location ='Login.aspx'", true);
return;
}
V_UserName = Session["UserName"].ToString();
//V_MemberID = Session["UserID"].ToString();
System.Configuration.Configuration rootWebConfig = System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration("/MyWebSiteRoot");
System.Configuration.ConnectionStringSettings connStringSQL;
connStringSQL = rootWebConfig.ConnectionStrings.ConnectionStrings["DefaultConnection"];
string MyconnStr = null;
if (rootWebConfig.ConnectionStrings.ConnectionStrings.Count > 0)
{
if (connStringSQL != null)
{
if (connStringSQL.ProviderName == "System.Data.SqlClient")
{
MyconnStr = connStringSQL.ConnectionString;
SqlConnection conn = new SqlConnection(@"" + MyconnStr + "");
conn.Open();
SqlCommand MyCommand;
string MySqlString = null;
SqlDataReader dataReader;
MySqlString = "Select * FROM [NRB_MMS].[dbo].[Member] where Email_UserName= '******'";
MyCommand = new SqlCommand(MySqlString, conn);
//MyCommand.Parameters.AddWithValue("@user", TextBox_UserName.Text);
dataReader = MyCommand.ExecuteReader();
if (dataReader.HasRows)
{
//MemberID , FAMILYID , PERS_NR ,FAMILYNAME ,MemberFNAME,MemberMNAME,MemberLNAME
while (dataReader.Read())
{
TextBox_MemberID.Text = dataReader["MemberID"].ToString();
V_MemberID = TextBox_MemberID.Text;
TextBox_FAMILYID.Text = dataReader["FAMILYID"].ToString();
TextBox_PERS_NR.Text = dataReader["PERS_NR"].ToString();
TextBox_FAMILYNAME.Text = dataReader["FAMILYNAME"].ToString();
TextBox_MemberFNAME.Text = dataReader["MemberFNAME"].ToString();
TextBox_MemberMNAME.Text = dataReader["MemberMNAME"].ToString();
TextBox_MemberLNAME.Text = dataReader["MemberLNAME"].ToString();
}
//Session["UserName"] = V_UserName.ToString();
//ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('Login successful!');window.location ='MinaSida.aspx';", true);
}
dataReader.Close();
MyCommand.Dispose();
SqlCommand MyCommandTr;
string MySqlStringTr = null;
SqlDataReader dataReaderTr;
//Select NRB_MMS..TRANSACTION.TRANSID , NRB_MMS..TRANSACTION.MemberID ,
//NRB_MMS..Member.MemberFNAME + NRB_MMS..Member.MemberMNAME + NRB_MMS..Member.MemberLNAME as MemberNAME,NRB_MMS..MemberLOGIN.USERNAME ,
//NRB_MMS..TRANSACTION.TRANSDATE ,NRB_MMS..TRANSACTION.FORMONTH ,NRB_MMS..TRANSACTION.FORYEAR , NRB_MMS..TRANSACTION.TRANSAMT
//FROM NRB_MMS..TRANSACTION
//inner join
//NRB_MMS..Member
//on NRB_MMS..TRANSACTION.MemberID=NRB_MMS..Member.MemberID
//inner join
//NRB_MMS..MemberLOGIN
//on NRB_MMS..TRANSACTION.MemberID=NRB_MMS..MemberLOGIN.MemberID
//MySqlStringTr = "Select NRB_MMS..TRANSACTION.TRANSID , NRB_MMS..TRANSACTION.MemberID ," +
// "NRB_MMS..Member.MemberFNAME + NRB_MMS..Member.MemberMNAME + NRB_MMS..Member.MemberLNAME as MemberNAME,NRB_MMS..MemberLOGIN.USERNAME ," +
// "NRB_MMS..TRANSACTION.TRANSDATE ,NRB_MMS..TRANSACTION.FORMONTH ,NRB_MMS..TRANSACTION.FORYEAR , NRB_MMS..TRANSACTION.TRANSAMT " +
// " FROM NRB_MMS..TRANSACTION" +
// " inner join " +
// " NRB_MMS..Member" +
// " on NRB_MMS..TRANSACTION.MemberID=NRB_MMS..Member.MemberID" +
// " inner join" +
// " NRB_MMS..MemberLOGIN "+
// " on NRB_MMS..TRANSACTION.MemberID=NRB_MMS..MemberLOGIN.MemberID where NRB_MMS..TRANSACTION.MemberID= " + V_MemberID + "";
//MySqlStringTr = "Select Tr.TRANSID , Tr.MemberID ,NRB_MMS..Member.MemberFNAME +' ' + NRB_MMS..Member.MemberMNAME+ ' ' + NRB_MMS..Member.MemberLNAME as MemberNAME,NRB_MMS..MemberLOGIN.USERNAME ," +
// " Tr.TRANSDATE ,Tr.TRANTYPE ,Tr.SDESC,Tr.MONTHNR ,Tr.FORMONTH ,Tr.FORYEAR , " +
// " Tr.TRANSAMT, BALANCE= Tr.TRANSAMT+ COALESCE( " +
// " (SELECT SUM(TRANSAMT)" +
// " FROM NRB_MMS..TRANSACTION AS i " +
// " WHERE i.MONTHNR < Tr.MONTHNR and i.MemberID= " + V_MemberID + "), 0 ) " +
// " FROM NRB_MMS..TRANSACTION Tr inner join " +
// " NRB_MMS..Member " +
// " on " +
// " Tr.MemberID=NRB_MMS..Member.MemberID " +
// " inner join NRB_MMS..MemberLOGIN " +
// " on Tr.MemberID=NRB_MMS..MemberLOGIN.MemberID where Tr.MemberID= " + V_MemberID + "";
MySqlStringTr = "SELECT ROW_NUMBER() OVER(ORDER BY M.MemberID ASC) AS ROWNR, M.MemberID,M.FAMILYID,M.PERS_NR,M.MemberFNAME,M.MemberLNAME,M.[ADDRESS],M.POSTNR,M.STAD," +
" M.MemberAVGIFT, M.[STATUS],M.EMAIL_USERNAME,M.PHONE_NR,Tr.FORMONTH,Tr.FORYEAR,Tr.TRANSAMT," +
" BALANCE= Tr.TRANSAMT+ COALESCE( " +
" (SELECT SUM(TRANSAMT)" +
" FROM [NRB_MMS].[dbo].[TRANSACTION] AS i " +
" WHERE i.TRANSID < Tr.TRANSID and SHORT_ACC_DESC='A' and i.MemberID= " + V_MemberID + "), 0 ) " +
" FROM [NRB_MMS].[dbo].[TRANSACTION] Tr inner join " +
" NRB_MMS..Member M " +
" on " +
" Tr.MemberID=M.MemberID " +
" where Tr.MemberID= " + V_MemberID + " and SHORT_ACC_DESC='A'";
MyCommandTr = new SqlCommand(MySqlStringTr, conn);
//MyCommand.Parameters.AddWithValue("@user", TextBox_UserName.Text);
dataReaderTr = MyCommandTr.ExecuteReader();
if (dataReaderTr.HasRows)
{
//MemberID , FAMILYID , PERS_NR ,FAMILYNAME ,MemberFNAME,MemberMNAME,MemberLNAME
GridView_MemberAvgift.DataSource = dataReaderTr;
GridView_MemberAvgift.DataBind();
//Session["UserName"] = V_UserName.ToString();
//ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('Login successful!');window.location ='MinaSida.aspx';", true);
}
else
{
Response.Write("<script LANGUAGE='JavaScript' >alert('Login Failed!')</script>");
}
dataReaderTr.Close();
MyCommandTr.Dispose();
}
}
}
}
catch (Exception ex)
{
Response.Write("<script LANGUAGE='JavaScript' >alert('Login Failed!')</script>");
throw new ApplicationException(ex.Message.ToString());
}
}
protected void GridView_MemberAvgift_RowEditing(object sender, GridViewEditEventArgs e)
{
GridView_MemberAvgift.EditIndex = e.NewEditIndex;
GridView_MemberAvgift.DataBind();// your gridview binding function
//Response.Redirect("~/Account/MemberEdit.aspx");
}
