public FaultReason(IEnumerable<FaultReasonText> translations)
{
if (translations == null)
{
throw DiagnosticUtility.ExceptionUtility.ThrowHelperError(new ArgumentNullException("translations"));
}
int num = 0;
using (IEnumerator<FaultReasonText> enumerator = translations.GetEnumerator())
{
while (enumerator.MoveNext())
{
FaultReasonText current = enumerator.Current;
num++;
}
}
if (num == 0)
{
throw DiagnosticUtility.ExceptionUtility.ThrowHelperError(new ArgumentException(System.ServiceModel.SR.GetString("AtLeastOneFaultReasonMustBeSpecified"), "translations"));
}
FaultReasonText[] textArray = new FaultReasonText[num];
int num2 = 0;
foreach (FaultReasonText text in translations)
{
if (text == null)
{
throw DiagnosticUtility.ExceptionUtility.ThrowHelperArgument("translations", System.ServiceModel.SR.GetString("NoNullTranslations"));
}
textArray[num2++] = text;
}
this.Init(textArray);
}
public FaultReason(IEnumerable <FaultReasonText> translations)
{
if (translations == null)
{
throw DiagnosticUtility.ExceptionUtility.ThrowHelperError(new ArgumentNullException(nameof(translations)));
}
int count = 0;
foreach (FaultReasonText faultReasonText in translations)
{
count++;
}
if (count == 0)
{
throw DiagnosticUtility.ExceptionUtility.ThrowHelperError(new ArgumentException(SR.AtLeastOneFaultReasonMustBeSpecified, "translations"));
}
FaultReasonText[] array = new FaultReasonText[count];
int index = 0;
foreach (FaultReasonText faultReasonText in translations)
{
array[index++] = faultReasonText ?? throw DiagnosticUtility.ExceptionUtility.ThrowHelperArgument("translations", SR.NoNullTranslations);
}
Init(array);
}
public FaultReason(IEnumerable <FaultReasonText> translations)
{
if (translations == null)
{
throw DiagnosticUtility.ExceptionUtility.ThrowHelperError(new ArgumentNullException("translations"));
}
int num = 0;
using (IEnumerator <FaultReasonText> enumerator = translations.GetEnumerator())
{
while (enumerator.MoveNext())
{
FaultReasonText current = enumerator.Current;
num++;
}
}
if (num == 0)
{
throw DiagnosticUtility.ExceptionUtility.ThrowHelperError(new ArgumentException(System.ServiceModel.SR.GetString("AtLeastOneFaultReasonMustBeSpecified"), "translations"));
}
FaultReasonText[] textArray = new FaultReasonText[num];
int num2 = 0;
foreach (FaultReasonText text in translations)
{
if (text == null)
{
throw DiagnosticUtility.ExceptionUtility.ThrowHelperArgument("translations", System.ServiceModel.SR.GetString("NoNullTranslations"));
}
textArray[num2++] = text;
}
this.Init(textArray);
}
public FaultReason(FaultReasonText translation)
{
if (translation == null)
throw DiagnosticUtility.ExceptionUtility.ThrowHelperArgumentNull("translation");
Init(translation);
}
public FaultReason(FaultReasonText translation)
{
if (translation == null)
{
throw DiagnosticUtility.ExceptionUtility.ThrowHelperArgumentNull("translation");
}
this.Init(translation);
}
public FaultReason(FaultReasonText translation)
{
if (translation == null)
{
throw new ArgumentNullException("translation");
}
trans.Add(translation);
}
internal static FaultReason Construct(FaultException.FaultReasonData[] nodes)
{
FaultReasonText[] translations = new FaultReasonText[nodes.Length];
for (int i = 0; i < nodes.Length; i++)
{
translations[i] = new FaultReasonText(nodes[i].text, nodes[i].xmlLang);
}
return(new FaultReason(translations));
}
internal static FaultReason Construct(FaultReasonData[] nodes)
{
FaultReasonText[] reasons = new FaultReasonText[nodes.Length];
for (int i = 0; i < nodes.Length; i++)
{
reasons[i] = new FaultReasonText(nodes[i]._text, nodes[i]._xmlLang);
}
return(new FaultReason(reasons));
}
static void Main(string[] args)
{
FaultCode code = FaultCode.CreateSenderFaultCode("calcuError", "http://www.artech.com");
FaultReasonText reasonText1 = new FaultReasonText("Divided by zero!", "en-US");
FaultReasonText reasonText2 = new FaultReasonText("试图除以零!", "zh-CN");
FaultReason reason = new FaultReason(new FaultReasonText[] { reasonText1, reasonText2 });
MessageFault fault = MessageFault.CreateFault(code, reason);
string action = "http://www.artech.com/divideFault";
using (Message message = Message.CreateMessage(MessageVersion.Default, fault, action))
{
WriteMessage(message, "message.xml");
}
}
public int Login(string username, string password)
{
try
{
if (username == "" || password == "")
{
return 0;
}
string query = "SELECT * FROM users WHERE username = '******' AND password = '******'";
SqlConnection cn = new SqlConnection();
cn.ConnectionString = "Data Source=mavi-PC;Initial Catalog=cnweb;Integrated Security=True";
cn.Open();
SqlCommand sql = new SqlCommand(query, cn);
SqlDataAdapter adt = new SqlDataAdapter(sql);
DataSet ds = new DataSet();
adt.Fill(ds);
int rows = ds.Tables[0].Rows.Count;
cn.Close();
if (rows > 0)
{
return 1;
}
else
{
return 0;
}
}
catch (PisNotFoundException exp)
{
TrackedFault tf = new TrackedFault(
Guid.NewGuid(),
exp.Message,
DateTime.Now);
throw new FaultException<TrackedFault>(
tf,
new FaultReason("PisNotFoundException"),
FaultCode.CreateReceiverFaultCode(new FaultCode("Login")));
}
catch (Exception exp)
{
FaultReasonText reason = new FaultReasonText(exp.Message);
throw new FaultException(new FaultReason(reason), FaultCode.CreateReceiverFaultCode(new FaultCode("Login")));
}
}
internal static ProtocolException ReceiveShutdownReturnedNonNull(Message message)
{
if (message.IsFault)
{
try
{
FaultReasonText matchingTranslation = MessageFault.CreateFault(message, 0x10000).Reason.GetMatchingTranslation(CultureInfo.CurrentCulture);
return(new ProtocolException(System.ServiceModel.SR.GetString("ReceiveShutdownReturnedFault", new object[] { matchingTranslation.Text })));
}
catch (QuotaExceededException)
{
return(new ProtocolException(System.ServiceModel.SR.GetString("ReceiveShutdownReturnedLargeFault", new object[] { message.Headers.Action })));
}
}
return(new ProtocolException(System.ServiceModel.SR.GetString("ReceiveShutdownReturnedMessage", new object[] { message.Headers.Action })));
}
public FaultReason(IEnumerable<FaultReasonText> translations)
{
if (translations == null)
throw DiagnosticUtility.ExceptionUtility.ThrowHelperError(new ArgumentNullException("translations"));
int count = 0;
foreach (FaultReasonText faultReasonText in translations)
count++;
if (count == 0)
throw DiagnosticUtility.ExceptionUtility.ThrowHelperError(new ArgumentException(SR.GetString(SR.AtLeastOneFaultReasonMustBeSpecified), "translations"));
FaultReasonText[] array = new FaultReasonText[count];
int index = 0;
foreach (FaultReasonText faultReasonText in translations)
{
if (faultReasonText == null)
throw DiagnosticUtility.ExceptionUtility.ThrowHelperArgument("translations", SR.GetString(SR.NoNullTranslations));
array[index++] = faultReasonText;
}
Init(array);
}
public bool KiemTraTaiKhoan(string id, string mk)
{
try
{
KiemTra.CheckCa2(id, mk);
KiemTra.ID(id);
KiemTra.MatKhau(mk);
}
catch (ArgumentException ex)
{
throw new FaultException(ex.Message);
}
catch (Exception exp)
{
FaultReasonText reason = new FaultReasonText("Error processing invoice");
throw new FaultException(new FaultReason(reason), FaultCode.CreateReceiverFaultCode(new FaultCode("ApproveInvoice")));
//throw new FaultException("Basic Exception (hard coded for Ids 11-20).");
}
return true;
}
internal static ProtocolException OneWayOperationReturnedNonNull(Message message)
{
if (message.IsFault)
{
try
{
MessageFault fault = MessageFault.CreateFault(message, 64 * 1024);
FaultReasonText reason = fault.Reason.GetMatchingTranslation(CultureInfo.CurrentCulture);
string text = SR.Format(SR.OneWayOperationReturnedFault, reason.Text);
return(new ProtocolException(text));
}
catch (QuotaExceededException)
{
string text = SR.Format(SR.OneWayOperationReturnedLargeFault, message.Headers.Action);
return(new ProtocolException(text));
}
}
else
{
string text = SR.Format(SR.OneWayOperationReturnedMessage, message.Headers.Action);
return(new ProtocolException(text));
}
}
public FaultReason(FaultReasonText translation)
{
}
public FaultReason (FaultReasonText translation)
{
if (translation == null)
throw new ArgumentNullException ("translation");
trans.Add (translation);
}
private void Init(FaultReasonText[] translations)
{
this.translations = new SynchronizedReadOnlyCollection<FaultReasonText>(new object(), Array.AsReadOnly<FaultReasonText>(translations));
}
private void Init(FaultReasonText translation)
{
this.Init(new FaultReasonText[] { translation });
}
private void Init(FaultReasonText[] translations)
{
_translations = new SynchronizedReadOnlyCollection<FaultReasonText>(new object(), new ReadOnlyCollection<FaultReasonText>(translations));
}
public void UpdateData(int Id, TranferRecord data)
{
try
{
string connectionString = "Data Source=mavi-PC;Initial Catalog=cnweb;Integrated Security=True";
myConnection = new SqlConnection(connectionString);
// Open connection
myConnection.Open();
string updateCement = "UPDATE tamtrutamvang SET FullName=@FullName,PhoneNumber=@PhoneNumber,Email=@Email,Birthday=@Birthday,Sex=@Sex,OriginalAddress=@OriginalAddress,IDNumber=@IDNumber,Occupation=@Occupation,CurrentAddress=@CurrentAddress,FromDate=@FromDate,ToDate=@ToDate,Reason=@Reason,Description=@Description,Type=@Type WHERE Id = " + Id;
SqlCommand cmd = new SqlCommand(updateCement, myConnection);
cmd.Parameters.AddWithValue("@FullName", data.FullName);
cmd.Parameters.AddWithValue("@PhoneNumber", data.PhoneNumber);
cmd.Parameters.AddWithValue("@Email", data.Email);
cmd.Parameters.AddWithValue("@Birthday", data.Birthday.ToString("yyyy-MM-dd"));
cmd.Parameters.AddWithValue("@Sex", data.Sex);
cmd.Parameters.AddWithValue("@OriginalAddress", data.OriginalAddress);
cmd.Parameters.AddWithValue("@IDNumber", data.IDNumber);
cmd.Parameters.AddWithValue("@Occupation", data.Occupation);
cmd.Parameters.AddWithValue("@CurrentAddress", data.CurrentAddress);
cmd.Parameters.AddWithValue("@FromDate", data.FromDate.ToString("yyyy-MM-dd"));
cmd.Parameters.AddWithValue("@ToDate", data.ToDate.ToString("yyyy-MM-dd"));
cmd.Parameters.AddWithValue("@Reason", data.Reason);
cmd.Parameters.AddWithValue("@Description", data.Description);
cmd.Parameters.AddWithValue("@Type", data.Type);
cmd.ExecuteNonQuery();
// close connection
myConnection.Close();
}
catch (PisNotFoundException exp)
{
TrackedFault tf = new TrackedFault(
Guid.NewGuid(),
exp.Message,
DateTime.Now);
throw new FaultException<TrackedFault>(
tf,
new FaultReason("PisNotFoundException"),
FaultCode.CreateReceiverFaultCode(new FaultCode("UpdatInformation")));
}
catch (Exception exp)
{
FaultReasonText reason = new FaultReasonText(exp.Message);
throw new FaultException(new FaultReason(reason), FaultCode.CreateReceiverFaultCode(new FaultCode("UpdatInformation")));
}
}
public string GetAuthor()
{
try
{
string nhom = "Nhóm: 10";
string hoten = "Họ tên: Dương Quốc Việt";
string mssv = "MSSV: 09263L";
string kq = nhom + "\n" + hoten + "\n" + mssv;
return kq;
}
catch (FaultOutOfMemory exp)
{
throw new FaultException("Out of memory!!",
FaultCode.CreateReceiverFaultCode(new FaultCode("GetAuthor")));
}
catch (Exception exp)
{
FaultReasonText reason = new FaultReasonText(exp.Message);
throw new FaultException(new FaultReason(reason), FaultCode.CreateReceiverFaultCode(new FaultCode("GetAuthor")));
}
}
public TranferRecord[] GetListByDate(string Address, DateTime FromDate, DateTime ToDate, string type)
{
try
{
SqlConnection cn = new SqlConnection();
cn.ConnectionString = "Data Source=mavi-PC;Initial Catalog=cnweb;Integrated Security=True";
cn.Open();
string str1 = FromDate.ToString("yyyy-MM-dd");
string str2 = ToDate.ToString("yyyy-MM-dd");
string query = "SELECT * FROM tamtrutamvang WHERE CurrentAddress like '%" + Address + "%' and FromDate >= '" + str1 + "' or ToDate <= '" + str2 + "' and Type = '" + type + "'";
SqlCommand sql = new SqlCommand(query, cn);
SqlDataAdapter adt = new SqlDataAdapter(sql);
DataSet ds = new DataSet();
adt.Fill(ds);
int rows = ds.Tables[0].Rows.Count;
data = new TranferRecord[rows];
for (int i = 0; i < rows; i++)
{
data[i] = new TranferRecord();
data[i].Id = Convert.ToInt32(ds.Tables[0].Rows[i].ItemArray[0].ToString());
data[i].FullName = ds.Tables[0].Rows[i].ItemArray[1].ToString();
data[i].PhoneNumber = ds.Tables[0].Rows[i].ItemArray[2].ToString();
data[i].Email = ds.Tables[0].Rows[i].ItemArray[3].ToString();
data[i].Birthday = Convert.ToDateTime(ds.Tables[0].Rows[i].ItemArray[4]);
data[i].Sex = ds.Tables[0].Rows[i].ItemArray[5].ToString();
data[i].OriginalAddress = ds.Tables[0].Rows[i].ItemArray[6].ToString();
data[i].IDNumber = ds.Tables[0].Rows[i].ItemArray[7].ToString();
data[i].Occupation = ds.Tables[0].Rows[i].ItemArray[8].ToString();
data[i].CurrentAddress = ds.Tables[0].Rows[i].ItemArray[9].ToString();
data[i].FromDate = Convert.ToDateTime(ds.Tables[0].Rows[i].ItemArray[10]);
data[i].ToDate = Convert.ToDateTime(ds.Tables[0].Rows[i].ItemArray[11]);
data[i].Reason = ds.Tables[0].Rows[i].ItemArray[12].ToString();
data[i].Description = ds.Tables[0].Rows[i].ItemArray[13].ToString();
data[i].Type = ds.Tables[0].Rows[i].ItemArray[14].ToString();
}
cn.Close();
return data;
}
catch (PisNotFoundException exp)
{
TrackedFault tf = new TrackedFault(
Guid.NewGuid(),
exp.Message,
DateTime.Now);
throw new FaultException<TrackedFault>(
tf,
new FaultReason("PisNotFoundException"),
FaultCode.CreateReceiverFaultCode(new FaultCode("GetListByDate")));
}
catch (Exception exp)
{
FaultReasonText reason = new FaultReasonText(exp.Message);
throw new FaultException(new FaultReason(reason), FaultCode.CreateReceiverFaultCode(new FaultCode("GetListByDate")));
}
}
public TranferRecord[] CountSexByAddress(string Address, string type)
{
try
{
SqlConnection cn = new SqlConnection();
cn.ConnectionString = "Data Source=mavi-PC;Initial Catalog=cnweb;Integrated Security=True";
cn.Open();
string query = "SELECT Sex, COUNT(Sex) AS Total";
query += " FROM tamtrutamvang";
query += " WHERE CurrentAddress LIKE '%" + Address + "%' and type = '" + type + "'";
query += " GROUP BY Sex";
SqlCommand sql = new SqlCommand(query, cn);
SqlDataAdapter adt = new SqlDataAdapter(sql);
DataSet ds = new DataSet();
adt.Fill(ds);
int rows = ds.Tables[0].Rows.Count;
data = new TranferRecord[rows];
for (int i = 0; i < rows; i++)
{
data[i] = new TranferRecord();
data[i].Sex = ds.Tables[0].Rows[i].ItemArray[0].ToString();
data[i].Total = int.Parse(ds.Tables[0].Rows[i].ItemArray[1].ToString());
}
cn.Close();
return data;
}
catch (PisNotFoundException exp)
{
TrackedFault tf = new TrackedFault(
Guid.NewGuid(),
exp.Message,
DateTime.Now);
throw new FaultException<TrackedFault>(
tf,
new FaultReason("PisNotFoundException"),
FaultCode.CreateReceiverFaultCode(new FaultCode("GetListOccupationByAddress")));
}
catch (Exception exp)
{
FaultReasonText reason = new FaultReasonText(exp.Message);
throw new FaultException(new FaultReason(reason), FaultCode.CreateReceiverFaultCode(new FaultCode("GetListOccupationByAddress")));
}
}
void Init(FaultReasonText translation)
{
Init(new FaultReasonText[] { translation });
}
public void CreateFaultMessageAndWrite ()
{
string xml = @"<s:Envelope xmlns:a=""http://www.w3.org/2005/08/addressing"" xmlns:s=""http://www.w3.org/2003/05/soap-envelope""><s:Header><a:Action s:mustUnderstand=""1"">http://www.w3.org/2005/08/addressing/fault</a:Action></s:Header><s:Body><s:Fault><s:Code><s:Value xmlns:a=""urn:me"">a:me</s:Value></s:Code><s:Reason><s:Text xml:lang="""">am so lazy</s:Text></s:Reason></s:Fault></s:Body></s:Envelope>";
FaultCode fc = new FaultCode ("me", "urn:me");
FaultReasonText ft = new FaultReasonText ("am so lazy", CultureInfo.InvariantCulture);
Message msg = Message.CreateMessage (
MessageVersion.Default,
MessageFault.CreateFault (fc, new FaultReason (ft)),
"http://www.w3.org/2005/08/addressing/fault");
// It should be XML comparison, not string comparison
Assert.AreEqual (xml, GetSerializedMessage (msg));
}
private void Init(FaultReasonText translation)
{
this.Init(new FaultReasonText[] { translation });
}
void Init(FaultReasonText translation)
{
Init(new FaultReasonText[] { translation });
}
public void DeleteData(int Id)
{
try
{
string connectionString = "Data Source=mavi-PC;Initial Catalog=cnweb;Integrated Security=True";
myConnection = new SqlConnection(connectionString);
// Open connection
myConnection.Open();
string updateCement = "DELETE tamtrutamvang WHERE Id = " + Id;
SqlCommand cmd = new SqlCommand(updateCement, myConnection);
cmd.ExecuteNonQuery();
// close connection
myConnection.Close();
}
catch (PisNotFoundException exp)
{
TrackedFault tf = new TrackedFault(
Guid.NewGuid(),
exp.Message,
DateTime.Now);
throw new FaultException<TrackedFault>(
tf,
new FaultReason("PisNotFoundException"),
FaultCode.CreateReceiverFaultCode(new FaultCode("DeleteInformation")));
}
catch (Exception exp)
{
FaultReasonText reason = new FaultReasonText(exp.Message);
throw new FaultException(new FaultReason(reason), FaultCode.CreateReceiverFaultCode(new FaultCode("DeleteInformation")));
}
}
internal static FaultReason Construct(FaultReasonData[] nodes)
{
FaultReasonText[] reasons = new FaultReasonText[nodes.Length];
for (int i = 0; i < nodes.Length; i++)
{
reasons[i] = new FaultReasonText(nodes[i].text, nodes[i].xmlLang);
}
return new FaultReason(reasons);
}
public FaultReason(FaultReasonText translation)
{
}
