public static CustomsAgent SelectByUnPw(string Username, string Password)
{
string query = "SELECT * FROM CustomsAgent WHERE Username = @Username AND Password = @Password";
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(new SqlParameter("@Username", Username));
parameters.Add(new SqlParameter("@Password", Password));
DataTable dt = DBHelper.SelectData(query, parameters);
CustomsAgent C = new CustomsAgent();
if (dt.Rows.Count > 0)
{
C.CustomsAgentID = Convert.ToInt32(dt.Rows[0]["CustomsAgentID"].ToString());
C.Name = dt.Rows[0]["Name"].ToString();
C.Email = dt.Rows[0]["Email"].ToString();
C.Mobile = dt.Rows[0]["Mobile"].ToString();
C.Photo = dt.Rows[0]["Photo"].ToString();
C.Username = dt.Rows[0]["Username"].ToString();
C.Password = dt.Rows[0]["Password"].ToString();
C.IsActive = Convert.ToBoolean(dt.Rows[0]["IsActive"].ToString());
C.Country = dt.Rows[0]["Country"].ToString();
C.Port = dt.Rows[0]["Port"].ToString();
}
return(C);
}
public static int Insert(CustomsAgent C)
{
string query = "INSERT INTO CustomsAgent VALUES(@Name,@Email,@Mobile,@Photo,@Username,@Password,@IsActive,@Country,@Port)";
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(new SqlParameter("@Name", C.Name));
parameters.Add(new SqlParameter("@Email", C.Email));
parameters.Add(new SqlParameter("@Mobile", C.Mobile));
parameters.Add(new SqlParameter("@Photo", C.Photo));
parameters.Add(new SqlParameter("@Username", C.Username));
parameters.Add(new SqlParameter("@Password", C.Password));
parameters.Add(new SqlParameter("@IsActive", C.IsActive));
parameters.Add(new SqlParameter("@Country", C.Country));
parameters.Add(new SqlParameter("@Port", C.Port));
return(DBHelper.ModifyData(query, parameters));
}
public static int Update(CustomsAgent C)
{
string query = "UPDATE CustomsAgent SET Name = @Name, Email = @Email, Mobile = @Mobile,Photo = @Photo,Username = @Username,Password = @Password, IsActive = @IsActive,Country = @Country,Port=@Port WHERE CustomsAgentID = @CustomsAgentID";
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(new SqlParameter("@CustomsAgentID", C.CustomsAgentID));
parameters.Add(new SqlParameter("@Name", C.Name));
parameters.Add(new SqlParameter("@Email", C.Email));
parameters.Add(new SqlParameter("@Mobile", C.Mobile));
parameters.Add(new SqlParameter("@Photo", C.Photo));
parameters.Add(new SqlParameter("@Username", C.Username));
parameters.Add(new SqlParameter("@Password", C.Password));
parameters.Add(new SqlParameter("@IsActive", C.IsActive));
parameters.Add(new SqlParameter("@Country", C.Country));
parameters.Add(new SqlParameter("@Port", C.Port));
return(DBHelper.ModifyData(query, parameters));
}
public static CustomsAgent SelectByPK(int ID)
{
string query = "SELECT * FROM CustomsAgent WHERE CustomsAgentID = @ID";
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(new SqlParameter("@ID", ID));
DataTable dt = DBHelper.SelectData(query, parameters);
CustomsAgent C = new CustomsAgent();
C.CustomsAgentID = ID;
C.Name = dt.Rows[0]["Name"].ToString();
C.Email = dt.Rows[0]["Email"].ToString();
C.Mobile = dt.Rows[0]["Mobile"].ToString();
C.Photo = dt.Rows[0]["Photo"].ToString();
C.Username = dt.Rows[0]["Username"].ToString();
C.Password = dt.Rows[0]["Password"].ToString();
C.IsActive = Convert.ToBoolean(dt.Rows[0]["IsActive"].ToString());
C.Country = dt.Rows[0]["Country"].ToString();
C.Port = dt.Rows[0]["Port"].ToString();
return(C);
}
