public int Insert_client(clientdto client, clientRegisterdto clientRegister, UserLoginDTO ulDto)
{
return dangky.Register(client, clientRegister, ulDto);
}
public int Register(clientdto client, clientRegisterdto clientRegister, UserLoginDTO ulDto)
{
SqlTransaction tran = ConnectionData._MyConnection.BeginTransaction();
try
{
string sql = "insert into tblClient (clientName,address,email,phone,status)" +
"values(@clientName,@address,@email,@phone,@status) select @@identity";
SqlCommand cmd = new SqlCommand(sql, ConnectionData._MyConnection);
cmd.Transaction = tran;
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@clientName", SqlDbType.NVarChar).Value = client.clientName;
cmd.Parameters.Add("@address", SqlDbType.NVarChar).Value = client.address;
cmd.Parameters.Add("@email", SqlDbType.NVarChar).Value = client.email;
cmd.Parameters.Add("@phone", SqlDbType.VarChar).Value = client.phone;
cmd.Parameters.Add("@status", SqlDbType.Int).Value = -1;
object id = cmd.ExecuteScalar();
clientRegister.clientId = Convert.ToInt32(id);
sql = @"set dateformat dmy INSERT INTO [tblClientRegister]
([clientId]
,[packageId]
,[limitId]
,[subAccontCount]
,[emailCount]
,[totalFee]
,[registerType]
,[packageTimeId]
,[from]
,[to]
,[lastRegisterFrom]
,[lastRegisterTo]
,[lastRegisterFee]
,[lastRegisterFeeRemain]
,[registerTime]
,[registerDate])
VALUES
(@clientId
,@packageId
,@limitId
,@subAccontCount
,@emailCount
,@totalFee
,0
,@packageTimeId
,@from
,@to
,null ,null ,0 ,0 ,getdate() ,getdate()) select @@identity";
cmd = new SqlCommand(sql, ConnectionData._MyConnection);
cmd.Transaction = tran;
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@clientId", SqlDbType.Int).Value = clientRegister.clientId;
cmd.Parameters.Add("@packageId", SqlDbType.Int).Value = clientRegister.packageId;
cmd.Parameters.Add("@limitId", SqlDbType.Int).Value = clientRegister.limitId;
cmd.Parameters.Add("@subAccontCount", SqlDbType.Int).Value = clientRegister.subAccontCount;
cmd.Parameters.Add("@emailCount", SqlDbType.Int).Value = clientRegister.emailCount;
cmd.Parameters.Add("@totalFee", SqlDbType.Float).Value = clientRegister.totalFee;
cmd.Parameters.Add("@packageTimeId", SqlDbType.Int).Value = clientRegister.packageTimeId;
cmd.Parameters.Add("@from", SqlDbType.VarChar, 12).Value = clientRegister.from.ToString("dd/MM/yyyy");
cmd.Parameters.Add("@to", SqlDbType.VarChar, 12).Value = clientRegister.to.ToString("dd/MM/yyyy");
object registerid = cmd.ExecuteScalar();
sql = "select * from tblPackageFunction where packageid=" + clientRegister.packageId;
cmd = new SqlCommand(sql, ConnectionData._MyConnection);
cmd.Transaction = tran;
cmd.CommandType = CommandType.Text;
DataTable T = new DataTable();
SqlDataAdapter data = new SqlDataAdapter(cmd);
data.Fill(T);
sql = "insert into tblClientFunction(registerId, clientId, functionId) values(@registerId, @clientId, @functionId)";
if (T != null)
foreach (DataRow r in T.Rows)
{
cmd = new SqlCommand(sql, ConnectionData._MyConnection);
cmd.Transaction = tran;
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@functionId", SqlDbType.Int).Value = r["functionId"];
cmd.Parameters.Add("@clientId", SqlDbType.Int).Value = clientRegister.clientId;
cmd.Parameters.Add("@registerId", SqlDbType.Int).Value = registerid;
cmd.ExecuteNonQuery();
}
sql = "INSERT INTO tblUserLogin(Username, Password, UserType,Is_Block,DepartmentId) " +
"VALUES(@Email, @Password, @UserType,@Is_Block,@UserType) select @@identity";
cmd = new SqlCommand(sql, ConnectionData._MyConnection);
cmd.Transaction = tran;
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@Email", SqlDbType.NVarChar).Value = ulDto.Email;
cmd.Parameters.Add("@Password", SqlDbType.NVarChar).Value = ulDto.Password;
cmd.Parameters.Add("@UserType", SqlDbType.Int).Value = ulDto.UserType;
cmd.Parameters.Add("@Is_Block", SqlDbType.Bit).Value = ulDto.Is_Block;
id = cmd.ExecuteScalar();
sql = "set dateformat dmy update tblClient set userid = @userid, registerid=@registerid, activedate=getdate(), expiredate='" + clientRegister.to.ToString("dd/MM/yyyy") + "' where clientid=@clientid";
cmd = new SqlCommand(sql, ConnectionData._MyConnection);
cmd.Transaction = tran;
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@userid", SqlDbType.Int).Value = id;
cmd.Parameters.Add("@clientid", SqlDbType.Int).Value = clientRegister.clientId;
cmd.Parameters.Add("@registerid", SqlDbType.Int).Value = registerid;
int i=cmd.ExecuteNonQuery();
tran.Commit();
tran.Dispose();
return i;
}
catch
{
tran.Rollback();
}
return 0;
}
protected void btnRegis_Click(object sender, EventArgs e)
{
dk = new RegisterBUS();
string mess = check();
if (mess == "")
{
clientdto cliendto = getclient();
ConnectionData.OpenMyConnection();
clientRegisterdto clientRegister = new clientRegisterdto();
clientRegister.from = DateTime.Now;
clientRegister.to = DateTime.Now.AddDays(Convert.ToInt32(DropDownList1.SelectedValue.ToString()) * 30);
string idpackage = Request.QueryString["packageId"].ToString();
int id = 0;
Int32.TryParse(idpackage, out id);
clientRegister.packageId = id;
DataTable T = dk.GetPackageById(id);
if (T != null && T.Rows.Count > 0)
{
clientRegister.totalFee = Convert.ToDouble(T.Rows[0]["cost"]);
clientRegister.subAccontCount = Convert.ToInt32(T.Rows[0]["subAccontCount"]);
clientRegister.emailCount = Convert.ToInt32(T.Rows[0]["emailCount"]);
clientRegister.limitId = Convert.ToInt32(T.Rows[0]["limitId"]);
}
object temp = dk.Getpackagetime();
Int32.TryParse(temp + "", out id);
clientRegister.packageTimeId = id;
UserLoginDTO ulDto = new UserLoginDTO();
ulDto.Username = txtUserName.Text;
ulDto.Password = GetMd5Hash(txtPass.Text);
ulDto.Email = txtEmail.Text;
ulDto.Is_Block = false;
ulDto.UserType = 2;
if (dk.Insert_client(cliendto, clientRegister, ulDto) > 0)
{
SmtpClient SmtpServer = new SmtpClient();
SmtpServer.Credentials = new System.Net.NetworkCredential("AKIAIGXHHO72FHXGCPFQ", "Ara8HV/kcfjNU+rqrTpJBAAjs/OsD1xEykLsuguqpe1Z");
SmtpServer.Port = 25;
SmtpServer.Host = "email-smtp.us-east-1.amazonaws.com";
SmtpServer.EnableSsl = true;
MailMessage mail = new MailMessage();
String[] addr = txtEmail.Text.Split(' ');
//mail.From = new MailAddress("*****@*****.**",
//" Hệ Thống FA MAIL ", System.Text.Encoding.UTF8);
mail.From = new MailAddress(ConfigurationManager.AppSettings["SystemOutEmail"].ToString(), "Hệ Thống FA MAIL ", System.Text.Encoding.UTF8);
Byte i;
for (i = 0; i < addr.Length; i++)
mail.To.Add(addr[i]);
mail.Subject = "Thư xác nhận";
mail.IsBodyHtml = true;
mail.Body += "<html> <body><table class='auto-style1'> <tr><td>Chào " + txtUserName.Text + " Thân mến! </td></tr><tr><td>Chúc mừng bạn đã đăng ký thành công gói " + lblTenGoi.Text + " của FA Mail </td></tr><tr><td>Thông tin tài khoản đăng nhập</td></tr><tr><td> Email đăng nhập: '" + txtEmail.Text + "'</td></tr><tr><td>Link tới trang login: http://emailmarketing.1onlinebusinesssystem.com/webapp/page/backend/login.aspx </td></tr><tr> <td> Trân trọng,</td</tr> <tr> <td>Customer services</td</tr><tr><td> Email:[email protected]</td></tr></table></body> ";
mail.Body += "</html>";
mail.DeliveryNotificationOptions = DeliveryNotificationOptions.OnFailure;
mail.ReplyTo = new MailAddress(txtEmail.Text);
SmtpServer.Send(mail);
SmtpClient SmtpServer1 = new SmtpClient();
SmtpServer1.Credentials = new System.Net.NetworkCredential("AKIAIGXHHO72FHXGCPFQ", "Ara8HV/kcfjNU+rqrTpJBAAjs/OsD1xEykLsuguqpe1Z");
SmtpServer1.Port = 25;
SmtpServer1.Host = "email-smtp.us-east-1.amazonaws.com";
SmtpServer1.EnableSsl = true;
MailMessage mail1 = new MailMessage();
String[] addr1 = txtmail.Text.Split(' ');
//mail.From = new MailAddress("*****@*****.**",
//" Hệ Thống FA MAIL ", System.Text.Encoding.UTF8);
mail1.From = new MailAddress(ConfigurationManager.AppSettings["SystemOutEmail"].ToString(), "Hệ Thống FA MAIL ", System.Text.Encoding.UTF8);
Byte a;
for (a = 0; a < addr1.Length; a++)
mail1.To.Add(addr1[a]);
mail1.Subject = "Thong tin khachs hang dang ky";
mail1.IsBodyHtml = true;
mail1.Body += "<html> <body><table class='auto-style1'> <tr><td>Chào " + txtUserName.Text + " Thân mến! </td></tr><tr><td>Khách hàng đăng ký thành công gói " + lblTenGoi.Text + " của FA Mail </td></tr><tr><td>Thông tin tài khoản đăng nhập</td></tr><tr><td> Email đăng nhập: '" + txtEmail.Text + "'</td></tr><tr><td>Ngày đăng ký: "+ lbthoigian.Text +"</td></tr><tr> <td> Trân trọng,</td</tr> <tr> <td>Customer services</td</tr><tr><td> Email:[email protected]</td></tr></table></body> ";
mail1.Body += "</html>";
mail1.DeliveryNotificationOptions = DeliveryNotificationOptions.OnFailure;
mail1.ReplyTo = new MailAddress(ConfigurationManager.AppSettings["SysteminEmail"].ToString());
SmtpServer1.Send(mail1);
//Response.Redirect("success.aspx?id=" + idpackage);
}
}
else
{
lblError.Text = mess;
lblError.ForeColor = System.Drawing.Color.Red;
}
Session["username"] = txtUserName.Text;
}
