public static String FormatDocumentNo(String DocumentType, Decimal doc_no)
{
// GET NEXT DOCUMENT NUMBER AND DOCUMENT NUMBER SHOULD BE LIST THIS PR00001
int A = DatabaseConnectionSqlServer.ExecuteNonQueryInternal("update next_doc_no set next_doc_no=" + doc_no + "+ 1 where Doc_type ='" + DocumentType + "'");
String FormattedNo = "";
FormattedNo = DocumentType.Substring(0, 1);
String year = System.DateTime.Today.Year.ToString();
FormattedNo += year.Substring(2);
year = System.DateTime.Today.AddYears(1).Year.ToString().Substring(2);
FormattedNo += year;
int LengthOfCurrentDocNo = doc_no.ToString().Length;
for (int i = 1; i <= DOCUMENTNOPORTIONLENGTH - LengthOfCurrentDocNo; i++)
{
FormattedNo += "0";
}
FormattedNo += doc_no.ToString();
return(FormattedNo);
}
public static DataTable GetAllCustomer(string CompanyLink)
{
MySqlParameter[] parameters =
{
new MySqlParameter("CompanyLink", CompanyLink)
};
return(DatabaseConnectionSqlServer.GetDataTable("GetAllCustomer", parameters));
}
public static DataTable GetAllProjectFilter(string filter, string CompanyLink)
{
MySqlParameter[] parameters =
{
new MySqlParameter("filter", filter),
new MySqlParameter("CompanyLink", CompanyLink),
};
return(DatabaseConnectionSqlServer.GetDataTable("GetAllProjectFilter", parameters));
}
public static bool SendMail(string subject, string body, string MailTo, string CompanyLink)
{
// SEND MAIL
bool issuccess = false;
string emailfrom = string.Empty;
string password = string.Empty;
DataTable dt = DatabaseConnectionSqlServer.GetDataTable("Select Email.* from Email where Email.IsDeactivate=0 and Email.CompanyLink='" + CompanyLink + "'");
if (dt.Rows.Count > 0)
{
emailfrom = dt.Rows[0]["Email"].ToString();
password = dt.Rows[0]["Password"].ToString();
}
else
{
emailfrom = ConfigurationManager.AppSettings["EmailId"].ToString();
password = ConfigurationManager.AppSettings["Password"].ToString();
}
string port = ConfigurationManager.AppSettings["Port"].ToString();
string host = ConfigurationManager.AppSettings["Host"].ToString();
string enablessl = ConfigurationManager.AppSettings["EnableSSL"].ToString();
SmtpClient SmtpServer = new SmtpClient();
SmtpServer.Credentials = new System.Net.NetworkCredential(emailfrom, password);
SmtpServer.Port = Convert.ToInt32(port);
SmtpServer.Host = host;
SmtpServer.EnableSsl = Convert.ToBoolean(enablessl);
MailMessage mail = new MailMessage();
//mail.IsBodyHtml = true;
mail.From = new MailAddress(emailfrom, emailfrom, System.Text.Encoding.UTF8);
mail.Subject = subject;
mail.To.Add(MailTo);
//mail.To.Add("*****@*****.**");
//mail.To.Add("*****@*****.**");
mail.IsBodyHtml = true;
mail.Body = body;
try
{
SmtpServer.Send(mail);
issuccess = true;
}
catch (Exception ex)
{
issuccess = false;
//File.AppendAllText(@"c:\projects\ScheduledService.txt", "\nError at :\n " + ex.Message + "\n" + DateTime.Now.ToString());
}
return(issuccess);
}
public static DataTable GetItemByProjectNo(string ProjectNo)
{
// GET PROJECT DETAIL USING PROJECT NUMBER
MySqlParameter[] parameters =
{
new MySqlParameter("ProjectNo", ProjectNo)
};
return(DatabaseConnectionSqlServer.GetDataTable("GetItemByProjectNo", parameters));
}
public static DataTable GetDuplicateCustomer(string Customer, string CompanyLink)
{
// GET DUPLICATE CUSTOMER USING NAME
MySqlParameter[] parameters =
{
new MySqlParameter("Customer", Customer),
new MySqlParameter("CompanyLink", CompanyLink)
};
return(DatabaseConnectionSqlServer.GetDataTable("GetDuplicateCustomer", parameters));
}
public static object ActivateRecordByLink(string TableName, string ColumnName, string Value)
{
// ACTIVATE RECORD FROM TABLE , USING TABLE NAME , COLUMN NAME (MOSTALLY LINK) AND VALUE OF THAT COLUMN
MySqlParameter[] parameters =
{
new MySqlParameter("TableName", TableName),
new MySqlParameter("FieldName", ColumnName),
new MySqlParameter("FieldValue", Value)
};
return(DatabaseConnectionSqlServer.ExecuteNonQuery("ActivateRecordByLink", parameters));
}
public static DataTable GetDocNo(string DocType)
{
// GET DOCUMENT NUMBER
MySqlParameter[] parameters =
{
new MySqlParameter("DocType", DocType)
};
DataTable dt = DatabaseConnectionSqlServer.GetDataTable("GetDocNo", parameters);
return(dt);
}
public static DataTable GetMenusByUserType(int PLink, string UserLink, string UserType, string IsTop)
{
// GET MENUS FOR LOGIN USER USING USER TYPE
MySqlParameter[] parameters =
{
new MySqlParameter("ParentLink", PLink),
new MySqlParameter("UserLink", UserLink),
new MySqlParameter("UserType", UserType),
new MySqlParameter("IsTop", IsTop)
};
return(DatabaseConnectionSqlServer.GetDataTable("GetMenusByUserType", parameters));
}
public static object DeleteRecordByLink(string TableName, string ColumnName, string Value)
{
// DELETE RECORD FROM TABLE , USING TABLE NAME , COLUMN NAME (MOSTALLY LINK) AND VALUE OF THAT COLUMN
MySqlParameter[] parameters =
{
new MySqlParameter("TableName", TableName),
new MySqlParameter("FieldName", ColumnName),
new MySqlParameter("FieldValue", Value)
};
// DeactivateRecordByLink is a stored procedure name and Above Parameter list for the stored procedure
return(DatabaseConnectionSqlServer.ExecuteNonQuery("DeactivateRecordByLink", parameters));
}
